Examples

These examples show the functionality of JSON Read node.

Example 1: The use case is to set a flow or cache variable variables to the Person_ID, City and Full_Address of some record.

The input data is:

{
   "id": 123,
   "name": "fred",
   "address": {
      "street": "101 Main St",
      "city": "London"
   }
}

and the Paths table is set as:

Path	Variable/Key
$.id	Person_ID
$.address.city	City
$.address	Full_Address

If the Variable Scope is set to flow or cache variables it will set these 3 variables:

Path	Variable/Key
Person_ID	123
City	London
Full_Address	{"street": "101 Main St", "city": "London"}

Note: If the path returns a JSON object or array, the value is the serialized form of that object or array.

If the Output Content property is set to filter the input, then the output in this example will be:

{
    "Person_ID": 123,
    "City": "London",
    "Full_Address": {
        "street": "101 Main St",
        "city": "London"
    }
}

Example 2: This example demonstrates the query expressions.

The use case is to set a flow variable to the mobile phone number of some record.

The input data is:

{
   "phones": [
     {
     "type": "mobile",
     "number": "111-222-3333"
     },
     {
     "type": "home",
     "number": "444-444-5555"
     }
   ]
}

The path expression to achieve this is:

Path	Variable/Key
$.phones[?(@.type == "mobile")].number	mobile

This means in the "phones" array, find the object whose "type" field is "mobile" and then return the "number" field from this object. This will result in this flow variable:

Name	Value
mobile	111-222-3333

If the Output Content property is set to filter the input, then the output in this example will be:

{
    "mobile": "111-222-3333"
}