JDBC Driver for HubSpot

Build 22.0.8462

ContactsToDealsAssociations

Retrieve the IDs of all the Deals objects associated to specific Contacts objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications.

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')

Delete

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

DELETE [ContactsToDealsAssociations] WHERE ContactsId='3432' AND DealsId='34654'

Columns

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

Contacts.Id

False

Contacts ID

DealsId [KEY] Long False

Deals.Id

False

Deals ID

TypeId [KEY] String False

AssociationsTypes.Id

False

The numeric ID for the association type. This column is empty for more general associations queries.

TypeName [KEY] String True

AssociationsTypes.Type

False

The name of the association type for the specified object pair. This column is empty for more specific associations queries.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462