Cmdlets for HubSpot

Build 24.0.9032

DealAssociations

Deal associations can be used to insert or delete individual associations with Deals.

Table Specific Information

Deal associations represent Company and Contact associations made with existing deals that may be modified.

SELECT

When selecting deal associations, they can only be filtered by the Id. For example:

SELECT * FROM DealAssociations WHERE DealId = 12345

INSERT

New associations may be inserted by specifying the DealId, AssociationId, and the AssociationType during an INSERT statement. For example:

INSERT INTO DealAssociations (DealId, AssociationId, AssociationType) VALUES (12345, 6789, 'COMPANY')

DELETE

Associations may be removed by specifying the DealId, AssociationId, and the AssociationType during a DELETE statement. For example:

DELETE FROM DealAssociations WHERE DealId = 12345 AND AssociationId = 6789 AND AssociationType = 'COMPANY'

Columns

Name Type ReadOnly References Description
DealId [KEY] Long False

Deals.DealId

The Id of the deal.

AssociatedId [KEY] Long False

The Id of the associated entity.

AssociationType [KEY] String False

The type of association such as Company, or Contact.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9032