Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

copy a file from SharePoint to local folder in Events (run command - before run)

Alteryx_user_aK
8 - Asteroid

Hi,

 

I have a requirement to read a file (excel) from sharepoint and copy it to local folder. Same file will be used in input tool. 

 

currently I am running the workflow from my PC but eventually it will be pushed to Alteryx server. 

 

is there a way to do it  ?

 

thanks in advance 

AK

 

 

 

 

2 REPLIES 2
FrederikE
13 - Pulsar

Hey @Alteryx_user_aK,

 

There is a SharePoint Input (and Output) Tool: https://help.alteryx.com/20221/designer/sharepoint-input-tool

This will allow you to access SharePoint Sites via Gallery. 

But your Gallery will need some configurations to be done to access the Microsoft API (https://help.alteryx.com/20221/designer/microsoft-sharepoint#SharePointCustomApp

 

 

When run on Desktop you can ofc. just write this file locally. On Gallery I am not sure what your goal is, you may output it to an other SharePoint location, but ofc. no local folder on your PC. 

Alteryx_user_aK
8 - Asteroid

Thanks FrederikE for your reply. I tried the SharePoint tool and "sign in via internet browser" option to connect, but nothing happens. when I run the WF, I get Missing Incoming Connection error. Since this option did not work, I thought I can make a local copy before I execute the WF hence posted my question.

 

Appreciated your feedback.

 

AK.

Labels