To json (jsonparse)
- Juan Tomás Alonso Nieto (Deactivated)
Description
Converts a string data type into json data type, which is required as an argument for the Jq evaluation (jqeval) operation.
How does it work in the search window?
Select Create column in the search window toolbar, then select the To json operation. You need to specify one argument:
Argument | Data type | Description |
|---|---|---|
String to convert (mandatory) | string | The full sample with json syntax. You can manually enter the string or select a column with json data type. For a successful extraction using it as an argument in the Jq evaluation (jqeval) operation, it must contain valid json syntax. |
The data type of the values in the new column is json.
Example
In this example, we will manually specify a string to create a json column, which can be later used as an argument in the Jq evaluation (jqeval) operation.
Click the Create Column button on the toolbar, select the To json (jsonparse) operation and give the new column a name.
Add the necessary argument and configure it as shown in the picture below:
string to convert → manually introduced →  {"name":"John","birth":"1986-12-14","city":"New York"}
Click Create Column and a new column will be created with the specified string in json data type.
Now you have your new column ready to use as an argument in the Jq evaluation (jqeval) operation.
How does it work in LINQ?
Be aware that json syntax is expressed differently in LINQ. This is because some characters must be included for the json syntax to be recognized as a whole unit and as a set of individual parts at the same time. One of the examples is the backslash (\), an escape character used to bypass the closing double quotes (") that mark the end of a string, enabling you to extend it up to the desired point.
Use the operator select... as... and add the operation syntax to create the new column. This is the syntax for the To json operation:
jsonparse(string)
Example
You can use the following LINQ script to recreate the example above in any table (for example, in demo.ecommerce.data):
from demo.ecommerce.data
select jsonparse("{ \"name\":\"John\", \"birth\":\"1986-12-14\", \"city\":\"New York\"}") as Json