Events

Stores primary data for calendar events, including subject, location, attendees, and scheduling details. This table supports the management of both one-time and recurring appointments.

Table Specific Information

Select

You can retrieve all rows from Events, specify an event by Id or CalendarId, or filter results by any supported column.

Note: Unless you specify the AlwaysRequestTableDependencies connection property, or select/filter by the reference column CalendarId, the value for CalendarId will remain NULL.

Note: To retrieve all events for another user, you must authenticate with AuthScheme set to AzureServicePrincipal or AzureServicePrincipalCert.

-- Retrieve all events for a specific user and their calendars.
SELECT * 
FROM Events 
WHERE UserId = '0409f710-2aa9-4f05-8944-ef382160f1d1' 
  AND CalendarId IN (
    SELECT Id 
    FROM Calendars 
    WHERE UserId = '0409f710-2aa9-4f05-8944-ef382160f1d1'
  );

Insert

To create a new event, the Start and End values are required, including the time zone for each. For example:

-- Create a new event in the default calendar.
INSERT INTO Events 
  (Subject, Body_Content, Start_DateTime, Start_TimeZone, End_DateTime, End_TimeZone) 
VALUES 
  ('New Test Event', 'Event created using Office365Provider', 
   '2016-01-01T10:00:00', 'UTC', 
   '2016-01-01T11:00:00', 'UTC');

Note: This statement creates your event in the default calendar.

Columns


Name	Type	ReadOnly	Description
id [KEY]	String	False	Unique identifier of the event within the Exchange calendar system. This ID is used to retrieve, update, or delete the specific event.
categories	String	False	Comma-separated list of user-defined categories assigned to the event, such as ProjectX, CustomerMeeting, HighPriority.
changeKey	String	False	Version identifier that changes whenever the event is updated. It is used for concurrency control to detect changes.
createdDateTime	Datetime	False	Timestamp indicating when the event was originally created in the calendar.
lastModifiedDateTime	Datetime	False	Timestamp indicating the last time the event details were modified.
attendees	String	False	Comma-separated list of attendees' email addresses or user identifiers invited to the event. Includes both required and optional participants.
body_contentType	String	False	Specifies the format of the event body content, such as text or HTML.
body_content	String	False	Main body text of the event invitation or details, containing meeting information, agenda, or notes.
bodyPreview	String	False	Short preview of the event body, typically used in summary displays or list views. It is truncated to a fixed length.
end_dateTime	String	False	Date and time when the event is scheduled to end, formatted as an ISO 8601 string.
end_timeZone	String	False	Time zone context for the event end time, such as Pacific Standard Time or UTC.
hasAttachments	Bool	False	Indicates whether the event includes file attachments, such as agendas, slides, or documents.
iCalUId	String	False	Universal identifier for the event used across different calendar systems, derived from the iCalendar standard.
importance	String	False	Priority level of the event, such as low, normal, or high, used to signal its relative urgency or relevance.
isAllDay	Bool	False	Indicates whether the event is scheduled for an entire day without specific start or end times.
isCancelled	Bool	False	Indicates whether the event has been cancelled. Cancelled events remain in the system for tracking purposes.
isOrganizer	Bool	False	Specifies whether the current user is the organizer of the event. Useful in access control and response handling.
isReminderOn	Bool	False	Indicates whether a reminder notification is enabled for the event.
location_displayName	String	False	Human-readable name of the event location, such as a meeting room name, conference center, or virtual location.
location_locationEmailAddress	String	False	The email address associated with the event location, often used for rooms or resource calendars in Exchange.
location_address_street	String	False	The street address component of the event's location, which can be used for routing or location context.
location_address_city	String	False	The city where the event's location is situated, providing geographic context for attendees.
location_address_state	String	False	The state, province, or region of the event's location, offering further geographic detail.
location_address_countryOrRegion	String	False	The country or region where the event is held, used for internationalization or regional processing.
location_address_postalCode	String	False	The postal or ZIP code corresponding to the event location's address, useful for navigation and filtering.
location_coordinates_altitude	Double	False	The altitude value (in meters) above sea level for the event location, if available from the location metadata.
location_coordinates_latitude	Double	False	The latitude coordinate of the event's physical location, used in map plotting and geospatial analysis.
location_coordinates_longitude	Double	False	The longitude coordinate of the event's physical location, typically paired with latitude for mapping purposes.
location_coordinates_accuracy	Double	False	The horizontal accuracy (in meters) of the location coordinates, indicating the confidence radius of the location fix.
location_coordinates_altitudeAccuracy	Double	False	The accuracy (in meters) of the altitude reading, indicating the reliability of the vertical positioning.
location_locationUri	String	False	A URI that identifies the location resource, which can include a link to a map or a resource entry in the directory.
location_locationType	String	False	The classification of the location, such as default, conference room, home address, business address, or geo-coordinates.
location_uniqueId	String	False	A system-generated identifier that uniquely distinguishes this location from others within the same tenant.
location_uniqueIdType	String	False	Specifies the format or origin of the unique ID, such as unknown, locationStore, or directory, used to resolve the location identity.
locations	String	False	Comma-separated list of physical or virtual locations associated with the event, such as meeting rooms or online conferencing platforms.
onlineMeetingUrl	String	False	The full URL used to join the associated online meeting, typically generated by platforms like Microsoft Teams or Skype.
organizer_emailAddress_name	String	False	The display name of the individual or entity organizing the event, as listed in their email profile.
organizer_emailAddress_address	String	False	The email address of the event organizer, used for identifying the sender or main contact for the meeting.
originalEndTimeZone	String	False	Time zone in which the original end time of the event was defined, preserved for consistent scheduling across systems.
originalStart	Datetime	False	The original start date and time of the event before any changes or rescheduling occurred.
originalStartTimeZone	String	False	Time zone in which the original start time was defined, used to interpret the 'originalStart' value accurately.
recurrence_pattern_type	String	False	Specifies the recurrence pattern type for the event series. Values can include daily, weekly, absoluteMonthly, relativeMonthly, absoluteYearly, and relativeYearly.
recurrence_pattern_interval	Int	False	Defines the interval between recurrences of the event. For example, an interval of 2 with a weekly pattern indicates the event recurs every 2 weeks.
recurrence_pattern_month	Int	False	Specifies the month (1 to 12) in which the event recurs, used primarily for yearly recurrence patterns.
recurrence_pattern_dayOfMonth	Int	False	Indicates the specific day of the month on which the event occurs, applicable for monthly recurrence patterns.
recurrence_pattern_daysOfWeek	String	False	A list of comma-separated days when the event occurs for weekly or relative patterns, such as Monday, Wednesday, and Friday.
recurrence_pattern_firstDayOfWeek	String	False	Defines the first day of the week for recurrence calculations. Values typically include Sunday or Monday.
recurrence_pattern_index	String	False	Specifies the occurrence of the day within the month for relative recurrence patterns. Possible values include first, second, third, fourth, and last.
recurrence_range_type	String	False	Indicates how the recurrence range is defined. Possible values include endDate, noEnd, and numbered, which specify whether the pattern ends after a certain date, never ends, or ends after a set number of occurrences.
recurrence_range_startDate	Date	False	The start date of the recurrence pattern, indicating when the event series begins.
recurrence_range_endDate	Date	False	The end date of the recurrence pattern, indicating when the event series concludes or should stop repeating.
recurrence_range_recurrenceTimeZone	String	False	The time zone in which the recurrence range is defined, affecting how the start and end dates are interpreted.
recurrence_range_numberOfOccurrences	Int	False	The total number of times the recurring event should occur, used when the recurrence ends after a set number of instances.
reminderMinutesBeforeStart	Int	False	The number of minutes before the event's start time when a reminder notification should be triggered.
responseRequested	Bool	False	Indicates whether attendees are expected to respond to the event invitation.
responseStatus_response	String	False	The attendee's response to the event, such as accepted, declined, or tentative.
responseStatus_time	Datetime	False	The timestamp indicating when the attendee submitted their response to the event invitation.
sensitivity	String	False	Defines the visibility level of the event, such as normal, personal, private, or confidential.
seriesMasterId	String	False	The unique identifier of the recurring event series master, used to associate individual event instances with the parent series.
showAs	String	False	Specifies how the event should appear on the calendar, such as free, tentative, busy, or out of office.
start_dateTime	String	False	The date and time when the event is scheduled to begin, in ISO 8601 format.
start_timeZone	String	False	The time zone in which the event's start_dateTime is defined.
subject	String	False	The subject line or title of the event, typically used to summarize its purpose or topic.
transactionId	String	False	An optional identifier used to track changes or updates to the event across systems, ensuring idempotency.
type	String	False	Indicates the type of event, such as singleInstance, occurrence, exception, or seriesMaster.
webLink	String	False	A URL that opens the event in a web-based calendar client, typically Microsoft Outlook on the web.
calendarId	String	False	The identifier of the calendar to which this event belongs.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.