| Table of Contents | ||||
|---|---|---|---|---|
|
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 field 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 field with json data type.
|
The data type of the values in the new column field is json.
Example
In this example, in the demosiem.logtrust.ecommerceweb.dataactivity table, we will manually specify a string to create a json columnfield, which can be later used as an argument in the Jq evaluation (jqeval) operation.
Click the Create Columnfield button on the toolbar, select the To json (jsonparse) operation and give the new column field 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 field and a new column field will be created with the specified string in json data type.
...
Now you have your new column field ready to use as an argument in the Jq evaluation (jqeval) operation.
...
Use the operator select... as... and add the operation syntax to create the new columnfield. 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 demosiem.logtrust.ecommerceweb.dataactivity):
| Code Block |
|---|
from demosiem.logtrust.ecommerceweb.dataactivity select jsonparse("{ \"name\":\"John\", \"birth\":\"1986-12-14\", \"city\":\"New York\"}") as Json |