Forum Discussion
How to overcome API call row limit?
Hello, I am attempting to extract measurement data from an API with a limit of 1000 rows per call. Each row consists of a data value and a timestamp. I have set up a Power Query script that conne...
Hello h4tt3n
there are a lot of examples of how to do in this forum.
They use all List.Generate where you have a parameter when to stop to generate to api calls like giving an error or empty page.
just start out to search for api List.Generate.
If you have any specific question feel free to come back
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy