Webservice Connector - Pagination

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