ODBC Driver for Exchange

Build 20.0.7587

EventInstances

EventInstances View for Exchange data provider.

Table Specific Information

Select

You can query EventInstances by specifying the Event Id, StartDatetime and EndDateTime. EventId is a required field, instead StartDatetime and EndDateTime have a default range of the last 30 days. If you query filtering only by EventId and the specific event does not exist within this time range, you will get empty results.

SELECT * FROM [EventInstances] WHERE id='event id' AND StartDateTime='2018/01/01' AND EndDateTime='2018/12/31'

SELECT * FROM [EventInstances] WHERE id='event id'

By default, if StartDateTime and EndDateTime filters are not specified, only the event instances from the user's default calendar in the range of the last 30 days will be returned. Otherwise, the query will get the instances of the Event during the period specified by StartDateTime and EndDateTime.

Columns

Name Type Description
eventId String
id [KEY] String
categories String
changeKey String
createdDateTime Datetime
lastModifiedDateTime Datetime
attendees String
body_contentType String
body_content String
bodyPreview String
end_dateTime String
end_timeZone String
hasAttachments Bool
iCalUId String
importance String
isAllDay Bool
isCancelled Bool
isOrganizer Bool
isReminderOn Bool
location_displayName String
location_locationEmailAddress String
location_address_street String
location_address_city String
location_address_state String
location_address_countryOrRegion String
location_address_postalCode String
location_coordinates_altitude Double
location_coordinates_latitude Double
location_coordinates_longitude Double
location_coordinates_accuracy Double
location_coordinates_altitudeAccuracy Double
location_locationUri String
location_locationType String
location_uniqueId String
location_uniqueIdType String
locations String
onlineMeetingUrl String
organizer_emailAddress_name String
organizer_emailAddress_address String
originalEndTimeZone String
originalStart Datetime
originalStartTimeZone String
recurrence_pattern_type String
recurrence_pattern_interval Int
recurrence_pattern_month Int
recurrence_pattern_dayOfMonth Int
recurrence_pattern_daysOfWeek String
recurrence_pattern_firstDayOfWeek String
recurrence_pattern_index String
recurrence_range_type String
recurrence_range_startDate Date
recurrence_range_endDate Date
recurrence_range_recurrenceTimeZone String
recurrence_range_numberOfOccurrences Int
reminderMinutesBeforeStart Int
responseRequested Bool
responseStatus_response String
responseStatus_time Datetime
sensitivity String
seriesMasterId String
showAs String
start_dateTime String
start_timeZone String
subject String
type String
webLink String

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587