JSON Parse Tool
One Tool Example
JSON Parse has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.
Use JSON Parse to separate JavaScript Object Notation (JSON) text into a table schema for downstream processing. You can feed the output into the JSON Build tool to rebuild it into usable JSON format.
Configure the Tool
JSON Field: Select the fields that hold JSON text. The field must contain valid JSON with all the text for a record in a single cell. Refer to this example:
{ "firstName": "John", "lastName": "Smith", "age": 25, "address": { "streetAddress": "21 2nd Street", "city": "New York", "state": "NY", "postalCode": "10021" }, "phoneNumber": [ { "type": "home", "number": "212 555-1234" }, { "type": "fax", "number": "646 555-4567" } ] }
Include in Output: The selected column is included in the data stream coming out of the tool.
Choose how the JSON gets parsed. Choices include:
Output values into single string field: Outputs 2 fields: JSON_Name
and JSON_ValueString
. Using the input example above, this data comes out of the tool:
JSON_Name | JSON_ValueString |
---|---|
firstName | John |
lastName | Smith |
age | 25 |
address.streetAddress | 21 2nd Street |
address.city | New York |
address.state | NY |
address.postalCode | 10021 |
phoneNumber.0.type | home |
phoneNumber.0.number | 212-555-1234 |
phoneNumber.1.type | fax |
phoneNumber.1.number | 646-555-4567 |
Output values into data type specific fields: Five fields are output.
Field Name | Description |
---|---|
JSON_Name | The JSON_Name is the 'key' of a JSON Object (key:value pair). A dot separates the key and any hierarchical categories. |
JSON_Value String | The corresponding string 'value' of the JSON Object (key:value pair). If the value is not a string, it will display as [Null]. |
JSON_ValueInt | The corresponding integer 'value' of the JSON Object (key:value pair). If the value is not an integer, it will display as [Null]. |
JSON_ValueFloat | The corresponding float 'value' of the JSON Object (key:value pair). If the value is not a float, it will display as [Null]. |
JSON_ValueBool | The corresponding bool 'value' of the JSON Object (key:value pair). If the value is not a bool, it will display as [Null]. |
Example Output
JSON_Name | JSON_ValueString | JSON_ValueInt | JSON_ValueFloat | JSON_ValueBool |
---|---|---|---|---|
firstName | John | [Null] | [Null] | [Null] |
lastName | Smith | [Null] | [Null] | [Null] |
age | [Null] | 25 | [Null] | [Null] |
address.streetAddress | 21 2nd Street | [Null] | [Null] | [Null] |
address.city | New York | [Null] | [Null] | [Null] |
address.state | NY | [Null] | [Null] | [Null] |
address.postalCode | 10021 | [Null] | [Null] | [Null] |
phoneNumber.0.type | home | [Null] | [Null] | [Null] |
phoneNumber.0.number | 212-555-1234 | [Null] | [Null] | [Null] |
phoneNumber.1.type | fax | [Null] | [Null] | [Null] |
phoneNumber.1.number | 646-555-4567 | [Null] | [Null] | [Null] |