Power BI Pagination API HubSpot

[matmachado]

Hi all,
I'm making a connection from the hubspot api in the power query.
It is from the GET reading method, but its pagination is the last result of the first query, called after. This after will be the link to the next page.
How do I view all pages?

[QueryWhiz]

Hi @matmachado As a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Hubspot connector in the data sources list:

After that, just grant access to your Hubspot account using your credentials, then on preview and destination page you will see a preview of your Hubspot fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[Aryna]

Hi @joostknoef , you alternatively can try to use a ready made solutions. I developed multiple Hubsport reports in Power BI before using connector from this provider https://vidi-corp.com/
Here is an examples of Hubspot report: https://drive.google.com/file/d/1VnnFaNjECPMTqnjRs8_5h6j8MQsAV40h/view?usp=sharing

[joostknoef]

Hi,

Have you been able to solve this problem? If so, can you post your solution here? Thanks!

[Anonymous]

Hi @matmachado ,

Refer to:

Reports - Get Pages - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Best Regards,
Eyelyn Qin