
- Select a sheet
- Select a worksheet
- Select headers
In case of dependent dataslots, the list of options will only load when the value inside the parent dataslot is set. Let’s look at the example of
Google Sheets, where value is not set for any of the three dataslots:
Copy
/* The options appear only in the first
config id because its value is not yet set and
other config dataslots are dependent on this.
*/
{
"application_data_slots": [
{
"required": false,
"id": "646333dbc7f3ab6e2bf4ed12",
"name": "Select a Sheet",
"has_dynamic_map_fields": false,
"field_type": "select",
"options": [
{
"name": "List of users",
"value": "11Sei6p5yHQmjyfHXeSXxpnIJRSSyM774X82-mOTJNe4"
},
{
"name": "List of Employees",
"value": "1eQWXziv-RbBye9OuyoQbGzZ3wHMcNedZ3x759O2EeZo"
},
{
"name": "List of Contacts",
"value": "1QVYAqowEnOgwxDzJ_AeODbmkdVAcL2ZW6LlRTZoMxVo"
}
],
"dynamic_slot_identifier": "dynamic:google_sheets:1",
"labels": []
},
{
"required": false,
"id": "646333e5c7f3ab6e2bf4ed22",
"name": "Select a Worksheet",
"has_dynamic_map_fields": false,
"field_type": "select",
"parent": "646333dbc7f3ab6e2bf4ed12",
"dynamic_slot_identifier": "dynamic:google_sheets:2",
"labels": []
},
{
"required": false,
"id": "646333f4c7f3ab6e2bf4ed4e",
"name": "Select Headers",
"has_dynamic_map_fields": false,
"field_type": "map",
"parent": "646333e5c7f3ab6e2bf4ed22",
"dynamic_slot_identifier": "dynamic:google_sheets:3",
"labels": [
{
"name": "Header 1",
"value": "6463340bc7f3ab6e2bf4edca"
},
{
"name": "Header 2",
"value": "6463340bc7f3ab6e2bf4edcb"
},
{
"name": "Header 3",
"value": "6463340bc7f3ab6e2bf4edcc"
}
]
}
],
"workflows": [],
"config_id": "1234"
}
Copy
{
"application_data_slots": [
{
"required": false,
"id": "646333dbc7f3ab6e2bf4ed12",
"name": "Select a Sheet",
"has_dynamic_map_fields": false,
"field_type": "select",
"options": [
{
"name": "List of users",
"value": "11Sei6p5yHQmjyfHXeSXxpnIJRSSyM774X82-mOTJNe4"
},
{
"name": "List of Employees",
"value": "1eQWXziv-RbBye9OuyoQbGzZ3wHMcNedZ3x759O2EeZo"
},
{
"name": "List of Contacts",
"value": "1QVYAqowEnOgwxDzJ_AeODbmkdVAcL2ZW6LlRTZoMxVo"
}
],
"dynamic_slot_identifier": "dynamic:google_sheets:1",
"labels": [],
"value": "1QVYAqowEnOgwxDzJ_AeODbmkdVAcL2ZW6LlRTZoMxVo"
// Value is set to "List of Contacts"
},
{
"required": false,
"id": "646333e5c7f3ab6e2bf4ed22",
"name": "Select a Worksheet",
"has_dynamic_map_fields": false,
"field_type": "select",
"options": [
{
"name": "US",
"value": 0
},
{
"name": "UK",
"value": 235386608
},
{
"name": "Europe",
"value": 644453895
}
],
"parent": "646333dbc7f3ab6e2bf4ed12",
"dynamic_slot_identifier": "dynamic:google_sheets:2",
"labels": [],
"value": 0
// Value is set to "US" worksheet
},
{
"required": false,
"id": "646333f4c7f3ab6e2bf4ed4e",
"name": "Select Headers",
"has_dynamic_map_fields": false,
"field_type": "map",
"options": [
{
"name": "Name",
"value": "A"
},
{
"name": "Email",
"value": "B"
},
{
"name": "Phone",
"value": "C"
}
],
"parent": "646333e5c7f3ab6e2bf4ed22",
"dynamic_slot_identifier": "dynamic:google_sheets:3",
"labels": [
{
"name": "Header 1",
"value": "6463340bc7f3ab6e2bf4edca"
},
{
"name": "Header 2",
"value": "6463340bc7f3ab6e2bf4edcb"
},
{
"name": "Header 3",
"value": "6463340bc7f3ab6e2bf4edcc"
}
]
}
],
"workflows": [],
"config_id": "1234"
}