topic Re: How to read data from Paged Sharepoint 2013 List?!? in QlikView

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

Anonymous — Fri, 02 Jun 2017 12:44:54 GMT

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_ID=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

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

tajmohamed30 — Sun, 04 Jun 2017 12:05:27 GMT

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

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

Anonymous — Mon, 05 Jun 2017 09:15:28 GMT

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.

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

kamal_sanguri — Mon, 05 Jun 2017 09:28:02 GMT

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.

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

Anonymous — Tue, 06 Jun 2017 08:47:01 GMT

hm, that doesn't sound good ...

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

Or — Tue, 06 Jun 2017 08:57:28 GMT

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

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

Anonymous — Wed, 07 Jun 2017 12:07:23 GMT

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