ListingAssociations
Retrieve the IDs of all the objects associated to specific Listings objects in HubSpot.
Table Specific Information
The ListingAssociations table provides access to the relationship data between listing records and other HubSpot objects such as contacts, companies, deals, and tickets.
SELECT
When selecting listing associations, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and, for the ID column, IN.
SELECT * FROM ListingAssociations WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42' SELECT * FROM ListingAssociations WHERE Type = 'contacts'
Filtering by multiple ID values with IN, combined with Type, retrieves associations for up to 1,000 listings 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 ListingAssociations WHERE ID IN ('96ec8565-3b73-4ee8-9815-f90566ba9c42', '3fa85f64-5717-4562-b3fc-2c963f66afa6') AND Type = 'contacts'
INSERT
INSERT INTO ListingAssociations (ID, AssociationId, Type) VALUES ('25151', '12345', 'contacts')
DELETE
DELETE FROM ListingAssociations WHERE ID = '25151' AND AssociationId = '12345'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | False |
Listings.Id | False |
Listings ID. |
| AssociationId [KEY] | Long | False | False |
ID of the object that this Listings 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. |