Get Your Financial Reports in Order with Our New Quickbooks Connector 👉 Set it Up Get Your Financial Reports in Order with Our New Quickbooks Connector

Deals Contacts

Many to many connection table between all the contacts to their respective deals

Related Integrations: All Integrations / HubSpot
-- CREATE VIEW hubspot_deals_contacts AS
SELECT hda.hubspot_deals_id AS deal_id
	, hdaav.value AS contact_id
FROM hubspot_deals_associations hda
LEFT JOIN hubspot_deals_associations_associatedvids hdaav ON hda.id = hdaav.hubspot_deals_associations_id
WHERE hdaav.value IS NOT NULL
GROUP BY 1, 2;

Requirements:

Usage:

This view can be used in order to connect between a contact and its deals

Modifications: