CData Excel Add-In for Office 365 2019 - Online Help
Questions / Feedback?


CData Excel Add-In for Office 365 2019 - Build 19.0.7354

Retrieve the ccurrences, exceptions, and single instances of events in a calendar view defined by a time range, from the user's default calendar, or from some other calendar of the user's.

Table Specific Information


Get the occurrences, exceptions, and single instances of events in a calendar view defined by a time range, from the user's default calendar, or from some other calendar of the user's. By default only the event occurrences from the user's default calendar in the range of the last 30 days will be returned. You can filter results by CalendarId, UserId, Start_DateTime, End_DateTime.

For example the following queries will be processed server side:

Select * FROM CalendarView Where Start_DateTime>='2019-12-10 15:00' AND End_DateTime<='2020-01-10 14:30'


SELECT * from CalendarView Where CalendarId='AQMkAGRlMWQ5MDg0LWI5ZTQtNDk2Yi1hOTQ1LTU4YzFmMzEwZjlhMgBGAAAD-FjxR3cIwE6TEGSCVtIHcwcAQyR2Iw3coEOaUD1BLt0tnAAAAwcAAABDJHYjDdygQ5pQPUEu3S2cAAACC_IAAAA=' And UserId='a98f25b5-5da1-4937-8729-c0d03026caa0' AND Start_DateTime>='2019-12-15 08:00' AND End_DateTime<='2020-01-14 08:00'


Name Type References Description
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
UserId String
CalendarId String

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