Delete records from table via api

[Steve_Miley]

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

[Andrew_Johnson1]

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]

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

[Tim_Daubenschut]

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.