Delete records from table via api


#1

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


#2

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)