@Reesetrain2 your first solution using the network location worked perfectly! thanks!
@Reesetrain2 wrote:
All,
I posted this in adifferent forum, but I wanted to make sure everyone saw this as it is actually fairly simple to connect as long as you create a network location...
The easiest way that I have found to download a file from Sharepoint is as follows:
1.Open Sharepoint in Internet Explorer and browse your way to the file
2. Once you are to the file, copy the address
3. Truncate the address to just the sharepoint, i.e https://XXXX.sharepoint.com/sites/
4. Go to My Computer, right click and create Add a Network Location
5. Follow the wizard as you should just use the truncated address when setting up the new Network Location
6. Go to Alteryx and use the Input Data Tool.
7. You will now be able to click on the network location and then subsequently select the correct folders in order to get to the file.
8. Once selected, you are all set!
The other option is to use the Directory Tool
Follow steps 1-5
6. Go to Alteryx and use the Directory Tool
7.You can now click on teh network location and then subsequently select the correct folders, expect now, use the folder that your file is in vice selecting on the file itself.
8. You will now be able to manipulate all files in this directory, if you say, need to download all files (If so, you can use the download tool and a select tool).
Cheers!
Matt
