APIs & Integrations

zeeshan180
Participant

Extracting data from reports

SOLVE

Hi, I want to extract data from reports in "Reporting and data" tab. 
https://app.hubspot.com/reports-list/{my_account_id}/123456789/?filterInDashboard=true

this is link to my report which I am trying to fetch. Problem is that I can't find any API for fetching the data from the reports. Can anyone suggest a solution or guide me about this.

Other Question is that can we export our report using an api as usually report is sent through the email?

0 Upvotes
1 Accepted solution
KhushbooRevOps
Solution
Participant

Extracting data from reports

SOLVE

Hey @zeeshan180 ,

Currently, HubSpot does not offer a direct API endpoint to fetch data from reports created in the reporting and data tab or to export reports.

However, you can use HubSpot’s Reporting API for custom reports created via the API, export reports manually, or schedule reports to be sent through email and then use email parsing tools to extract data.

For automation, you can use browser automation tools like Selenium. 

I hope it helps!

View solution in original post

0 Upvotes
2 Replies 2
KhushbooRevOps
Solution
Participant

Extracting data from reports

SOLVE

Hey @zeeshan180 ,

Currently, HubSpot does not offer a direct API endpoint to fetch data from reports created in the reporting and data tab or to export reports.

However, you can use HubSpot’s Reporting API for custom reports created via the API, export reports manually, or schedule reports to be sent through email and then use email parsing tools to extract data.

For automation, you can use browser automation tools like Selenium. 

I hope it helps!

0 Upvotes
zeeshan180
Participant

Extracting data from reports

SOLVE

Thanks @KhushbooRevOps  for your answer, so the reports which are not created through api's can't be accessed through the api's right?
For exporting of reports there is nothing except for downloading through the email? Actually, I don't want to go to the scrapping part due to some security issues.





0 Upvotes