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

0 Likes

#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)

0 Likes

#3

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

0 Likes