Retrieves 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'

To retrieve associations for up to 1,000 appointments in a single batched request instead of one request per ID, filter by multiple ID values with IN, combined with Type. The driver 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 statements use the format:

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

DELETE

DELETE statements use the format:

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

Columns

Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False	Appointments.Id	False	Appointments ID.
AssociationId [KEY]	Long	False		False	ID of the object that this Appointments 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.