AssociationsTypes
Lists all association types available between CRM object pairs in HubSpot, defining relationship mappings.
View Specific Information
Select
You must specify FromObjectType and ToObjectType. For example:SELECT * FROM AssociationsTypes WHERE (FromObjectType = 'companies') AND (ToObjectType = 'deals')
Note: You cannot reference custom objects by base name. When querying AssociationsTypes, if FromObjectType or ToObjectType 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.
Columns
| Name | Type | References | Filterable | Description |
| Id [KEY] | String | Unique numeric identifier for the association type, used to differentiate relationship types between HubSpot objects. | ||
| Type | String | The descriptive name of the association type, indicating the nature of the relationship between two HubSpot objects. | ||
| FromObjectType [KEY] | String | True | Specifies the type of the source HubSpot object (such as contact or company) in the association pair. | |
| ToObjectType [KEY] | String | True | Specifies the type of the target HubSpot object (such as deal or ticket) in the association pair. |