Webservices connector - paging with the body of the request

[ArielM (Ariel Mercado)]

Hi Team.

I am looking for a way to perform paging in a webservices connector using the paging tab within the HTTP operation.

The paging method used by the endpoint I am invoking is through the request body and brings 20 results on each call.

The body of the request looks similar to this:

{
    "spName": "sp_department",
    "params": [
        {
            "name": "@transaction",
            "value": "1000"
        },
        {
            "name": "@operation",
            "value": "T"
        },
        {
            "name": "@type",
            "value": "A"
        },
        {
			 "name": "@mode",
			 "value": "1"
        },
        {
			 "name": "@last_department",
			 "value": "19"
       }
    ]
}

Where in order to iterate you must assign the value of the last element in the object “@last_department”, in this case the value 19 since it is the last one of the first call.

Is there any way to include the body in the default paging method?

[Carlatto (Carl Nelson)]

I have never tried it, but you might be able to set the body using

$endpoint.body$ = <what ever the body needs to be>

Have you looked to see if the limit can be increased? 20 is rather low for most APIs.

[ArielM (Ariel Mercado)]

Hi Carl,

I tried to assign the body in this way but it was not recognized by the connector.
I managed to solve the pagination by using an AfterOperation Webservice rule.

Thanks for your help!