Changing parameters in Google Drive Tools with Interface connection

[CMason_tpa_bay]

Has anyone had success on changing the Google Drive Parameters (changing Drive folders) with interface tools?  I'm interested in trying via workflow data or directly entering through text box.  The folder I've tried to replace is the /01/.  I've tried replacing the entire string and just the folder name. I've tried in the Path Attribute and the Folder Path Attribute

[apathetichell]

@CMason_tpa_bay for fields which have related structures (path/folderpath and folderid/folderidsarr) you could make an inner/outer batch macro set up where your app - takes in the variables and then the outer macro parses the 3 entries to create the 5 needed in the action tools. but yup - this is a pain. I'd recommend something python in the long run. and in production - I'd recommend using a .jwt to auth versus the oauth/browser auth Alteryx supports.

[CMason_tpa_bay · Accepted solution]

@apathetichell @Carolyn  This is somewhat embarrassing.  Apparently if you use the google drive app (https://www.google.com/drive/download/) you can map your google drive folders to your PC to be seen on File Explorer (example G:/ drive).  You can then use the standard addresses with your workflows like any share (G:\Shared drives\Alteryx\Test\TestOutput.xlsx|||Sheet1), and make address change with interface tools as standard. It looks like the Drive tool up/downloads to your cloud pretty quickly.  I would guess there's some standard issues with collaboration sharing so it would be important to use the web GUI when opening files that have that potential sharing.  

I haven't run into any issues yet on my PC, but haven't been able to test it on an Alteryx Server yet. An IT guy at my company turned me on to this download. Good Stuff!

[apathetichell]

@CMason_tpa_bay - 100% - that's what we use. It just won't work on Server or with Gsheets.

[Carolyn]

@CMason_tpa_bay - Fun fact - the spot where you enter the G:\ address in the GDrive Input Tool didn't work until 2 GDrive Tools versions ago. I submitted a bug to get that fixed and working :) Also, you can use wildcards in it and they work now - also my doing. 

I'm glad you asked the question to begin with since I'm excited to try out @apathetichell 's solution for our workflows on Server (since I never would have figured this out on my own)

[CMason_tpa_bay]

I noticed the GSheet issue. hmm wonder why on server?

[apathetichell]

@CMason_tpa_bay to map a gdrive locally on server (ie use the G drive trick) the server would need a specific google workspace identity and be signed in. Usually this doesn't exist. For server setups you'd use an oauth connection secured by JWT/service acocunt key - which would require using the Ggdrive tool.

No idea why Alteryx split up the Gsheets tool but It's not a decision I would have made...