not '<Folder ID>' in parents | Google Sites

[James SEYMOUR]

Hi Ross,

When I was testing this command, using the words in the file name of a Google Site, the results showed the Google Sites in the folder I was excluding. When I changed to a file that was Google Doc, the command ran as expected.

gam user <User Email Address> print filelist query "name contains '<Part of File Name>' not '<Folder ID>' in parents" filepath fields id,name,webviewlink corpora alldrives todrive

I'm currently running GAMADV-XTD3 6.50.09.

Cheers

James

[Ross Scroggs]

James,

I can duplicate your results; it appears that Google is ignoring the not '<Folder ID>' in parents for sites; remember, sites are pseudo files. I modified the query by adding "and" in front of "not".

Try this:

gam config csv_ouput_row_drop_filter "parents.0.id:regex:<Folder ID>" user <User Email Address> print filelist query "name contains '<Part of File Name>' and not '<Folder ID>' in parents" filepath fields id,name,webviewlink,parents corpora alldrives todrive

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e0d84491-8d0c-4c1c-b8ac-9632f6b9564fn%40googlegroups.com.

[James SEYMOUR]

Many thanks, Ross. It worked perfectly, although there was a typo, the command should start with gam config csv_output_row_drop_filter ...

Cheers

James