Odata api pagination request using (top/skip/count) url parameters

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?