Forum Discussion
Hubspot Private Apps - Powerquery pagination
Has anybody managed to paginate hubspots api with the new private apps setup? Managed to make a call easily enough like so; let Source = Json.Document(Web.Contents("https://api.hubapi.com/...
Well, when I say work, I mean it will do what is as expected but depending on how long you have been using the crm it probably wont load to the workbook as there are too many rows.
You'll get something like this
As i say, id recommend using some filters in your URL
Syndicate_Admin Thank you so much! This has worked a treat! I'm going to create one query for each calendar year then append through PowerBI to avoid this issue.