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: https://airtable.com/shr2Hk8bNAA6wp1zM
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
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
