batch delete

[pryme0]

Is there a way to do batch delete with supbase?
Like i pass in an array containing id's of records i want to delete and it runs the operation for me

[GaryAustin1]

With supabase.js or the API delete takes a filter. for .js you should be able to use .in('id', ['id1', 'id2', 'id3']) where 'id' is your record id.

[GaryAustin1]

I edited the above from .contains, to .in.

[pryme0]

@GaryAustin1 Your solution worked for me . i am using the Api. Thanks

[levistringer]

Searching for this for python, if anyone has found a solution!

[calebcook7]

I found another method to be able to bulk delete but it uses a few steps.

1. Create a column in your table named 'delete' and make it a true/false boolean
2. Javascript to Transform the list of ids/ UUIDs to an array function to get an array function to match for the Upsert matching rows API call.
   ("id":"UUID", "delete":"true"}
3. Call the upsert matching rows API using the newly formatted array as the array in the JSON data.
   (For example [("id":"UUID1", "delete":"true"},{"id":"UUID2", "delete":"true"}, Etc.]

4. Make a function/API call to the delete rows and use the delete column = true as your filter.

This is the only way that I've found to do it.

[steve-chavez]

@calebcook7 Hm, why not just use the delete() method?

https://supabase.com/docs/reference/javascript/delete

You can pass a range or an array of ids there.