# Airtable upsert node bug. Can't merge column **URL:** \ **Category:** Questions\ **Tags:** node\ **Created:** [March 21, 2024, 12:49pm UTC](https://community.n8n.io/t/airtable-upsert-node-bug-cant-merge-column/43015 "2024-03-21T12:49:14Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![JamesWebb](https://avatars.discourse-cdn.com/v4/letter/j/ecd19e/32.png) [@JamesWebb](https://community.n8n.io/u/JamesWebb)\ **Post date:** [March 21, 2024, 12:49pm UTC](https://community.n8n.io/t/airtable-upsert-node-bug-cant-merge-column/43015/1 "2024-03-21T12:49:14Z")
Hello everyone. I am building a tiktok scrapper using airtable as my backend and and http requests in N8N with API to gather the data. I am building it on the N8N hosted server directly through 8N8 web platform and I guess this is the last N8N version Now I encountered a very weird issue. I have in my workflow 2 airtable upsert node. One that come before the other and one that come after the other. And Between those 2 there is a HTPP request. The first Airtable upsert node works great and with no issues. But the second which is filled exactly the same way but with different information is not working. It always tells me something close to “We can"t merge info on this columns”. Basically asking for me to change the column Which I chose to base the decision on either update or create a record. This was the yesterday error. Now the error has changed even though I didn’t changed anything in the workflow. Now it says that it doesn’t recognise the data.Id which is the “sound ID” from my api. Defintily an issue from this node The chosen record is “Sound ID”. If the sound ID exist in my airtable DB then it shall do nothing, otherwise it should create a new record. So I select this Sound ID as the column to verify records. And it always come back as issue. If I chose another column then there is no bugs or error messages but then nothing is compared and I have dozens of duplicata created. This issue happened to the previous airtable upsert node in the same workflow. And magically solve itself without me having to do anything. I have doubled and tripled checked everything. I can’t see any mistake but I am still new to this so maybe there is something I can’t see. I would be so so grateful if an N8N boss/expert/Master/Magician could check this and see where the issue come from and if it is, as I think, a node error that nees to be fixed. Thanks in advance !!! This is the last output: ERROR: Your request is invalid or could not be processed by the service 422 - {“error”:{“type”:“UNKNOWN\_FIELD\_NAME”,“message”:“Unknown field name: "id"”}} - Unknown field name: “id” Here is the last part of the workflow ---
**Author:** ![n8n](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/n8n/32/196425_2.png) [@n8n](https://community.n8n.io/u/n8n)\ **Post date:** [March 21, 2024, 12:49pm UTC](https://community.n8n.io/t/airtable-upsert-node-bug-cant-merge-column/43015/2 "2024-03-21T12:49:16Z")
It looks like your topic is missing some important information. Could you provide the following if applicable. - **n8n version:** - **Database (default: SQLite):** - **n8n EXECUTIONS\_PROCESS setting (default: own, main):** - **Running n8n via (Docker, npm, n8n cloud, desktop app):** - **Operating system:** ---
**Author:** ![barn4k](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/barn4k/32/8170_2.png) [@barn4k](https://community.n8n.io/u/barn4k)\ **Post date:** [March 21, 2024, 2:28pm UTC](https://community.n8n.io/t/airtable-upsert-node-bug-cant-merge-column/43015/3 "2024-03-21T14:28:56Z")
hello @JamesWebb Can you provide an example of the response from the **HTTP Request1** node? Is it returns one item every time? The issue may be if it return more than 1 item at a time. Then the reference `$('Airtable1').item.json.id` won’t work ---
**Author:** ![JamesWebb](https://avatars.discourse-cdn.com/v4/letter/j/ecd19e/32.png) [@JamesWebb](https://community.n8n.io/u/JamesWebb)\ **Post date:** [March 29, 2024, 1:54pm UTC](https://community.n8n.io/t/airtable-upsert-node-bug-cant-merge-column/43015/5 "2024-03-29T13:54:26Z")
Hey, I first want to thank you so much for the help you bring in here. In fact it might be the issue. So check this screenshot of the output and tell me what you think ? Honestly I am lost. Maybe I should use some batching Thanks in advance [Capture d’écran 2024-03-29 à 17.43.16|690x450](http://community.n8n.io/uploads/short-url/53RQ891eBagoOsBLoURSjslrISe.jpeg) ---
**Author:** ![barn4k](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/barn4k/32/8170_2.png) [@barn4k](https://community.n8n.io/u/barn4k)\ **Post date:** [March 29, 2024, 8:15pm UTC](https://community.n8n.io/t/airtable-upsert-node-bug-cant-merge-column/43015/6 "2024-03-29T20:15:22Z")
Yes, that’s the issue. Try this one ---
**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\ **Post date:** [June 27, 2024, 8:16pm UTC](https://community.n8n.io/t/airtable-upsert-node-bug-cant-merge-column/43015/7 "2024-06-27T20:16:16Z")
Closed on June 27, 2024, 8:16pm UTC This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.