Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I searched the community yet, but didn't find a working solution.... btw. I don't know much about sharepoint, xml and so on at the moment.
I need the read data from a paged sharepoint list. Each page contains of 30 entries. It's not that much data so I could generally concatenate all pages together...
I just tried to copy the link into QlikView like that
This basically works and I get the first 30 entries.
For the next 30 entries I see the followig link:
http://xxxxxxxxxxxx/Lists/Mitarbeiteruebersicht/AllItems.aspx?Paged=TRUE&p_LastName=xxxxxxxxxxxx&p_I...33144&PageFirstRow=31&&View={F45AB0E8-855B-475E-BE55-A2589E2489AE}
and for the next the following link:
http://xxxxxxxxxxxx/Lists/Mitarbeiteruebersicht/AllItems.aspx?Paged=TRUE&p_LastName=yyyyyyyy&p_ID=32969&PageFirstRow=61&&View={F45AB0E8-855B-475E-BE55-A2589E2489AE
The problem is that I don't know the appropriate next ID for entries 91 to 120 and so on...
Regards Robin
So, perhaps I missed something, but - why are you reading this list as a webpage, instead of reading the underlying data directly? QlikView can read lists from Sharepoint with no limitations I know of (at the very least, I read thousands of rows this way with no issues).
This page details several methods to do so - I use RPC calls (the second method listed):
have you tried loading the some example file as csv format say less than 1000 rows with dummy values
Hi, I don't know what you mean.
This sharepoint list is in our company network.
It would be no problem to export the whole list to Excel or csv but I need the read the list directly from sharepoint.
AFAIK, there is no way to read entire list.. I had a similar problem couple of years back(didn't find any solution). So had to use sharepoint extract in excel.
hm, that doesn't sound good ...
So, perhaps I missed something, but - why are you reading this list as a webpage, instead of reading the underlying data directly? QlikView can read lists from Sharepoint with no limitations I know of (at the very least, I read thousands of rows this way with no issues).
This page details several methods to do so - I use RPC calls (the second method listed):
I finally got it working with "method 2" using the correct link + correct LIST ID