The Convert JSON to Table action enables you to convert a JSON string into a table. You can assign a table variable to hold the converted values.

The Convert JSON to Table action fetches the JSON source defined in the Start session action using the session name. Ensure that the session name in both actions is the same. The action converts the JSON sample keys as the column title and their corresponding values as individual rows in the table. For nested data, the action converts the arrays within the JSON sample as a list within the table and the contents of each array into a dictionary within the list.

Settings

The following fields are available in Convert JSON to Table action:

Session name
The session identifier defined in the Start session action. You can provide a string variable or use a session variable.
Assign output to a variable
The table variable that holds the converted values.