Document toolboxDocument toolbox

To string (stringify)

Description

Converts a JSON object (json data type) into string data type.

How does it work in the search window? 

Select Create column in the search window toolbar, then select the To string (stringify) operation. You need to specify one argument:

Argument

Data type

Argument

Data type

Json mandatory

json

The data type of the values in the new column is string.

There might be some changes in the resulting string, for example, the order of the key/value pairs or the spaces between the different elements.

Example

We want to transform the JSON objects in our myJSON column into string format. To do it, click Create column and select the To string (stringify) operation. The arguments needed are:

  • Json - myJSON column

Click Create column and you will see the following result:

How does it work in LINQ?

Use the operator select... as...  and add the operation syntax to create the new column. This is the syntax of the To string (stringify) operation:

  • stringify(json)