Show fileinfo outpout to Google Sheet

[Temple Rodgers]

I'm having my usual fun time, using input from a Sheet and trying to get the output of a GAM command into a tab on the same Sheet. I've used a modified version of a different GAM command that outputs to a sheet but that doesn't work. Here's what I've got:

gam redirect csv - multiprocess todrive tdfileid <FileID> tdupdatesheet tdsheet "TEST -
DON'T USE" tdtitle "documents_ids" redirect stderr stdout csv gsheet <user> <FileID>
 "documents_ids" gam user <userid> show fileinfo id ~doc_id fields lastModifyingUser

but this generates a blank tab in the sheet. It doesn't matter if I use taddsheet or tdupdatesheet, it's still blank.

Can it be done?

Temple

[Ross Scroggs]

Temple,

show fileinfo produces text, not csv output, so redirect csv doesn't have any effect

Do this:

gam redirect csv - multiprocess todrive tdfileid <FileID> tdupdatesheet tdsheet "TEST - 

DON'T USE" tdtitle "documents_ids" csv gsheet <user> <FileID>
 "documents_ids" gam user <userid> print filelist select ~doc_id fields lastModifyingUser norecursion

Ross

----

Ross Scroggs

Ross.S...@gmail.com

Disclaimers apply, for full details see: https://hackney.gov.uk/email-disclaimer

--
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/82908760-34b2-459b-9c81-77248d883364n%40googlegroups.com.

[Temple Rodgers]

BOOM!

What joy, thank you Ross. Worked first time.

I needed to climb out of the show fileinfo box and into the print filelist ... got it!

Thank you very much

Temple