Hi All,
I have some challenges with Web-service connector especially for pagination. Basically my account aggregation url looks something like below:
https://example/com/REST/v1/Users?pageSize=10&pageNo=1
I have implemented pagination script as shown below.
$sysparm_limit$ = 10
TERMINATE_IF $response.totalCount$ < $response.pageNo$ * $response.pageSize$
$sysparm_offset$ = $sysparm_offset$ + 1
$endpoint.fullUrl$ = $application.baseUrl$ + “Users?pageSize=” + $sysparm_limit$ + “&pageNo=” + $sysparm_offset$
What I have noticed is, sometimes it only processes first 2 pages and some time it process all the pages. I have also noticed connector is hitting the first page twice.Could you please let me what is the significance of Initial Offset and Page size fields:
Could you please let me know what exactly I am missing here?
Thanks,
Venu