New beta: REST API Upserts
Hi everyone! We’re excited to announce one of our newest features - REST API Upserts.
You can now add an upsert option performUpsert to the Update records API endpoint, so that if a matching record is not found, it will create the record instead.
More details about this new feature can be found in the API documentation, under the Update records section.
If you have any feedback about this feature, please submit via this form.
Example request:
curl -X PATCH https://api.airtable.com/v0/[base ID]/[table name or ID] \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
--data '{
"performUpsert": {
"fieldsToMergeOn": [
"Name"
]
},
"records": [
{
"fields": {
"Name": "Kick off design work",
"Status": "In progress"
}
},
{
"fields": {
"Name": "New homepage",
"Status": "To do"
}
}
]
}'
Example response:
{
"records": [
{
"id": [record ID 1]
