AppointmentAssociations
Retrieve the IDs of all the objects associated to specific Appointments objects in HubSpot.
View Specific Information
AppointmentAssociations retrieves the IDs of all objects associated with specific appointment records in HubSpot. This table shows the relationships between appointments and other HubSpot objects such as contacts, companies, deals, and tickets.
SELECT
When selecting appointment associations, you must specify the appointment ID to retrieve its associated objects. For example:
SELECT * FROM AppointmentAssociations WHERE Id = '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. |