Retrieve the IDs of all the objects associated to specific Appointments objects in HubSpot.

Table Specific Information

The AppointmentAssociations table provides access to the relationship data between appointment records and other HubSpot objects such as contacts, companies, deals, and tickets.

SELECT

When selecting appointment 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 AppointmentAssociations WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'
SELECT * FROM AppointmentAssociations WHERE Type = 'contacts'

Filtering by multiple ID values with IN, combined with Type, retrieves associations for up to 1,000 appointments 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 AppointmentAssociations WHERE ID IN ('96ec8565-3b73-4ee8-9815-f90566ba9c42', '3fa85f64-5717-4562-b3fc-2c963f66afa6') AND Type = 'contacts'

INSERT

INSERT INTO AppointmentAssociations (ID, AssociationId, Type) VALUES ('25151', '12345', 'contacts')

DELETE

DELETE FROM AppointmentAssociations WHERE ID = '25151' AND AssociationId = '12345'

Columns