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 | 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ShowDeleted | Boolean | Indicates whether to list cancelled events. |