Forum Discussion

Siva_Venna's avatar
Siva_Venna
Contributor
7 years ago

Pagination in REST API

A very good explanation of how to implement pagination in REST API in this below blog post:

When I try to implement the same(I am extracting data from survey monkey api), I have noticed that when the “Next URL” is executing it is ignoring the query parameters provided.As shown in below image, when service URL is executing it’s getting right records considering all input query parameters i.e total:3043 but when “Next URL” is hitting it is extracting all records i.e. total : 61896

How to include query parameters in “Next URL” to get required data?

9 Replies

  • JensDeveloper's avatar
    JensDeveloper
    Contributor II
    4 years ago

    Why should it create an issue because then you only have the files with filed data to insert right ?
    I can’t follow what your saying. You mean Succes after the last oracle insert? Or what do you mean?

      • JensDeveloper's avatar
        JensDeveloper
        Contributor II
        4 years ago

        Hi @amit.saroha ,

        Below is the attachement of the pipeline. It’s a file reader with csv parser and router. Only use the csv parser and router.

        Explanation CSV parer:
        uncheck the checkbox ‘ignore empty stream’ - check containts headers.

        Router explanation.
        The first expression will return true if the input data is not empty ( it will output the input data to the first output view ), and the second expression will simply return true and will output the data on the second output view. With the First match option checked, only the first expression that returns true will be evaluated to the output even if there are more expressions that return true.

        CsvFile_Validation_V1.0_2022_07_07.slp (5.1 KB)

        Regards

        Jens