Using Windsor.ai to get Hubspot Email Opens (events)

[KLowe1]

I use Windsor.ai successfully to get Email Campaign stats like open rate / click into Power Bi. So, no issues connecting Hubspot + Windsor.ai + Power Bi.

My issue is when trying to get specific email events through Windsor (such as opens by specific email address). I cannot figure out how to connect to Email IDs to campaign/marketing email IDs or name. So I have no idea which email the Open is referring to. Every other ID column I try to add just creates a new blank row.

I feel like I'm missing an obvious column which links Email IDs to Campaign Email IDs. Even after reviewing windsor.ai's field documentation.

I've also tried to directly connect to Hubspot via API in Power Bi. Using the instructions from "Cayshin" in this question. However, even when I reduce the limit I always get stuck with the error "Expression.Error: Evaluation resulted in a stack overflow and cannot continue." 

[BérangèreL · Accepted solution]

Hi @KLowe1, I hope that you are well!

Thanks for asking the HubSpot Community!

First, I'd like to share these documentations that might be of interest:

- Email API
- Email analytics API

I have found for you a similar post "who has opened a marketing email via API" where the solutions from @IsaacTakushi and @Mulan might help you!

Also, I'd love to put you in touch with some of our Top Experts: Hi @sylvain_tirreau, @WesQ and @mangelet do you have suggestions to help @KLowe1, please?
 

Have a lovely day and thanks so much in advance for your help! ⭐

Warmly,
Bérangère