Alteryx - Grab sharepoint Lists

Question

Hi there,

So trying to get all the lists  on a specific sharepoint - doesn't look like i can do this via the Sharepoint List INput tool (unless im mistaken)

I'm trying to do it through the download tool but keep getting a 401 error but i'm using our domain\username and password setup.

This is the url i'm trying to hit tool https://sp007.companysite.net/sites/uniquesitename/_api/web/lists/

Any idea on what I'm doing wrong or what is still needed?

bkclaw113 · Answer

Hey @jbravman_ , I had someone from your company reach out to me about how to do this same thing and ran across this post when researching. Bumping it up to top of mind for you in case Hari reaches out to you.

jbravman_ · Answer

Thanks so we already use that stuff for the end of our flow but i figured it out. Turns out we were able to get the JSON from Sharepoint SOAP API (EWWW), from there I parsed it out to get all the sites and sub-sites, then parsed out the List and Views... from there we sent it through the Sharepoint Input tool (dynamically) to grab all the data.

Appreciate the responses. Cheers.

ArtApa · Answer

Hi @jbravman_  - You may find the following articles useful:

https://community.alteryx.com/t5/Alteryx-Designer/SharePoint-Input-Tool-SharePoint-Online/m-p/557488#M121203

https://community.alteryx.com/t5/Alteryx-Designer/How-To-Connect-to-Sharepoint-with-Alteryx/ta-p/596329