I was trying to fetch data from an odata api which has $count / $skip /$top urlparameters
and I wanted to fetch all the data using a workflow and store it in a database table
but i am struggling with how to do the pagination in the requests.
- Can I just to the call to the api first with $count=true and $top=1 to get the total count eg. 100
- Then how can I advance the "$skip" parameter in retool so I can just paginate till the count is up
- will this creates a single response which I can then push inside of the database table?
Not sure how to "program" this?