Hi,
You can see in this package that I built that we are importing data into the Deal object and Contact objects in HubSpot and keeping that information up to date through the UPSERT function.
When there is not a relationship between a Contact and Deal and an email exists, I'd like to create one. That is the last task in this package. The issue I'm running into is that the package will recreate the relationship between Contacts and Deals even if it already exists.
Is there a way to only check for Deals that do NOT have a relationship with a contact record to see if it can create one? We will need to create relationships between Deals and Contacts when the Deals and Contacts are brand new (they show up in the CSV import for the first time). But most of the rows in the CSV files will be there every day. I'd prefer not to waste time recreating the Deal/Contact relationship when it already exists in HubSpot.
Thanks!
