Pagination for REST connector with multiple links and URL manipulation

[Kshah]

Hello,

Below is our response from an API call with Infor. Note, there are no 'links' in the headers of the response:

I am trying to use the link found in the "rel": "next" section. I am also trying to make some manipulations to the reference URL so that we can actually use the URL to return results. Below is the pagination I am trying:

"pagination": {

"nextUrl": {

"nextUrlPath": "${response?.completeResponseMap?._links.href[1]==''?null:'https://TestSite.com/path1/path2/path3/Employee'+response?.completeResponseMap?._links.href[1]}"

}

}

Trying to add the response URL onto the end of the above URL. The error message keeps pointing at a "Syntax error at index 1". Please advise

Thank You

[rushikeshvartak]

Refer example 1 from https://docs.saviyntcloud.com/bundle/REST-v23x/page/Content/Developers-Handbook.htm

[Kshah]

example 1 does not have the issue of each link (next, prev, self) being called as "href". We are trying to only use HREF where REL = NEXT. 

[Rajesh-R]

@Kshah  - Could you try the following:

"pagination": {
"nextUrl": {
"nextUrlPath": "${urlNextPath=''; ArrayList arr = response?.completeResponseMap?._links; if(arr.size()>0){arr.eachWithIndex{ val, idx -> if(val.rel?.equals('next')){ urlPathNext=val.href;}}} return 'https://TestSite.com/path1/path2/path3/Employee'+urlPathNext;}
}
}

[Kshah]

Hi Rajesh,

Trying that pagination returns same error message on syntax:

Got null response statusCode with erroMsg - [error:Error Illegal character in path at index 1: ${urlNextPath=''; ArrayList arr = response?.completeResponseMap?._links; if(arr.size()>0){arr.eachWithIndex{ val, idx -> if(val.rel?.equals('next')){ urlPathNext=val.href;}}} return 'BaseURL'+urlPathNext;}]

Any suggestion?