I’m using an Airtable node to create records in Airtable. All the fields are created correctly, apart from the fields where I’m trying to upload an Attachment. When I try to add the attachment it fails.
The attachment field is set correctly in Airtable, including the name.
I believe my json is correct and that there might be a bug in n8n / Airtable.
The error I get is:
ERROR: Invalid input for ‘Logo’ [item 0]
‘Logo’ expects a object but we got ‘[object Object]’.
Here’s the JSON data relating to just the part that is failing:
Could you share your workflow, as well? If you hit cmd/ctrl + a and then cmd/ctrl + c, you can then paste over your workflow here. Placing it between two sets of three backticks (```) would be perfect!
Also have you tried to use the Airtable node for this before and were successful, or are you new to n8n?
Yeah I did run it successfully, last Thursday it was working. The next day it failed. The only thing that changed was I reloaded my airtable inside the node (I was adding a new column and needed it to appear in the dropdown).
Nothing else changed.
Here’s the flow. All works up until the Airtable node.
I tried using a HTTP request node too. That worked for uploading the attachment but fails on something else! (/n new line character in one of the text fields causes a 422 issue). The /n in the text field posts to airtable via the airtable node though. So frustrating.
That definitely doesn’t sound right if that was all that was changed I’ll flag this with our developers to take a closer look, and will be back with updates once I have them! In the meantime, that workaround above should be a temporary fix for you
Interesting, Thanks for the info. I was looking into it and I can’t see any way for it to have worked in the current version so I suspect there could be a bit more to this but we will get this fixed.
Also facing this issue, and I’ve tried many combinations of format and file. Trying to add an attachment to Airtable using the public URL of an image or video.
Using a test url with all other parameters trimmed out: This works for me on other platforms so was surprised it was erroring out.
The only thing I can think of would be to use the HTTP Request node to manuallly send the data which should work if you follow the API docs from Airtable.
I don’t know if this aids the debugging process. But if you copy and paste the Airtable node into a text editor. The issue seems to be because n8n appends two \ characters to the expression mapping for some reason.
This is genuinely the most frustrating issue as it’s preventing my entire build from working properly. I intentionally moved over from Make (Integromat) for greater functionality, but is so annoying that uploading files to a record just isn’t possible.