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 must specify the CalendarId the WHERE clause.
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 must specify the CalendarId and the ParentEventId (the recurring event's Id) in the WHERE clause.
SELECT * FROM EventsAttachments WHERE CalendarId = 'df5bf39459e666e1f6835a287923a083f83bfbe21113051b2759a9f2fa40a7c9@group.calendar.google.com' AND ParentEventId = '4fbitolj1eb2ilbspcm2l5jcvc'
To query attachments metadata of all events in multiple calendars, you must specify their CalendarIds in the IN clause.
SELECT * FROM EventsAttachments WHERE CalendarId IN ('df5bf39459e666e1f6835a287923a083f83bfbe21113051b2759a9f2fa40a7c9@group.calendar.google.com', '8aab717ee7e6fca501e1e178e590f3ac4ac0c2660361fdff47b8c341eb379559@group.calendar.google.com')
Columns
| Name | Type | ReadOnly | Description |
| CalendarId | String | False |
The calendar identifier. |
| EventId [KEY] | String | False |
The event identifier. |
| ParentEventId | String | True |
The event instance identifier of a recurring event instance. |
| EventStatus | String | True |
The status of the event. |
| FileId | String | True |
The Google Drive file identifier of the attachment, if the attachment is located in a GoogleDrive. |
| FileURL [KEY] | String | False |
The URL link to the attachment. |
| Title | String | False |
The name of the attachment. |
| MimeType | String | False |
The internet media type (MIME type) of the attachment. |
| IconLink | String | True |
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 |
Indicates whether to list cancelled events. |