Uploading From Alteryx Server to Sharepoint KML or ZIP file.

Question

Greetings, my apology if this is repeated question, but I couldn't find any reference to help me.

I have a workflow on Alteryx Server, it can download from SharePoint (Input tool), read, extract and process the data and create KML and in other cases Zip files. but I am unable to find a solution that would allow me to upload these files that are other than CSV, XLSX, YXDB (which is the only supported file formats on SharePoint Output tool). While SharePoint Input Tool allows downloading any type of file. does anyone knows any work around to be able to upload these files using Alteryx Server workflows?

AshRez · Answer

It appears there was no other suggestions,, so I did solve the problem by creating my own way of downloading and uploading to SharePoint using Custom Python tool codes. The only challenge I had was how to secure the Client ID and Secret, (Since DCM can't be used in this case) and I found that by locking the macro, or the workflow, you will encrypt the file and ensure no one can read it (although this is not a bullet proof), just ensure to save a backup of the file without credentials, because you can't edit it once locked.

If anyone interested I can share the macro, which can download multiple files from SharePoint at once (much better than the limited SharePoint Input) and another Macro that can upload multiple files to SharePoint at once too. Also there is a macro that can pull the list of files found in the SharePoint with all the metatag data.

AshRez · Answer

Any suggestions?