Connect to SharePoint Site with Multiple Lists

ZoeM

Hello Community!

I have a question regarding connecting to a SharePoint Site that houses multiple lists, is this possible?

New lists with the same structure are added continuously and I would like to find out if instead of connecting to one at a time, there could be a way to connect at the SharePoint Site level?

Thanks!

BrandonB

The Alteryx SharePoint List Input tool is basically a pretty wrapper around some API calls. In order to dynamically leverage lists, you would probably need to leverage the download tool and make API calls to the lists API endpoint: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-rest-endpoints

Once you retrieved all the lists in the site, you would need to leverage some logic to determine what lists you want to pull data from. Then once these lists are isolated, you would likely need a batch macro to query and parse all of the data.