jsonToTable

Convert JSON array to a table.

Convert a JSON array to a table.

Operator Usage in Easy Mode

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

Usage Details

jsonToTable(table, "xpath")

Input
table: Name of the table that is created.
xpath: xpath to the JSON to be converted. Should start with a column name. Use “.” as a separator.

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

Example

Table: A
xpath: json.flows

{
  "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

Playbook_0703

123

Playbook_0704

456


Did this page help you?