Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
Employee

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
Super User
Super User

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.