Extracting data from reports

[zeeshan180]

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?

[CJitea]

Hi @zeeshan180 @KhushbooP11, there is a feature request raised here for fetching report data. Please up-vote, if you are interested.

[KhushbooP11 · Accepted solution]

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!

[zeeshan180]

Thanks @KhushbooP11  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.