The JSON Parse tool separates Java Script Object Notation text into a table schema for the purpose of downstream processing. It can be built back up into usable JSON format by feeding the output into the JSON Build Tool.
JSON Field: Select the fields that holds Java Script Object Notation text. The field must contain valid JSON with all the text for a record in a single cell. See the example below.
JSON field |
---|
{ "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:
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 |
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]. |
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] |
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.