Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Update record without record id

Topic Labels: API
740 1
Showing results for 
Search instead for 
Did you mean: 

Is it possible to update a record without providing a record id.
For example, in my table, I have another unqiue key (e.g. unique_id), Can I use it instead like the following?
{ “unique_id”: “1234567”,
“fields”: { … }

1 Reply 1

Hello @Terence_Leung,

You can almost always do this, in any system but it often requires two calls :slightly_smiling_face:

1) Search for records based on your own filter criteria (“unique_id” == “1234567”)

If it is really a “unique” field, then it should only return one result. Just get the first item of the returned array and get it’s record ID.

2) Update your base record using record ID found in step (1)

I don’t think it’s possible to do it in one step using the API, as mentioned in their documentation :

[…] objects should have an id property representing the record ID […]