Forum Discussion
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
3 Replies
Hey ioniPeis ,
check the following articles, they describe exactly your scenario:
Loop through Multiple Web Pages using Power Query - Adatis
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicPlease see this video with a walkthrough of one way to do this.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
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
