Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 14, 2018
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.
Mar 20, 2018
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)
Mar 21, 2019
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
Oct 25, 2021
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: