topic Re: How to load data from share point list with pagination in QlikView

How to load data from share point list with pagination

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to load data from Share Point list and using Web File load. But, this loads only 1st page of the list.

how can we load all the pages from share point list?

Re: How to load data from share point list with pagination

marcus_sommer — Tue, 08 Nov 2016 09:32:25 GMT

I think you will need a loop for this which adds the page to the url. I mean something like this (here with an url-example from the community to demonstarte the logic):

for each page in '20', '40', '60'

load * from https://community.qlik.com/content?start=$(page)‌

- Marcus

Re: How to load data from share point list with pagination

gireesh1216 — Tue, 08 Nov 2016 12:24:18 GMT

My share point path is different.Its not coming order vise like 20,40,60.

Re: How to load data from share point list with pagination

marcus_sommer — Tue, 08 Nov 2016 12:52:12 GMT

If there is no new url for each page else the page will be refreshed per demand with any scripting you will need to trigger these demands (but I don't know which ways are possible for such a method and your share point).

- Marcus

Re: How to load data from share point list with pagination

gireesh1216 — Wed, 09 Nov 2016 07:13:26 GMT

Thanks for your replay

Re: How to load data from share point list with pagination

ramasaisaksoft — Wed, 09 Nov 2016 07:43:03 GMT

Hi Gireesh,

suppose your SP (SharePoint) list is having 250 items and that list having 25 rows each page.

If you want to load all the data from that SP list at a time you need to request SP team for Read access 250 items at a time to your id. Definitely they have chance

SharePoint-2013--how-to-modify-the-number-of-items-displayed-in-a-view

after that you already know the fetching data from web file.

Re: How to load data from share point list with pagination

gireesh1216 — Wed, 09 Nov 2016 12:38:37 GMT

Hi Sai,

Explanation is good but i have access only [ITEMS,LIST]. Don't have access on library.