Hi I am using n8n v1.72.1 and using the AirTable Search Records function in n8n. I am pulling patient data from AirTable so querying 20+ fields from airtable. I have n8n querying a specific view in AirTable where I have removed all the unwanted fields still there are a lot of fields that I do want.
I find that even if I specify the fields I want, I get an error beyond 21 fields, and if I don’t specify the output fields, I still don’t get all the fields I need. I am wondering why this might be or if there’s a better way around this. I am trying to avoid processing anything in AirTable because I find their automation platform to be horrible. I would much rather do it in n8n. I am open to having my mind changed.
What is the error message (if any)?
Error Code: 422
{ "error": { "type": "INVALID_REQUEST_UNKNOWN", "message": "Invalid request: parameter validation failed. Check your request data." } }
Node type
n8n-nodes-base.airtable
Node version
2.1 (Latest)
n8n version
1.72.1 (Cloud)
Time
2025-01-21, 9:49:41 p.m.
Stack trace
NodeApiError: Your request is invalid or could not be processed by the service at ExecuteContext.requestWithAuthentication (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1297:19) at processTicksAndRejections (node:internal/process/task_queues:95:5) at ExecuteContext.requestWithAuthentication (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/NodeExecuteFunctions.js:1567:20) at ExecuteContext.apiRequest (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/transport/index.js:27:12) at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/actions/record/search.operation.js:175:32) at ExecuteContext.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/actions/router.js:58:30) at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Airtable/v2/AirtableV2.node.js:21:16) at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:741:19) at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:724:51 at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1155:20
Please share your workflow
Information on your n8n setup
- n8n version: v1.72.1
- n8n EXECUTIONS_PROCESS : Test Step
- *Running n8n via: n8n Cloud
- **Operating system: Apple M1 Pro, 16 GB Ram