SubscriptionAssociations
Retrieve the IDs of all the objects associated to specific Subscriptions objects in HubSpot.
View Specific Information
SubscriptionAssociations retrieves the IDs of all objects associated with specific subscription records in HubSpot. This table shows the relationships between subscriptions and other HubSpot objects such as contacts, companies, deals, and tickets.
SELECT
When selecting subscription associations, you must specify the subscription ID to retrieve its associated objects. For example:
SELECT * FROM SubscriptionAssociations WHERE Id = '3432'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | False | False |
Subscriptions ID | |
| AssociationId [KEY] | Long | False | False |
ID of the object that this Subscriptions object is associated with. | |
| Type [KEY] | String | False | False |
Type of the associated object, which can be a contact, deal etc. | |
| TypeId [KEY] | String | False | False |
The numeric ID for the association type. This column is empty for more general associations queries. | |
| Category [KEY] | String | False | False |
The category of the association type for the specified object pair. This column is empty for more generic associations queries. | |
| TypeLabel | String | True | False |
The label assigned to the association type between objects. |