Deleting bulk documents in Sanity Studio using CLI or Vision

Hello Everyone
How to to delete bulk documents from sanity studio using CLI or vision ?

Hi there. You can’t delete using Vision (it’s read-only), but you can through the CLI with this:

Make sure to (1) update the filter to get the correct documents and (2) run the query first (e.g.,
) to ensure you’re working with the correct documents. This deletes data so it may be best to test on a non-production dataset first.

I am using windows , following the documents I have to install GNU Win?

Ah. I’m not too sure on how you’d implement

xargs

in Windows. As an alternative, you can query for all the document ids you want to delete, format them into whitespace-separated

"strings" "like" "this"

, and then pass that into

sanity documents delete

.

this delete query is working fineis there any way to pass array of strings ?

like sanity documents deleteand then instead of passing strings as i want to delete bulk , so is there any way to pass array directly containing the ids?

I don’t believe it takes an array of strings, but it will take multiple whitespace-separated strings at the same time. That’s the function of the

groq-cli

command in the original command snippet. Perhaps you can get that working on Windows, or you can format the list of documents yourself.

Okay

Thanks Alot for your help

Really Appreciated 🙂

You’re welcome!

I will try to make that work 😕

Can you pipe the output of a command to a file in your Windows terminal? For example, does send an array of IDs to

docs.txt

?

yes

I can send

You can open that file and format it by:
1. removing the first line with

[

,2. removing the last line with

]

, and3. deleting the commas at the end of each line.
Then copy what’s left and paste it on your command line after

sanity documents delete

.

ok

I am doing

I don’t want to complicate things, but if you have vim on your machine you could run this in your terminal on your file that’s output:

It looks complicated but all it’s doing is running a few commands upon opening docs.txt. If you don’t have vim installed then it won’t work, though you could use other terminal commands to do the same thing. In this case, a quick edit in VS Code or similar should work fine.

I have successfully deleted the bulk content

I have no words to Thank you

god bless you

Actually I am new to sanity just build couple of projects

Great! Glad you’re here and hope you’ve enjoyed it so far. 😀

yes I really enjoyed

Thanks once again

hoping to learn more in future through your guidance

stay blessed!