JSON Parser

This REST tool  outputs a list of names, a list of values, and a list of value types from a JSON object. This tool parses the name/value pairs and inner JSON alphabetically by name.  For more information, refer to the Interaction Designer REST APIs Developer's Guide in the PureConnect Documentation Library.

Inputs

JSON string

The JSON object to parse. For this tool to correctly parse the JSON object, all of the name elements in the name/value pairs listed in the JSON object must be unique.

Outputs

Names List

The list of parsed names.

Values List

The parallel list of the parsed value for each name in the Names List parameter.

Value Type List

A parallel list of the data type for each value found in the Values List parameter. Data types can include: string, bool, double, array, object (JSON), and null. These data types correspond to the JSON data types: string, Boolean, number, array, object (JSON), and null. Integer and floating-point output as a double type (corresponding to JSON's number type).

Exit Paths

Success

This path is taken if the operation is successful.

Failure

This path is taken if the operation fails.

JSON Parse Failure

This path is taken if the ION library cannot parse the JSON object in the JSON String parameter. This can result from a malformed or missing JSON object.