Skip to main content

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.

Text​

Inputs​

NameTypeRequiredDescription
JSONjsontrueThe JSON to parse
KeytexttrueThe key to extract, this could be a nested key (e.g. "data.name"

Outputs​

NameTypeDescription
DatatextThe 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​

NameTypeRequiredDescription
JSONjsontrueThe JSON to parse
KeytexttrueThe key to extract, this could be a nested key (e.g. "data.name"

Outputs​

NameTypeDescription
DatanumberThe extracted value

Output Event Triggers​

Name
Success
Not Found

Boolean​

Inputs​

NameTypeRequiredDescription
JSONjsontrueThe JSON to parse
KeytexttrueThe key to extract, this could be a nested key (e.g. "data.name"

Outputs​

NameTypeDescription
DatabooleanThe extracted value

Output Event Triggers​

Name
Success
Not Found

Text Array​

Inputs​

NameTypeRequiredDescription
JSONjsontrueThe JSON to parse
KeytexttrueThe key to extract, this could be a nested key (e.g. "data.name"

Outputs​

NameTypeDescription
Datatext-arrayThe extracted value

Output Event Triggers​

Name
Success
Not Found

Number Array​

Inputs​

NameTypeRequiredDescription
JSONjsontrueThe JSON to parse
KeytexttrueThe key to extract, this could be a nested key (e.g. "data.name"

Outputs​

NameTypeDescription
Datanumber-arrayThe extracted value

Output Event Triggers​

Name
Success
Not Found

JSON​

Inputs​

NameTypeRequiredDescription
JSONjsontrueThe JSON to parse
KeytexttrueThe key to extract, this could be a nested key (e.g. "data.name"

Outputs​

NameTypeDescription
DatajsonThe extracted value

Output Event Triggers​

Name
Success
Not Found