Airtable Upsert Error: Missing Merge Columns in Record

Stephen Johnston · 2025-01-06 04:30:44.798819+00

Hi there - getting this error trying to run an upsert back to Airtable…. ```{"error":{"type":"INVALID_VALUE_FOR_COLUMN","message":"Record must include columns to merge on"}}``` have got it using the URL field to merge on.

Airtable Upsert Error: Missing Merge Columns in Record | Clay

Channeled
APP
·
·
When performing an upsert operation with Airtable, you need to explicitly specify the Match Criteria fields that will be used to determine whether to insert or update a record. While you're using the URL field, you need to make sure it's properly set as a match criteria field in the upsert configuration.To resolve this error: 1. Make sure you've specified the URL field in the "Match Criteria" section of the upsert configuration 2. Ensure you've also included the fields you want to include/update in the "Fields to Include/Update" section Source: Airtable integration overview | Documentation | Clay University
Stephen Johnston
·
·
Ok thanks. I’ve switched to using update record, and now it’s saying- value is not an array of record IDs. Any suggestions what that means?
Channeled
APP
·
·
This error typically occurs when the Update Records action isn't receiving the correct format for the Record ID field. When updating records in Airtable, you need to provide a valid Record ID for the specific record you want to update. Make sure you have: 1. Included the required Record ID field in your update configuration 2. Provided a valid Record ID value for the specific record you want to modify 3. Specified the fields you want to update in the "Fields to Update" section Source: Airtable integration overview | Documentation | Clay University
Stephen Johnston
·
·
Am taking the ID that comes from Zapier, and putting it in a Clay ID table. is this not correct? How do i know what the valid Record ID is?
Channeled
APP
·
·
When updating records in Airtable, you need to use Airtable's own unique Record ID, not an ID from Zapier. To find the correct Record ID, I recommend using the "Lookup records" action first to find the specific record in Airtable that you want to update. This will return the valid Airtable Record ID that you can then use in the "Update records" action. Source: Airtable integration overview | Documentation | Clay University
Stephen Johnston
·
·
Yes this is the Airtable ID, not a Zapier ID - Zapier just happens to be forwarding it along.
Channeled
APP
·
·
I'm glad we could clarify that for you. I'm here if you have any more questions about Clay.
Channeled
APP
·
·
Hi Stephen Johnston! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Stephen Johnston
·
·
Do you have to do any other formatting to it?
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Stephen Johnston
·
·
Like, add quotes or something?
Stephen Johnston
·
·
This record ID looks like this: reccV82T2MXWlcmIs
Channeled
APP
·
·
No, you don't need to add any special formatting to the Airtable Record ID. You can use it as is ('reccV82T2MXWlcmIs') in the Update Records action. Just make sure you're using the correct Base ID along with it. Sources: Airtable integration overview | Documentation | Clay University Update Record with Airtable
Stephen Johnston
·
·
it all seems to be correct - Base ID and Table ID…

34 comments