MCP Server for HubSpot

Build 24.0.9300

ContactsToDealsAssociations

Lists deal IDs associated with specific contacts, useful for managing contact-deal relationships.

View Specific Information

This is a sample associations table exposed when the ExpandAssociations connection property is set to True.

SELECT

A query to this table will return will return all the Id pairs of the associated records from the two object types, Contacts and Deals.

SELECT * FROM ContactsToDealsAssociations

INSERT

To add a new association between a Contacts record and a Deals one, you simply need to specify the Id-s of the two records to be associated.

INSERT INTO ContactsToDealsAssociations (ContactsId, DealsId) VALUES ('3432', '34654')

Columns

Name Type ReadOnly References Filterable Description
ContactsId [KEY] Long False

Contacts.Id

False

Unique identifier for the contact involved in the association.

DealsId [KEY] Long False

Deals.Id

False

Unique identifier for the deal associated with the contact.

Type String False False

Specifies the type of association between the contact and the deal, such as primary, secondary, or custom.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9300