Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
I need to download PDF files from a SP site and store it locally using Alteryx. In Sharepoint, I tried to get the UNC path by going to Libraries tab and then click on 'Open in Explorer'. But this gave me a relative path "https://share.xx.net/sites/xxx_xxxxx/Lists/Shared Documents/9.xxxxx/xxxxx" . How do I use this link to download the files using alteryx? Or is there any other better way to do this ?
I am pretty new to Alteryx, so any guidance would be really appreciated.
To open files directly in Alteryx that are in a SP 2013 document library (not items in a list), use a UNC path not a url path. You also need to change it a bit if you have SSL on you SP2013 site. It would look something like this:
How do you get around the authentication requirements? We are trying to run workflows from the Alteryx server on a schedule so as such the service account is not logged into the domain so there are no credentials to pass.
This method only works for our SP 365 online environment if I first make a connection by openning a site/folder from IE into Explorer. I still need to test it in Server, but it seems that Alteryx is waiting for my credentials to be established (SSL?) before it will allow the connection from Alteryx. We use Windows Authentication to SP.
Not sure this is going to work if I deploy the workflow to Server.