Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All,
I am getting only 1000 records while fetching data from list using Share Point rest api .
May i know what value should be entered in Pagination -->Next Page url
if the list next url is something like below.
Ideally the url lies in/feed/link/ but we need fetch the href whose rel value is next or blindly the second row
Data sources implement the REST API to support multiple types of pagination. So you need to ensure that your data source has support for Next Page url pagination. Check your data source first
1. You can also, for example, test using POSTMAN . Sometimes this help to check pagination
2. did you try in "Select data to load (REST)" to set "Preload symbols count" to " No limit" and see if you can have more extracted data?
Thanks a lot for the link and confirmation . please find the below response
1.I have asked the application team of share point portal and they have confirmed that they do support pagination. I can either use next Url or next token path.
2.With no limit Preload Symbol count the data preview comes only 50 records but when do the data load we get only 1000 records
I assume if we are able to pass the right value to the next url or next token it might work