How to load data from share point list with pagination

[gireesh1216]

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?

[marcus_sommer]

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

next

- Marcus

[gireesh1216]

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

[marcus_sommer]

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

[gireesh1216]

Thanks for your replay

[ramasaisaksoft]

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.

[gireesh1216]

Hi Sai,

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