Forum Discussion
how to create a query that paginates?
ImkeF I absolutely have 😆
I've rewritten it about 15 times today in notepad++ but the but I can't seem to figure is how to capture the JSON output and feed it back into the query.
I understand in the query you've written as in you're feeding in the JSON as the source directly, then parsing that, then using part of that to build the next URL and looping through until done.
And in mine i'm just calling the API, capturing the JSON results and converting to a table.
The bit I don't understand is how i'd get the results from my query and feed them into what you've written - in one query - because the JSON has to be recieved from the original call. Unless i'm missing something really obvious, as I say, I'm very new to this so could well be.
btw, side note, is there any reliable syntax highlighting for this?
Scratch that, found a Power Query XML import for Notepad++
Happy to share if anyone requires.
Anonymous thanks for the posts, did you manage to get your code working? I am using the same source as you (GC) and having trouble manipulating the code so that it refreshes in Power BI online, I have managed to create my report so that i can refresh it in Power Bi desktop but obviously this is not the ideal solution.
noorul unfortunately not, i'm not really a developer and I couldn't quite figure it out and ran out of time to look at it.
I'm still very much interested in a solution though as at the moment I have to produce a report daily which i'd rather not have to 😄
