Double Quotes in output results

[Darin Clausing]

Greetings,

I have been using this gam command for a bit now, but sometime maybe in December it broke. 

Here is the  command. 

gam redirect csv ~/bin/project/startjson.csv multiprocess csv ~/bin/project/startup.csv gam print chromepolicies orgunit "~ou" filter chrome.users.StartupPages formatjson quotechar "'"

Here is the output, as you can see it is double quoting everything, which causes the script to get mad. If I clean it up and remove all the double quotes, the script runs great.

name,orgUnitPath,parentOrgUnitPath,direct,JSON
chrome.users.StartupPages,/01 Students/Adams,/01 Students/Adams,True,"{""additionalTargetKeys"": [], ""direct"": true, ""fields"": [{""name"": ""restoreOnStartupUrls"", ""value"": ""https://launchpad.classlink.com/stocktonusd,https://adams.stocktonusd.net/,https://www.sandyhookpromise.org/say-something-tips/,""}, {""name"": ""restoreOnStartup"", ""value"": ""LIST_OF_URLS""}], ""name"": ""chrome.users.StartupPages"", ""orgUnitPath"": ""/01 Students/Adams"", ""parentOrgUnitPath"": ""/01 Students/Adams""}"

[Ross Scroggs]

Move the quotechar "'" to the redirect csv

gam redirect csv ~/bin/project/startjson.csv multiprocess quotechar "'"  csv ~/bin/project/startup.csv gam print chromepolicies orgunit "~ou" filter chrome.users.StartupPages formatjson 

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 visit https://groups.google.com/d/msgid/google-apps-manager/4964e8e5-9581-4582-91a2-1695d8e8b80en%40googlegroups.com.

[Darin Clausing]

Thank you Ross,

That worked great. Much apprecitated!

Darin