Forum Discussion

Tommy's avatar
Tommy
New Contributor III
5 years ago
Solved

Pagination from JSON Path Has Next URL - Trustpilot

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.

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

I use this same JSON path in the Next URL:

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

REST
  • mbowen's avatar
    mbowen
    4 years ago

    Hi @Henchway :

    There is also a LDAP Delete Attibute Value snap which will delete just the values for the attribute.

    It looks like the LDAP Delete Attribute snap will remove the attribute and value.

    The snap looks up the distinguished name and then submits a ModifyRequest to remove the attribute. We use the Apache Directory API to do this which documents removal as “removing an attribute and value from an entry”.

    That said, I actually haven’t tested this, but could to confirm. Others may have experience doing this.

6 Replies

  • del's avatar
    del
    Contributor III
    5 years ago
    Copy LinkReport

    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

  • svatada's avatar
    svatada
    Former Employee
    2 years ago
    Copy LinkReport

    You will get an IndexOutOfBoundsException if the entity does not include next-page information.

    update your exp to below:

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

     

  • svatada's avatar
    svatada
    Former Employee
    2 years ago
    Copy LinkReport

    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