To transform, fetch, and convert JavaScript Object Notation (JSON) data as part of a chain, add a step that includes a JSON connection command.
To enable these commands, an IT admin first creates a JSON connection.
Array to CSV
To convert a JSON array to a CSV file, given each column's name and the JSONPath to its values, use an Array to CSV command. If a column has multiple values, they're separated by the selected delimiter.
Properties
| Property |
Detail |
| JSON data |
Enter the file or text to parse as JSON and convert. |
| Path to root |
To convert an array nested inside the root element of the JSON, enter the path of the root array element to convert to CSV. |
| Filter |
Add a filter to the array of items. To apply no filter, leave blank. |
| Multi-value delimiter |
Enter the delimiter to use to separate multiple values retrieved for a single JSONPath in a column. |
| Preview result |
To preview the created CSV file, check this box. |
| Columns |
Enter the columns to produce, and their corresponding JSONPaths.
Note: To help successfully produce the columns, test the JSONPaths.
|
| Delimiter |
Select the delimiter to use in the converted file. |
Outputs
| Output |
Output type |
| Converted file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Error running the command |
| 10 |
Warning |
JSON parsed doesn't match the schema provided |
CSV to JSON
To convert a tabular data set to a JSON array, use a CSV to JSON command.
Properties
| Property |
Detail |
| Input file |
Enter the CSV file to convert to JSON. |
| Delimiter |
Select the delimiter used in Input File. |
Outputs
| Output |
Output type |
| JSON file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Error running the command |
Object to CSV
To convert a JSON object to a CSV file with a single row, given each column's name and the JSONPath to its values, use an Object to CSV command. If a column has multiple values, they're separated by the selected delimiter.
Properties
| Property |
Detail |
| JSON data |
Enter the file or text to parse as JSON and validate. |
| Path to root |
If the object to convert is nested in the root element of the CSV, enter the path to the root object element to convert to a CSV. |
| Multi-value delimiter |
Select the delimiter to use to separate multiple values retrieves for a single JSONPath in a column. |
| Preview result |
Select whether to preview the created CSV file. |
| Columns |
Enter the columns to produce and their corresponding JSONPaths. |
Outputs
| Output |
Output type |
| Output |
Output Type |
| Converted file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Error running the command |
| 10 |
Warning |
JSON parsed doesn't match the schema provided |
Validate schema
To parse a file or text as JSON, use a Validate schema command. After parsing the JSON, the schema provided is validated against the result. The output is a JSON file for use in other commands.
Properties
| Property |
Detail |
| JSON data |
Enter the file or text to parse as JSON and validate. |
| Schema |
Enter the schema to validate the parsed JSON against. |
Outputs
| Output |
Output type |
| Parsed file |
File |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
Error running the command |
| 10 |
Warning |
JSON parsed doesn't match the schema provided |