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 |
|---|---|
| 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)