I use the following airtable node, and I have tried different tables, and different checkbox names, but I get the data returned in an element if the checkbox is ture, otherwise I don’t get a node returned.
so I have 5 rows in the table:
Here is the data that is returned, note the proceesed checkbox field is only present when the value is true.
[
{
“id”: “rec5Csc8lghpYyHQz”,
“createdTime”: “2024-09-16T19:38:02.000Z”,
“team_slug”: “werfen”,
“dataset_slug”: “sv0025_label_oervised”,
“exported_slug”: “2024-07-26T16-19-20-sv0025_label_overall_idexxaptt_unsupervised”,
“json_filename”: “2-two.json”,
“gdrive-folder_id”: “1GOO6WRYmI8HiSlBmjscxz_uC6n9hJylf”
},
{
“id”: “recD52uvygTGkEoCf”,
“createdTime”: “2024-09-16T19:38:00.000Z”,
“team_slug”: “werfen”,
“dataset_slug”: “sv0025_label_”,
“exported_slug”: “2024-07-26”,
“json_filename”: “4-four.json”,
“gdrive-folder_id”: “1Kv3VC93PLD3k4FnzpidR53zDNT”,
“processed”: true
},
{
“id”: “recSiWMm5ECEqy7kK”,
“createdTime”: “2024-09-16T19:38:01.000Z”,
“team_slug”: “werfen”,
“dataset_slug”: “sv0025_label_ovevised”,
“exported_slug”: “2024-07-26”,
“json_filename”: “3-three.json”,
“gdrive-folder_id”: “18zcwuZVmQmSTg2VNG00fL995l”
},
{
“id”: “recmZc0uRkA54tLh2”,
“createdTime”: “2024-09-16T19:38:00.000Z”,
“team_slug”: “werfen”,
“dataset_slug”: “sv0025_label_ovvised”,
“exported_slug”: “2024-07-26”,
“json_filename”: “5-five.json”,
“gdrive-folder_id”: “1fC_2rqQAuQcuaAjInOclBBw8”,
“processed”: true
},
{
“id”: “recqANtui91a4821l”,
“createdTime”: “2024-09-16T19:38:02.000Z”,
“team_slug”: “werfen”,
“dataset_slug”: “sv0025_labelised”,
“exported_slug”: “2024-07-26T”,
“json_filename”: “1-one.json”,
“gdrive-folder_id”: “1saElb-Oi14nfMeYofeYdDAGI”
}
]
Here is the airtable code setup:
{
“meta”: {
“instanceId”: “5743c479fc2e08a8c8ff3b602b4782a8694f2d3f985a2ed1818287a8966f6743”
},
“nodes”: [
{
“parameters”: {
“authentication”: “airtableOAuth2Api”,
“operation”: “search”,
“base”: {
“__rl”: true,
“value”: “appMu1kqxX9qIkVmK”,
“mode”: “list”,
“cachedResultName”: “n8n-v7darwin-training”,
“cachedResultUrl”: “https://airtable.com/appMu1kqxX9qIkVmK”
},
“table”: {
“__rl”: true,
“value”: “tblny0l1qYsAAjAWW”,
“mode”: “list”,
“cachedResultName”: “v7darwin_json_files”,
“cachedResultUrl”: “https://airtable.com/appMu1kqxX9qIkVmK/tblny0l1qYsAAjAWW”
},
“filterByFormula”: “=”,
“options”: {
“fields”: [
“team_slug”,
“dataset_slug”,
“exported_slug”,
“json_filename”,
“gdrive-folder_id”,
“processed”
]
}
},
“id”: “36885584-1cb9-4212-8df8-e9c24d4cc0fc”,
“name”: “airtable-READ-v7darwin_exported_datasets”,
“type”: “n8n-nodes-base.airtable”,
“typeVersion”: 2.1,
“position”: [
820,
180
],
“credentials”: {
“airtableOAuth2Api”: {
“id”: “efNO0i2yqj2ikpQA”,
“name”: “Airtable account”
}
}
}
],
“connections”: {},
“pinData”: {}
}