API pagination next_page parameter

[ioniPeis]

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

 

[mahoneypat]

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

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

Pat

[ioniPeis]

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]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic