How to read data from Paged Sharepoint 2013 List?!?

[Anonymous]

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

[tajmohamed30]

have you tried loading the some example file as csv format say less than 1000 rows with dummy values

[Anonymous]

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.

[kamal_sanguri]

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.

[Anonymous]

hm, that doesn't sound good ...

[Or · Accepted solution]

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):

Reading Data from Sharepoint lists into QlikView

[Anonymous]

I finally got it working with "method 2" using the correct link + correct LIST ID