Extracting email tracking data (Sends, Opens) using API's

SOLVE
Manoj_Rao
Member

How can I automate extracting email tracking data (Opens, Clicks and sends) from Hubspot Marketing hub to Qlik sense ?

witout using third party app. 

 

I believe I can use Email Events API.

https://legacydocs.hubspot.com/docs/methods/email/get_events

The maximum allowed limit is 1000 records. But we have 2million sends each day.

 

Thanks,

 

 

0 Upvotes
1 Accepted solution

Accepted Solutions
taran42
Solution
Contributor

@dennisedson Hello!

 

@Manoj_Rao, I think the limit you are referring to is 1000 records per API call. So what you need to do is mark your location within the call, then make another call starting where the last record ended. So you will use pagination to mark your place at record 1001, call another 1000 records, then mark your place at 2001, call another 1000, etc.

View solution in original post

0 Upvotes
2 Replies 2
dennisedson
Community Manager

Hello @Manoj_Rao ,

That is a limit per call.  You would use the offset and and the hasmore properties and loop through them.

@taran42 , I have not heard from you in a while 👋.  Do you have any advice for @Manoj_Rao ?

Thanks,

Dennis




Check out our Community Developer Blog
where we feature our Community driven developer podcast and how to content
0 Upvotes
taran42
Solution
Contributor

@dennisedson Hello!

 

@Manoj_Rao, I think the limit you are referring to is 1000 records per API call. So what you need to do is mark your location within the call, then make another call starting where the last record ended. So you will use pagination to mark your place at record 1001, call another 1000 records, then mark your place at 2001, call another 1000, etc.

View solution in original post

0 Upvotes