We are integrating smartsheet rest api’s in snaplogic. We get only totalrecordscount in the response. there is no other things comes up in response. I need to apply pagination . In paramters i can use page and pageSize .
Page is something which page we want to access and pageSize is 100 by default. These 2 paramters are not part of the response.
I am not sure how I can create hasNext and nextUrl to paginate and fetch all 77k records.
I am attaching the screenshots of rest snap settings .I am unable to loop. it is like never ending. please suggest.
offset is a parameter i gave as 0 for incrementing in nexUrl page
I think you are very close given your screenshot. But you want to get the next page as long as:
$totalRowCount > ((snap.out.totalCount+1) * 1000)
Then next url is built with
...page=" + (snap.out.totalCount+2) + "...