cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ioniPeis
Regular Visitor

API pagination next_page parameter

Hello, I need to iterate using the next_page parameter to be able to fecth all the api records joining each page in a single final table. In each call I can fecth 1000 records and I have no way of knowing in advance how many pages there are or how many records there are.
Any help will be very valuable.
Thanks in advance.

 

https://WEB/api/3/API_KEY/contact?page=1

Captura de Pantalla 2021-05-16 a la(s) 11.39.56.png

3 REPLIES 3
mahoneypat
Super User IV
Super User IV

Please see this video with a walkthrough of one way to do this.

Power BI - Tales From The Front - REST APIs - YouTube

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hi Pat, Thanks, I just saw the video, it is a good resource but it is not my case as I do not have the total_count parameter. If I had it, I could generate a list of number from 1 to (total_count / 1000) to know how many pages I need to have all the records, but it is not possible.

 

Jon

selimovd
Community Champion
Community Champion

Hey @ioniPeis ,

 

check the following articles, they describe exactly your scenario:

Loop through Multiple Web Pages using Power Query - Adatis

Iterating over an unknown number of pages in Power Query - avoid endless loops - Power BI (powerbi-p...

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Top Solution Authors