Notifications
Clear all
Topic starter
Hi. I recently encountered a scenario where I needed to delete thousands of records in Airtable.
The most efficient method is to call the DELETE endpoint for batches of up to 10 records and loop through them.
However, as far as I know, the current Airtable node doesn't support passing multiple record IDs simultaneously.
This is the required API call for this operation:
curl -v -X DELETE https://api.airtable.com/v0/<base_id>/<table_name>
-H "Authorization: Bearer YOUR_API_KEY"
-G
--data-urlencode 'records[]=recQSpD8h91I1d850'
--data-urlencode 'records[]=receGaAnw7n1Ksu4T'I also attempted to accomplish this using the HTTP node.
But, unexpectedly, there was a limitation there too. The HTTP node does not permit Body parameters for DELETE operations. And I was unable to make an API call with the data in the Query parameters.
I will submit another feature request for this.
I ultimately implemented this using Axios within a Function node.
Kindly consider adding this functionality.
Thanks.
Posted : 18/04/2021 2:41 am
Yes, that's correct. The Node is designed to handle batching for you. You should send batches of 10 records.
By the way, where did you find information stating that the maximum is 10 records? I couldn't locate that detail in the documentation.
Posted : 19/04/2021 12:12 am
Topic starter
I discovered this information within the Airtable community forum. However, I might be mistaken.
Update: I attempted an API call for over 10 records and received an Error 422 (Invalid Request). It appears that 10 is indeed the limit.
Posted : 19/04/2021 1:25 am
