Hi
We’re using the Windsor.ai HubSpot connector to report on Deals and Contacts, but we’ve hit a gap: we need to join Deal records to their associated Contact records (for example, pulling a Deal’s stage alongside the Contact’s ad campaign/ad set properties), and there’s currently no way to do that through the connector. Every deal-level field we’ve checked that would normally carry campaign or contact-level data comes back empty, and there’s no join key (like a primary associated Contact ID) exposed on the deal table either.
We understand HubSpot’s standard CRM API has a dedicated Associations API for exactly this — it returns Deal ID ↔ Contact ID pairs (plus an optional association label), which HubSpot’s own docs recommend as the standard way to build a flattened Deal-Contact dataset.
Does Windsor’s HubSpot connector support (or have plans to support) the CRM v3 Associations API, so we could pull deal-to-contact associations and join properties across both objects? If not currently, is this something you’d consider adding, and is there a way to track the request?
Happy to share more detail on our exact use case if helpful.
Thanks,
Jenny