jsonToTable

[ 1 Operator usage in easy mode ] [ 2 Usage details ] [ 3 Example ]

jsonToTable operator takes the JSON array from the first row of input and converts it to a table.

Operator usage in easy mode

Click + on the parent node.
Enter the JSON to Table operator in the search field and select the operator from the Results to open the operator form.
In the Table drop-down, enter or select the table containing the data to run this operator on.
In the Column field, enter the name of the column to convert a JSON object to the table.
Click Run to view the result.
Click Save to add the operator to the playbook.
Click Cancel to discard the operator form.

Usage details

LQL

jsonToTable(table, "column")

Input
table (TableReference): The table to which the operator is applied.
column (String): xpath to array of json object, e.g. column.data.users where column is column name, .data.users is a path to array of json ([{..}, {..}, {..}] format)

Output
A table that converts the values in the JSON file to a table.

Example

Table: A
column: json.flows

json

{
  "flows": [
     {
       "name": "Playbook_0703",
       "nodes": 123 
     },
     {
       "name": "Playbook_0704",
       "nodes": 456
     }
  ]
}

jsonToTable(A, "json.flows")

Output

This table represents the conversion of the JSON to table format.

Name	Nodes

Name	Nodes
Playbook_0703	123
Playbook_0704	456