Cascading List

Ccascading list synchronizes simple string lists with sub lists.

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

CODE

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

Select Parent List

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

Example:

CODE

$.parentList[*]

Parent Label

Next, define a path to the parent label in your selected list.

Example:

CODE

$.name

Select Children

Define a path to the children list, referring to your selected list:

Example:

CODE

$.children[*]

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 type allows up to 1.000 parent values.