JDBC Driver for HubSpot

Build 26.0.9770

AssociationsLabels

Retrieves all available association labels and types defining relationships between pairs of CRM objects in HubSpot.

View-Specific Information

SELECT

You must specify 'FromObjectType' and 'ToObjectType'.
SELECT * FROM AssociationsLabels WHERE FromObjectType = 'Companies' AND ToObjectType = 'Deals'

Columns

Name Type References Filterable Description
TypeId [KEY] String The numeric identifier representing the specific association type.
Category [KEY] String The classification category of the association type between the two objects.
Label String The name or label assigned to describe the association between the specified objects.
FromObjectType [KEY] String True The type of the originating object in the association relationship.
ToObjectType [KEY] String True The type of the destination object in the association relationship.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770