How to loop thru a REST snap
Hello,
I am trying to load transaction data from a REST API end point. The API has pagination as required Input parameter. I am using the REST GET to fetch the data and the Https URL should be as b...
Forum Discussion
Is this is a duplicate of How to Access data from an REST API which has pagination as input parameters?
It’s in the line of same Topic. But i was trying to see if i can loop thru the REST GET Snap (even using any external code like python).
The REST GET have a build in pagination feature. Please review Example #4, 5 & 6 in the REST GET documentation.
Based on the Example 4 of the REST GET documentation, I tried to use the solution but getting errors. Attached is the screenshot of the REST GET snap which is used in my pipeline.
The scenario for my REST GET is mentioned below. The API URL has a header key for authorization as mentioned in the screenshot.
https://xxxxxx–xxx/transactions?datestart=2018-12-16T00:00:00&dateend=2018-12-17T00:00:00&pageSize=1000&pageNo=1
If the above URL has response with data, then the below should be triggered
https://xxxxxx–xxx/transactions?datestart=2018-12-16T00:00:00&dateend=2018-12-17T00:00:00&pageSize=1000&pageNo=2
If the above URL has response with data, then pageNo gets incremented until there is no data returned for the API.
The Has next attribute is set as “$entity.Items[*].length > 0” as i am checking the condition if the API returns any data. But the expression is failing.
Also the Next URL is set in such a way that it takes the input parameter along with the incremental value for pageno. Does this need to have the Header Authorization Key in the call? Please advise and help.
Thanks
Aravind Ncan you share the JSON output of this REST GET without pagination?
The best way to design “has next” and “next URL” I found is to use a mapper after REST GET to come up with an expression that will give you true for “has next” and next page URL for “next URL”. Once you figure those out then just copy those expressions back to the REST GET configuration.
