This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is there a way to get all items in a list without needing to select a view? For instance, we have a list with 20,000+ items but due to the SP view limit we've created numerous filters/views on the frontend. We'd like to do reporting on this list, but how do get everything without going thru a view? Or is there a way to loop thru all views?
You could probably create a bath macro to update the list in the tool and have it pull all of the views. The way the tool is setup you have to go through to the list. This is due to Sharepoints API. You could also look at Sharepoints API documentation and see if there is a way to pull just the lists. you an then use the Alteryx Download tool and create a workflow to pull that data.
Not sure if this is still relevant for you, but I just made a REST API call to sharepoint with the Download tool.
As input, you past inn your sharepoint folder url and add "/_vti_bin/ListData.svc" at the end. This gives you a list of all sharepoint lsits in that folder.
If you add "/NameOfListYouWant" at the end of that again, ir returns every line for that list.
Remember to add your credentials in the Download Tool.
You will get the results as xml, so add an xml parse tool after the download tool, and choose spesific Chiled with the value "properties" and tick the box "return child values".
Now, someone mentioned that there might be list limitations with the API call. I dont have any lists large enough to test that, BUT you can add query parameters to the url to get first X rows, then second url ucludes a parameter to get next x rows and so on.
Have you ever tried to build the URL for a REST API service call and ended up confused and frustrated? The OData query syntax is well documented, it's just not that intuitive. Well, if you want to query list data I have a little trick you can use to have the appropriate URL generated for you. The
Good to hear! Let me know if you need any help. I found that using the REST API also is way faster. The out of the box connector takes 30 seconds to read 3 lists, while the REST API takes 2.8 seconds to read 3 lists.