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.
SOLVED

I need to download files from a subfolder of sharepoint office 365.

DurgaNavya
5 - Atom

1. I tried using Sharepoint List Input tool - when i am giving the full path including the sub folders it is throwing an error. Sharepoint list input tool is able to take only main directory

for eg:

https://XXXXX.sharepoint.com/sites/DigitalWorldTeam/Team%20Documents/8%20Trading%20Analytics/

in the 8 Trading Analytics my files are present.

But the sharepoint input tool is able to take the url till DigitalWorldTeam.

I thought %20 is not working since in the url space is replaced by %20 and i tried with other options as well by removing %20 and giving the space, hypen etc.

2. Tried using directory tool, by giving the network path

eg:\\XXXXX.sharepoint.com@SSL\DavWWWRoot\sites\DigitalWorldTeam\Team Documents\8 Trading Analytics\

it is throwing an error saying the invalid directory.

 

Any help is much appreciated.

 

Thanks in Advance

Navya

 

4 REPLIES 4
GiuseppeC
Alteryx
Alteryx

Hi @DurgaNavya,

 

the Sharepoint List Input in Alteryx only works with data formatted as Sharepoint lists. I found this article on Microsoft’s support page about lists here. If you are not sure what they are and if these are set up on your Sharepoint, use can use the following as a work around.

 

You can sync a local folder on your laptop to you sites on Sharepoint online. This will create a local copy of the content, which will be synched with the online content so that it’s always up to date.

 

From Alteryx, you can read files/directories using the standard Input tool, pointing at the local Sharepoint folder on your laptop. Alternative, the Directory Tool pointing to your local folder should work just fine.

 

To create the synced local copy: Log into your Sharepoint online, navigate to your site > click on the 3 dots > Sync > log in > Start Sync

 

Hope this helps!

Giuseppe

bharatandalam
8 - Asteroid

Hi @DurgaNavya 

 

One of the way to do that is to sync the Sharepoint to your local desktop and use the path from the DIRECTORY TOOL and get the data

DurgaNavya
5 - Atom

HI Giuseppe

 

Thanks for the reply.

I have two sharepoint links. one is of office 365 and the other version is below server 2019 from where i should get the files

Your option works for office 365 and server 2019. But for the lower versions what can i do?

 

Thanks in advance

Navya

 

GiuseppeC
Alteryx
Alteryx

Hi @DurgaNavya,

 

you should be able to access older Sharepoint document libraries by using the regular Input tool or Directory tool once you have a UNC path, as described here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Download-Files-from-Sharepoint-2013/td...

 

I found this article on how to map an older Sharepoint library as a network drive here:

https://whitepages.unlimitedviz.com/2010/12/unc-path-naming-for-files-stored-on-sharepoint-2/

 

Hope this helps!

Giuseppe

Labels