Hooray! We just launched a direct integration with 🛍   BigCommerce 🛍! Check it out Hooray—Panoply now offers direct integration with BigCommerce!

Deals Companies

One to many connection table between all the companies to their respective deals

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

Requirements:

Usage:

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

Modifications: