- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2022 04:26 AM
I have a requirement to delete all records from my Airtable base. Currently the documentation says I can delete only upto 10 records from a single request.
Is it possible to delete all records at a time (Instead of sending multiple URL’s with 10 records id’s each)?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2022 07:28 AM
Welcome to the Airtable community!
It sounds like you are using the REST API. If you are using only the REST API, yes, you must do it 10 records at a time.
However, if you use scripting, it is possible to delete up to 50 records in a single call, and delete all records in a base in a single script. A script can delete thousands of records in a few seconds.
Here are some options:
- Have your code call a webhook automation that runs a scripting action that deletes the records. This requires the proper webhook setup, and webhook automations are currently in alpha. Depending on the number of records you need to delete, you may also run into other limits.
- Use the user interface to duplicate the base without copying the records. The result will be a brand new base with no records. This requires human intervention and the new base will have a new base id, so it may not work for your use case.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 10, 2022 10:23 AM
can you tell me the name of that script or give its url or can get its document
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 10, 2022 01:10 PM
Welcome to the Airtable community!
It isn’t a specific script. I was just describing what is possible. You can see the Airtable scripting documentation here.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 10, 2022 07:28 PM
Also, for those people reading this thread in the future who want a no-coding way of deleting all records at once, below is a screenshot of how you would set this up in Make.com.
Just tell Make to search for all of your records (by using the formula: 1
), and then Make will delete all of your records.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 05, 2025 12:27 PM
Thank you! more than 2 years later I found your answer very helpful!