Paginated API Results - Power Query

Power BI Software & Tools
1

Hello everyone. I’m stretching my abilities with this one and would welcome any advice you may have to offer. I’m working on building a model using an API web query to a medical practice app. Not too difficult except that the returned data is paginated with only 50 rows being returned for each page. I’ve found quite a lot of help in github for the app in question but am not versed in PQ enough to make sense out of the errors I’m getting.

Happy to provide the script I’ve developed thus far if anyone is interested. It works, mostly… :slight_smile:

Cheers - Matthew

1 Like
2

Hello @mkaess,

You could take a look at this video: https://www.youtube.com/watch?v=vhr4w5G8bRA&t=12s
If I understand correctly you query this should solve the issue.

If you liked my solution please give it a thumbs up :+1:.

If I did answer your question please mark my post as a solution :white_check_mark:.

Thank you !

Cristian

3

Thank you. I’ll look at this and update this post with the results. The scenario is not quite the same but it may work.
-mk

1 Like
5

This is proving to be more complicated that I first anticipated. It’s a REST API query that needs to identify each page of data returned by the API then expand/combine into a single table. I have made some progress but have not solve for the page issue yet. I will post more when (or if) I do.

Here’s a link to a github page about the application’s API functionality. https://github.com/redguava/cliniko-api

The code used isn’t ‘M’ so it needs some translating.