Deleting all records from table with API

Developers
#1

We regularly need to completely delete our 50 record table - I want to use Curl and the API but I don’t understand how to delete all 50 records?

We use
https://eu3.ragic.com/xxxxx/ragicaccounting/2 -H “Authorization:Basic API_KEY” --insecure > DELLIGNE.TXT

Is there a way to delete all the table ?
Regards.
Remy

#2

I respond myself because I forgot the _ragicId of the record in my delete instruction.
curl -X DELETE --data-urlencode api https://eu3.ragic.com/xxxxx/ragicaccounting/10008/1989 -H “Authorization:Basic MY_API_KEY” --insecure > TXT_101.TXT

Now it is working:
Is there a way to delete more than one record in one instruction ?
Regards.
Remy

#3

An other question :slight_smile:
When we delete a record the response is the same when the record is already in the recycle bin - is it normal ?
Regards.
Remy

#4

Hello Remy,

Thanks for reaching out!

Unfortunately, there is currently no way of deleting all records on a sheet.
The workaround could be writing a shell script to execute curl requests multiple times.

Yes, it is normal behaviour to receive the same response.

Thanks,
Rick

#5

Thanks for your response.
We will make the script for deleting sequentially all the records :slight_smile:
Complementary question :slight_smile:
Is there a way to know that the record is currently deleted ?
Regards.
Remy

#6

Hi,

Whether the record is successfully deleted can be determined from the response message.

Thanks,
Rick

#7

Thanks - we will check the response record :slight_smile:

#8

Can you consider in future evolution to allow to zap a Ragic table via the API as we did in DBASE. I see that Air Table allows deleting multiple records as well. Multi-calling on large tables is quite slow in Ragic!.
Can you also add a function to count the number of the records in the table ?

Regards.
Remy

curl -X DELETE “https://api.airtable.com/v0/{baseId}/{tableIdOrName}\
?records=rec560UJdUtocSouk&records=rec3lbPRG4aVqkeOQ”
-H “Authorization: Bearer YOUR_TOKEN”