Table of Contents

Connections

Commands

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

JSON Data

FileField

The input file to parse as JSON and validate. If this is set Input Text will be ignored.

Input Text (Deprecated)

TextField

This input is deprecated, please use the JSON Data input instead

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

JSON Data

FileField

The input file to parse as JSON and validate. If this is set Input Text will be ignored.

Input Text (Deprecated)

TextField

This input is deprecated, please use the JSON Data input instead

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

JSON Data

FileField

The input file to parse as JSON and validate. If this is set Input Text will be ignored.

Input Text (Deprecated)

TextField

This input is deprecated, please use the JSON Data input instead

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

Did this answer your question?