topic Re: How to Extract data from custom report by api call in APIs & Integrations

How to Extract data from custom report by api call

srozentsvayg — Thu, 29 Apr 2021 19:01:26 GMT

Hey

I have one custom report and i would like to extract whole data from it with fields by api GET call. I didnt find any ducomentation for it . can any one provide more details how to slove it?

Re: How to Extract data from custom report by api call

dennisedson — Fri, 30 Apr 2021 14:40:03 GMT

Hi @srozentsvayg

Not sure if this is the direction you are looking to go, but here are the endpoint for reports

@RMones might have some more thoughts on this.

Re: How to Extract data from custom report by api call

srozentsvayg — Sun, 02 May 2021 09:24:47 GMT

i am not able to find support to pull data from custom reports by using analytics . or i am missing somting?

for example i have location of the report

https://app.hubspot.com/reports-list/<account_id>/77842715/

77842715 = is id for report , i cant find parameters where to pass it trougth analytics api

Re: How to Extract data from custom report by api call

webdew — Thu, 06 May 2021 08:11:56 GMT

Hi @srozentsvayg

Please use this api for reports fetch data.

https://api.hubapi.com/analytics/v2/reports/<breakdown_by>/<time_period>?hapikey=demo&start=20180101&end=20180301

Format Examples :

breakdown_by like => totals, sessions, sources, geolocation etc
time_period like => total, daily, weekly, monthly etc
Start date format => YYYYMMDD
End date format => YYYYMMDD

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.