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
Note: You cannot reference custom objects by base name. When querying ContactToDealsAssociations, if Type refers to a custom object, the value must now be either the short-hand object type name (p_<object_name>) or the fully qualified object type name.
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. |