Help Desk

Submit a ticket My Tickets
Welcome
Login

JSON Command Reference

The JSON BizApp helps work with transforming, fetching and converting JSON data

Connections

JSON

Connection for using the JSON BizApp

Inputs

None

Commands

Array to CSV

Converts a JSON array to a CSV file. Specify the names of the columns and the JSONPath to the desired value(s) for the column. If multiple values are retrieved for a single column, they will be separated by the chosen delimiter.

Inputs

Input Type Detail Notes
Input File FileField The input file to parse as JSON and validate. If this is set Input Text will be ignored.
Input Text TextField Text to parse as JSON and validate. If Input File is set this will be ignored.
Path to root ArrayField This is the path to the root array element to be converted to a CSV. Use this if the array you would like to convert is nested inside the root element of the JSON.
Filter TextField Optionally add a filter to the array of items. Leave this blank to apply no filter. (e.g. ?(@.price < 1000))
Multi-value Delimiter TextField If there are multiple values retrieved for a single JSONPath in a column, they will be separated by this delimiter.
Preview Result BooleanField Preview the created CSV file
Columns GroupField The columns to produce and their corresponding JsonPaths
Delimiter DropdownField The delimiter to use in the output tabular dataset.

Outputs

Output Output Type Notes
Converted File File

Exit Codes

Code Type Detail
0 Success Success
1 Error Error running the command
10 Warning The JSON parsed does not match the schema provided

CSV to JSON

Converts a CSV to a JSON array

Inputs

Input Type Detail Notes
Input File FileField CSV file to be converted to JSON
Delimiter DropdownField CSV delimiter

Outputs

Output Output Type Notes
JSON File File

Exit Codes

Code Type Detail
0 Success Command completed successfully
1 Error Error executing command

Object To CSV

Converts a JSON object to a CSV file with a single row. Specify the names of the columns and the JSONPath to the desired value(s) for the column. If multiple values are retrieved for a single column, they will be separated by the chosen delimiter.

Inputs

Input Type Detail Notes
Input File FileField The input file to parse as JSON and validate. If this is set Input Text will be ignored.
Input Text TextField Text to parse as JSON and validate. If Input File is set this will be ignored.
Path to root ArrayField This is the path to the root object element to be converted to a CSV. Use this if the object you would like to convert is nested inside the root element of the JSON.
Multi-value Delimiter TextField If there are multiple values retrieved for a single JSONPath in a column, they will be separated by this delimiter.
Preview Result BooleanField Preview the created CSV file
Columns GroupField The columns to produce and their corresponding JsonPaths
Delimiter DropdownField The delimiter to use in the output tabular dataset.

Outputs

Output Output Type Notes
Converted File File

Exit Codes

Code Type Detail
0 Success Success
1 Error Error running the command
10 Warning The JSON parsed does not match the schema provided

Validate Schema

Takes a file or text and parses it as JSON. After parsing the JSON the schema provided will be validated against the result. The output is a JSON file for use in other commands.

Inputs

Input Type Detail Notes
Input File FileField The input file to parse as JSON and validate. If this is set Input Text will be ignored.
Input Text TextField Text to parse as JSON and validate. If Input File is set this will be ignored.
Schema TextField The schema of which to validate the parsed JSON against.

Outputs

Output Output Type Notes
Parsed File File
Valid String

Exit Codes

Code Type Detail
0 Success Success
1 Error Error running the command
10 Warning The JSON parsed does not match the schema provided
B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.