BookingAppointments
Provides details about the appointments that are and can be scheduled for a business that is determined by the field bookingBusinessId.
Columns
| Name | Type | ReadOnly | References | Description |
| additionalInformation | String | False |
Any additional information linked to this appointment. | |
| anonymousJoinWebUrl | String | False |
A URL that allows a participant to join the appointment. | |
| appointmentLabel | String | False |
A label that was applied to this business. May be any string value. | |
| createdDateTime | Datetime | False |
The date and time that this appointment was created. | |
| customerEmailAddress | String | False |
The email address of the customer that will be participating in this appointment. | |
| customerName | String | False |
The name of the customer. | |
| customerNotes | String | False |
Notes on the customer that are linked to this appointment. | |
| customerPhone | String | False |
The customer's phone numbe.r | |
| customers | String | False |
The customers that will be attending this appointment. | |
| customerTimeZone | String | False |
The timezone that the customer operates in. | |
| duration | String | False |
The duration of this appointment. | |
| endDateTime_dateTime | Datetime | False |
The datetime value of the scheduled end of the appointment. | |
| endDateTime_timeZone | String | False |
The timezone of the scheduled end of the appointment. | |
| filledAttendeesCount | Boolean | False |
The number of attendees to this appointment. | |
| isCustomerAllowedToManageBooking | Boolean | False |
A flag that indicates if the customer can control the attendees or cancel the appointment | |
| isLocationOnline | Boolean | False |
A flag that indicates if the appointment is held in a physical location or online. | |
| joinWebUrl | String | False |
The URL to join the appointment. | |
| lastUpdatedDateTime | Datetime | False |
The last time this appointment was updated. | |
| maximumAttendeesCount | Boolean | False |
The maximum number of people allowed to attend the appointment. | |
| optOutOfCustomerEmail | Boolean | False |
A flag that indicates if opting out of customer email. | |
| postBuffer | String | False |
The post buffer. | |
| preBuffer | String | False |
The pre buffer. | |
| price | Float | False |
The price attached to the appointment. | |
| priceType | String | False |
The type of price. | |
| reminders | String | False |
The reminders that occur for this appointment. | |
| selfServiceAppointmentId | String | False |
The ID for self-service for this appointment. | |
| serviceId | String | False |
The identifier for the service that is attached to this appointment. | |
| serviceLocation_address_city | String | False |
The city portion of the address for the service. | |
| serviceLocation_address_countryOrRegion | String | False |
The county or region portion of the address for the service. | |
| serviceLocation_address_postalCode | String | False |
The zip code portion of the address for the service. | |
| serviceLocation_address_state | String | False |
The state portion of the address for the service. | |
| serviceLocation_address_street | String | False |
The street portion of the address for the service. | |
| serviceLocation_coordinates_accuracy | Float | False |
The accuracy of the coordinates attached to the service | |
| serviceLocation_coordinates_altitude | Float | False |
The altitude of the service location. | |
| serviceLocation_coordinates_altitudeAccuracy | Float | False |
The accuracy of the altitude of the service location. | |
| serviceLocation_coordinates_latitude | Float | False |
The latitude of the service location. | |
| serviceLocation_coordinates_longitude | Float | False |
The accuracy of the latitude of the service location. | |
| serviceLocation_displayName | String | False |
The name that will be displayed when viewing this location | |
| serviceLocation_locationEmailAddress | String | False |
The email address attached to the service location. | |
| serviceLocation_locationType | String | False |
The type of location. | |
| serviceLocation_locationUri | String | False |
The URI of the location. | |
| serviceLocation_uniqueId | String | False |
A unique identifier that refers to a specific location. | |
| serviceLocation_uniqueIdType | String | False |
The type of ID. | |
| serviceName | String | False |
The name that will be displayed when viewing this service. | |
| serviceNotes | String | False |
The notes attached to this service. | |
| smsNotificationsEnabled | Boolean | False |
A flag that indicates if notifications will be sent via SMS for this service. | |
| staffMemberIds | String | False |
The ID values representing the staff assigned to this service. | |
| startDateTime_dateTime | Datetime | False |
The datetime representing the start of the service without a timezone. | |
| startDateTime_timeZone | String | False |
The timezone of the start of the service. | |
| bookingbusinessid | String | False |
A foreign key representing the business that this appointment was booked for. | |
| Id [KEY] | String | False |
A unique identifier for this appointment. |