Delete records from table via api


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



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)



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: