SharePoint Upload

[AshRez]

Greetings,

How to upload to SharePoint any type of file? I am able to use SharePoint Input Tool to download any type of file to a specific location, but I can't do the same to upload with the SharePoint Upload Tool, what are my options?

I need to be able to use this on the Alteryx Server too. so Syncing or mapping SharePoint is not an option.

[Yoshiro_Fujimori]

@AshRez ,

As far as I know, SharePoint Output Tool supports only .xlsx, .csv and .yxdb files.

So if you want to store a file in other format in SharePoint with Alteryx, one idea is to store the data in BLOB type embedded in .yxdb file.

As I do not have SharePoint connection environment now, I have not fully tested this method.

Please take this just a potential solution.

Good luck.

Workflow

Blob Input

Data for output to SharePoint

If you want to specify a file name in SharePoint, you may add a column for the name to feed to SharePoint Output Tool as [File Name].

The downside of this solution is that you cannot use the original .zip file as it is.

If you need to retrieve the .zip file, you have to read the .yxdb file with SharePoint Input Tool.

[AshRez]

Thank you @Yoshiro_Fujimori for your response. 

Unfortunately, it didn't work on SharePoint Output, I got couple of errors that says:

SharePoint Output () Error while writing 'yxdb' file.

SharePoint Output () Error: bad argument type for built-in operation

But even if this was successful, I will still have a problem converting it back using Alteryx to fully automate the process. unfortunately the SharePoint support with Alteryx is very poor, and not friendly.

[AshRez]

I've submit the idea for Alteryx for improvement

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/SharePoint-Output-Upload/idi-p/13777...