SubscriptionAssociations
Retrieve the Ids of all the objects associated to specific Subscriptions objects in HubSpot.
Table 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'
Filtering by multiple subscription Id values with IN, combined with the association Type, retrieves associations for up to 1,000 subscriptions in a single batched request instead of one request per Id. The connector splits IN lists larger than 1,000 values into additional batched requests automatically.
SELECT * FROM SubscriptionAssociations WHERE Id IN ('3432', '3433', '3434') AND Type = 'contacts'
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 | True |
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. |