Forum Discussion
how to create a query that paginates?
I'm working with the Hubspot CRM API and when you query for a list of all deals, you only get 100 records at a time, and they want you to send subsequent queries with an "offset" to paginate the resu...
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 😄