Parse JSON
Category: Processing
Description: Extracts a specific piece of information from a JSON object using a key. You can access nested data by separating keys with a dot. For example, to get the city from a user object, you could use the key 'address.city'. The 'Success' path is taken if the key is found, otherwise the 'Not Found' path is taken.
Related Modules
Text
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| JSON | json | true | The JSON to parse |
| Key | text | true | The key to extract, this could be a nested key (e.g. "data.name" |
Outputs
| Name | Type | Description |
|---|---|---|
| Data | text | The extracted value |
Output Event Triggers
| Name |
|---|
| Success |
| Not Found |
Examples
Extract nested user name
Inputs
-
JSON:
{"user": {"name": "Alice","id": 123},"status": "active"} -
Key:
"user.name"
Outputs
-
Data:
"Alice"
Number
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| JSON | json | true | The JSON to parse |
| Key | text | true | The key to extract, this could be a nested key (e.g. "data.name" |
Outputs
| Name | Type | Description |
|---|---|---|
| Data | number | The extracted value |
Output Event Triggers
| Name |
|---|
| Success |
| Not Found |
Boolean
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| JSON | json | true | The JSON to parse |
| Key | text | true | The key to extract, this could be a nested key (e.g. "data.name" |
Outputs
| Name | Type | Description |
|---|---|---|
| Data | boolean | The extracted value |
Output Event Triggers
| Name |
|---|
| Success |
| Not Found |
Text Array
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| JSON | json | true | The JSON to parse |
| Key | text | true | The key to extract, this could be a nested key (e.g. "data.name" |
Outputs
| Name | Type | Description |
|---|---|---|
| Data | text-array | The extracted value |
Output Event Triggers
| Name |
|---|
| Success |
| Not Found |
Number Array
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| JSON | json | true | The JSON to parse |
| Key | text | true | The key to extract, this could be a nested key (e.g. "data.name" |
Outputs
| Name | Type | Description |
|---|---|---|
| Data | number-array | The extracted value |
Output Event Triggers
| Name |
|---|
| Success |
| Not Found |
JSON
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| JSON | json | true | The JSON to parse |
| Key | text | true | The key to extract, this could be a nested key (e.g. "data.name" |
Outputs
| Name | Type | Description |
|---|---|---|
| Data | json | The extracted value |
Output Event Triggers
| Name |
|---|
| Success |
| Not Found |