Skip to main content

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

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.

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.

can you tell me the name of that script or give its url or can get its document


can you tell me the name of that script or give its url or can get its document


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.


There are 2 easy, no-code ways to delete all the records in a table — that don’t require writing any JavaScript code at all:

  1. MANUALLY:
    Right-click on the table name and choose “clear data”.
     
  2. AUTOMATICALLY:
    This can be done extremely easily by using Make’s advanced automations for Airtable.

    Below is a screenshot of how you would setup Make to delete all the records in a table.

    Just tell Make to search for all of your records by using the formula: 1

    Then, Make will delete all of your records.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

3308i4DC1FCC34949641B.png


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.


Thank you! more than 2 years later I found your answer very helpful!


@ScottWorld Thanks for sharing the trick!
For folks using n8n, you can apply the same approach.
Just connect the Airtable "Search Records" action with the Airtable "Delete a Record" action, and then map the ID of the search results with the "Record ID" field of the delete action. You want to have something like {{ $json.id }} in the Record ID field.
The "Search Records" step selects all the rows you want to delete, and the "Delete a Record" step loops through and removes them one by one.


If any future reader is wondering whether to use Make, or N8N, I share my thoughts on the different automation tools on this blog post. Hope it helps!

Even if this Community post is pretty old now, posted answers are still valid as there is no update from Airtable on deletions via automations.

Mike, Consultant @ Automatic Nation