Skip to main content

Json To Data Table

Converts JSON data to a data table format.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Json Data - The JSON data to be converted to a data table format.

Options​

  • Output Type - Specifies whether to pass the table by reference or by value. Options are:
    • Pass By Reference
    • Pass By Value

Output​

  • Table - The resulting data table converted from the JSON data.

How It Works​

The Json To Data Table node converts JSON data to a data table format. When executed, the node:

  1. Validates that the JSON data is not empty
  2. Converts the JSON data to a pandas DataFrame
  3. Converts the DataFrame to a dictionary format with columns and rows
  4. Returns the data table

Requirements​

  • Valid JSON data in a format compatible with pandas DataFrame conversion
  • The JSON data should be structured as an array of objects or a dictionary

Error Handling​

The node will return specific errors in the following cases:

  • Empty JSON data
  • Invalid JSON format
  • JSON data structure incompatible with pandas DataFrame conversion

Usage Notes​

  • The Output Type option can be set to "Pass By Reference" for handling large JSON datasets more efficiently
  • The JSON data should be structured appropriately for conversion to a tabular format
  • The keys in the JSON objects become column headers in the resulting table
  • Nested JSON structures may need to be flattened before conversion