Paging / pagination to happen in request body (not relativeURL)

Hello,

I have a target system which supports pagination, via postman pretty straightforward, however via WebService connector not so much.

I am aware of documentation, but there are two methods mentioned - either relativeURL or body:soap

My system requires such variable (“page”) to be dynamic:

{
    "page": 1,
    "pagesize": 100,
    "sort": [
        {
            "columnUri": "urn:replicon:user-list-column:user",
            "isAscending": true
        }
    ]

My question is:
How can I “ask” the connector to push +1 number into a page number in body?

Trying this but no luck, and I assume that characters as quotation are not processed properly:

TERMINATE_IF $NO_RECORDS$ == TRUE
$nextOffset$ = $nextOffset$ + 1
$request$ = "{
    "page": " + $nextOffset$ + ",  
    ""pagesize": 100,
    "sort": [
        {
            "columnUri": "urn:replicon:user-list-column:user",
            "isAscending": true
        }
    ],
    "columnUris": [
        "urn:replicon:user-list-column:user"
        
    ]
}"

Thank you
Jakub

Hi Jakub,

When you say “no luck”, what issues are you seeing? Is the request body being built correctly, but it’s not incrementing the offset between calls? Is it only making one request, or is it an infinite loop?