Help

Re: Delete records from table via api

827 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_Miley
4 - Data Explorer
4 - Data Explorer

I want to refresh my airtable tables from an SQL DB once a day, thus I want to delete all records in a table, then reload.

I know I can use curl, to load them, and i’ve got that to work, but i’m not sure
of the most efficient way to delete all records.

i could list them all, get the record id, then delete each record in a loop.

Has anyone else automate a table reload?

we are using this to prototype reports, and make them easily available on the web.
thanks, Steve

3 Replies 3
Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

As far as I know there is no “batch” delete functionality currently provided by the API.
The way I generally do it is loop over each record and delete them.

(I would love to hear of some other ingenious ways of doing the same)

Laurie
5 - Automation Enthusiast
5 - Automation Enthusiast

Beta now available for batch create, update, and delete API endpoints! If anyone would like to help test and provide feedback on these improvements, please fill out this form: https://airtable.com/shr2Hk8bNAA6wp1zM

Given the current API documentation, I’m not sure this user request was ever implemented. It seems not as deleting all records is only documented within the API as:

  • get all record ids from table
  • in chunks of 10 records, tediously delete all records.