Airtable integration - Upsert a record - 404 not found but the record exist in the table

[L_ECRIN_BRETON]

Hi.

I’m trying to upsert a record with airtable.
I use the search module juste before the upsert module, searching for the “Primary Key” in the field Formula etc…

The search module found the data and I use this in the RecordID of the upsert module. When I run this, I have this error message “404 NOT FOUND”.

I have controled the type of data in make and they are ok with columns’s type of my airtable table.

Could you explain me why I have this error message please?
Thank you for your help,
Regards,
Kevin

[Simo]

Hi, are you mapping the actual RECORD ID? Or using the primary key/other field in the “RecordID” of the upsert module?

[dilipborad]

Hello @L_ECRIN_BRETON,
Welcome to the community.

Check my answer on the same type of topic. Also, read the topic then you get more context.

404 error with Airtable

Hello @Jonathan_Richey, As per your current setup the field Record ID is just another auto-generated field to generate numbers based on row automatically. As @Simo suggested you need to use the record ID from the Airtable formula function RECORD_ID(). Just add a new field as Formula and add this formula on it. It shows you all the record IDs of all the different rows. Another approach is just to expand the row in the details view and you can see in the URL some IDs start with rec******. Rea…

I hope this helps.

---

P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions and give
If you need expert help or have questions? Contact or comment below!

[L_ECRIN_BRETON]

Hi,

Thanks a lot for your response.

I had used my Primary key instead of the ID from the search module.
It works now!

Regards,
Kevin

[L_ECRIN_BRETON]

Hi,

Your explanation was really clear! Thanks a lot!

Regards,
Kevin

[dilipborad]

Hello @L_ECRIN_BRETON,
Please remember to mark the most helpful replies to your questions as solutions. It helps keep the community organized.