REST API pagination & filtering

Anonymous — Thu, 02 Jan 2020 15:54:14 GMT

Hi everybody,

It's my first time using a REST API as a data source and this is my situation:

1. Pagination: I've figured out how to use a parameter to loop through pages since each page allows only 500 rows. I've followed this blog https://adatis.co.uk/Loop-through-Multiple-Web-Pages-using-Power-Query/ and the pagination works pretty good. The only challenge now is that I need to have a dynamic table that has the right number of pages (maybe counting my records?) instead of what I have right which is a fixed number of pages.

2. Power BI limitation of importing 10,000 rows from an API call for Pro Users. I need to import around 250,000 rows and I'm trying to filter my data source on the query script so I can use multiple calls with less than 10,000 records each , for example: https://source.com/api/v4/orders?carrier_name=fedex&per_page=500&page=
But the result does not change...Is it something that my developer has to give me permission to use as a filter? The parameters that I'm using are actual columns on my API so I'm not sure why it does not work. Is there another way of doing this?

Thank you!

topic REST API pagination & filtering in Developer

REST API pagination & filtering