cancel
Showing results for 
Search instead for 
Did you mean: 

Pagination from JSON Path Has Next URL - Trustpilot

Tommy
New Contributor III

Hello,

I am trying to call a rest get API with some pagination. The API returns the next page URL within the response, so i should be able to use this in the snap.

image

I am getting the value using JSON Path seen here in a mapper as an example:
image

I use this same JSON path in the Next URL:
image

Unfortunately, the snap does not call for the next page. I can only assume it sees the value as null?

Any help would be appreciated.

Many thanks

1 ACCEPTED SOLUTION

del
Contributor III

I believe the main issue is jsonPath is returning an array, so for Next URL you will need to index it with [0].

jsonPath($, "$entity.links[?(@.rel=='next-page')].href")[0]

And with it producing an array, a more appropriate Has next condition might be to check for the array length > 0. (Yet I suspect it will work as-is in this specific use case.)

jsonPath($, "$entity.links[?(@.rel=='next-page')].href").length > 0

View solution in original post

6 REPLIES 6

VijayKasindala
New Contributor

Thank you .It did not work.I am getting only first page results.Please find the mapping for reference.

VijayKasindala_0-1721300448763.png

 

svatada
Former Employee

@VijayKasindala

In my example, I did not include the root element. Please add it to the expression to make it work.

Nit: You can always use pipeline validation to build your expression.

 

jsonPath($, "$entity.links[?(@.rel=='next-page')].href").length > 0 ? jsonPath($, "$entity.links[?(@.rel=='next-page')].href")[0] : null