ODBC Driver for Google Calendar

Build 24.0.9060

EventsAttachments

Query the attachments metadata from the events in your Google calendar.

Table-Specific Information

Select

To query attachments metadata of all events in a certain calendar you will need to specify the CalendarId as a WHERE clause criterion.

SELECT * FROM EventsAttachments WHERE CalendarId = 'df5bf39459e666e1f6835a287923a083f83bfbe21113051b2759a9f2fa40a7c9@group.calendar.google.com'

To query attachments metadata for only a specific recurring event in a certain calendar you will need to specify the CalendarId and the ParentEventId (the recurring event's Id) as WHERE clause criteria.

SELECT * FROM EventsAttachments WHERE CalendarId = 'df5bf39459e666e1f6835a287923a083f83bfbe21113051b2759a9f2fa40a7c9@group.calendar.google.com' AND ParentEventId = '4fbitolj1eb2ilbspcm2l5jcvc'

To query attachments metadata of all events in multiple calendars you will need to specify their CalendarIds by using an IN clause criterion.

SELECT * FROM EventsAttachments WHERE CalendarId IN ('df5bf39459e666e1f6835a287923a083f83bfbe21113051b2759a9f2fa40a7c9@group.calendar.google.com', '8aab717ee7e6fca501e1e178e590f3ac4ac0c2660361fdff47b8c341eb379559@group.calendar.google.com')

Columns

Name Type Description
CalendarId String The calendar identifier.
EventId [KEY] String The event identifier.
ParentEventId String The event instance identifier of a recurring event instance.
EventStatus String The status of the event.
FileId String The Google Drive file identifier of the attachment, if the attachment is located in a GoogleDrive.
FileURL [KEY] String The URL link to the attachment.
Title String The name of the attachment.
MimeType String The internet media type (MIME type) of the attachment.
IconLink String The URL link to the attachment's icon.

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.

Name Type Description
ShowDeleted Boolean Whether to list cancelled events.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060