How to pull data from API that returns only 50 rows at a time.

[Zack_Christie]

Hey guys,

I am new to Power BI and I am doing a Get Data (Web) request to pull data back from an API. I am not sure how to get all of the data into my table. 

The API is designed to return only a limited number of results (50 rows at a time) and they specify in their API documentation that they use paging to send their data by providing a href URL for the next set of data.

This means that for me to receive all of the data, I need to provide the href URL sent back by the API in a new GET request and repeat that process until I pull all of the data back.

I need help setting up looping in the Advanced Editor to do the initial request and then request each of the URLs sent back from the API until I have reached the end of the data.

For each request sent there is a URL sent back with the rows of data from the request. Any ideas for this newbie? 

[lbendlin]

As you can probably appreciate it is nearly impossible to help with API queries without access to said API  (which you may not be willing to provide for understandable reasons)

Here's a good primer on API paging.  Handling paging for Power Query connectors - Power Query | Microsoft Learn