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