topic Re: Extracting data from reports in APIs & Integrations

Extracting data from reports

zeeshan180 — Fri, 19 Jul 2024 14:00:09 GMT

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?

Re: Extracting data from reports

KhushbooP11 — Fri, 19 Jul 2024 15:05:35 GMT

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!

Re: Extracting data from reports

zeeshan180 — Sun, 21 Jul 2024 10:26:59 GMT

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.

Re: Extracting data from reports

CJitea — Tue, 22 Jul 2025 15:48:38 GMT

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