Add Support for HubSpot Associations in Destination Connector

[neguezaymen]

The current HubSpot destination in Airbyte already supports writing to both standard objects (Contacts, Companies, Deals, etc.) and custom objects. However, it does not yet provide native support for creating associations between these records.

This feature request proposes extending the HubSpot destination to handle associations via the HubSpot API. For example:

Linking a Contact to a Company

Associating a Deal with multiple Contacts

Relating Custom Objects to standard objects (e.g., a custom Subscription object linked to a Contact)

Supporting associations between custom objects themselves

Key benefits:

Preserve the relational structure of CRM data when syncing into HubSpot.

Ensure that objects written via Airbyte reflect real-world business relationships.

Enable more advanced HubSpot use cases by leveraging both default and custom associations.

Potential implementation details:

Extend the destination configuration to define association mappings (e.g., contactId → companyId).

Support both default HubSpot associations and custom associations defined in the HubSpot account.

Handle upserts gracefully to prevent duplicate or broken associations.

Adding this functionality would make the HubSpot destination more complete and better aligned with HubSpot’s data model.