AppointmentAssociations
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 only supported server-side operator is =.
SELECT * FROM AppointmentAssociations WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42' SELECT * FROM AppointmentAssociations WHERE Type = 'contacts'
INSERT
INSERT INTO AppointmentAssociations (ID, AssociationId, Type) VALUES ('25151', '12345', 'contacts')
DELETE
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. |