Hi @Ben_M , thanks for bringing this up. This is due to pagination behavior, I’ve passed your feedback to the product team for review. They’ll evaluate whether improvements are needed.
For now, records need to be deleted in batches manually. While the API supports bulk deletion, it may not be the best fit if you’re not using custom scripts.
Hi @Ben_M , writing scripts like this isn’t my strongest area either. I’ve tried using GPT to help, but it’s still a bit tricky. @Kelvin will be following up on this issue.
In the meantime, these resources might be helpful:
Based on your code, you’re trying to filter records through a view and delete them in a loop, right? That makes sense! You could try using the Delete Database Multiple Record API for batch deletion. Since this API is new, it’s not in the SDK yet. Here’s a curl example:
Just pass the record IDs as an array via query parameters. Heads-up: this API handles max 100 records per call, and URL length limits might break if the IDs are super long. Maybe split batches if needed!
I was trying to use an automation with a script in that if i provide the SPACE, DATASHEET and VIEW then delete all records in that view. This is only until I can select all records properly.