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.

This ID is used to match existing data when syncing new data. For example, if a label changes, this ID allows us to reference the datasource field with the corresponding entry in our database, ensuring consistency and accuracy in data synchronisation.

This ID is not set on the native Jira select list and is not accessible through the custom field. The ID from the custom field is set by Jira itself and is different from this Unique ID field.

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.

This ID is used to match existing data when syncing new data. For example, if a label changes, this ID allows us to reference the datasource field with the corresponding entry in our database, ensuring consistency and accuracy in data synchronisation.

This ID is not set on the native Jira select list and is not accessible through the custom field. The ID from the custom field is set by Jira itself and is different from this Unique ID field.

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.