Cascading Dictionary

Cascading dictionary maps values to unique identifiers while keeping lists and sublists synchronized.

In the following, we will use a data source with this JSON result as Example:

CODE

{
   "parentList": [
    {      
        "id": 1,
        "name": "Mario Speedwagon",
        "children": [
            { "id": 1, "name": "Andrew" },
            { "id": 2, "name": "Mathew" }
        ]
    },
    {      
        "id": 2,
        "name": "Anna Sthesia",
        "children": [
            { "id": 1, "name": "Margret" },
            { "id": 2, "name": "Anthony" }
        ]
    }
  ]
}

Select Parent List

First select the parent list. The result must contain the complete data set that you want to sync.

CODE

$.parentList[*]

Parent ID

ID stands for Identifier and must be a unique number or string that identifies an item within the data set. Define a path to the field that represents the unique Identifier in your selected list.

Example:

CODE

$.id

Parent Label

Define the JSON path to the field in your selected list that you want to use as Label.

Example:

CODE

$.name

Select Children

Define a path to the children list within your selected list.

Example:

CODE

$.children[*]

Child ID

ID stands for Identifier and must be a unique number or string that identifies an item within the data set.

Relative to the selected children list define a path to the value representing the unique identifier.

Example:

CODE

$.id

Child Label

Define a JSON path pointing to the value within the selected children list, that you want to use as child label.

Example:

CODE

$.name

Limitations

Cascading List allows up to 1.000 parent values and up to 1.000 children values. There is also a total value limit of 10.000 items for parents & children combined.