Notifications
Clear all
Topic starter
Describe the problem/error/question
Cannot input data into an Airtable Update node.
What is the error message (if any)?
ERROR: Your request is invalid or could not be processed by the service
You must provide an array of up to 10 record objects, each with an "id" ID field and a "fields" object for cell values.
Details
Time
08/08/2023, 17:12:26
HTTP Code
422
Stack
NodeApiError: Your request is invalid or could not be processed by the service
at Object.requestWithAuthentication (/usr/local/lib/node_modules/callin.io/node_modules/callin.io-core/dist/NodeExecuteFunctions.js:1086:19)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
at Object.execute (/usr/local/lib/node_modules/callin.io/node_modules/callin.io-nodes-base/dist/nodes/Airtable/Airtable.node.js:694:40)
at Workflow.runNode (/usr/local/lib/node_modules/callin.io/node_modules/callin.io-core/dist/Workflow.js:646:28)
at /usr/local/lib/node_modules/callin.io/node_modules/callin.io-core/dist/WorkflowExecute.js:631:53
Please share your workflow
Relevant Screenshots
None of the methods below work. They all return the same error.
Share the output returned by the last node
No output returned due to error
Information on your callin.io setup
- callin.io version: Latest
- Running callin.io via (callin.io cloud):
- Operating system:Mac M1
Please provide the rewritten markdown content *it should be in the markdown format.
Posted : 08/08/2023 4:13 pm
Hi
It sounds like you might not be correctly passing the IDs. This documentation has some information on how to retrieve the correct data. Airtable | callin.io Docs
If that doesn't resolve your issue, could you please share the JSON data (or sample data in the same format) you are sending to the Airtable node, along with your current Airtable table structure (including the fields and their data types)?
Posted : 09/08/2023 10:33 am
Topic starter
Hi there!
Thanks! I'll review the documentation now.
The screenshots above contain three examples of the JSON I'm using as input.
Are these examples appropriate?
Posted : 09/08/2023 10:35 am
Let me know how you get on! Admittedly I was just wanting to copy and paste
But the sample data is rather small, if that’s what you’re working with. Could you give me the Airtable table/field structure as well, if you can’t get what you need from the docs? It looks like you’ve two dates, an integer, and a status as a string, but I’d want to be sure.
Posted : 09/08/2023 10:46 am
Topic starter
Certainly! I'm confident the Airtable ID is correct because I'm using it to call a mock example with the Airtable Read command, and it appears to be working.
I'll send you my Workflow via email, as I cannot share it on a public forum due to privacy concerns. However, I assure you it's just as straightforward as the screenshots indicate.
Posted : 09/08/2023 1:09 pm
Hello,
Have you considered adding a new Airtable node to your workflow to simplify the process? Based on your screenshot, it appears you're using the older v1 node. If you're on the latest callin.io version 1.x, it should look like this:
The workflow below demonstrates how to utilize the Airtable node with data being passed from a code node.
You will need to copy and paste the workflow into your callin.io instance, as our preview instance has not yet been updated.
Posted : 09/08/2023 3:49 pm
Topic starter
Thanks for the suggestion. I just confirmed and I'm definitely using version 1.0.5. So I don't know why my Airtable node doesn't look like yours. Strange.
Posted : 09/08/2023 4:38 pm
Hey,
1.0.5 isn’t the latest release and the change went into 1.1.0. I will rework the example in the morning to use the older Airtable version.
Posted : 09/08/2023 4:56 pm
Topic starter
No worries. It seems to be functioning correctly now with the identical input from the initial screenshot.
I'm not sure what the issue was, but everything is resolved now.
Posted : 10/08/2023 8:58 am
This discussion was automatically closed 7 days following the last response. New replies are no longer permitted.
Posted : 17/08/2023 8:58 am