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')

Insert

To add an attachment to an event, you must specify the CalendarId, EventId, and FileURL. Optionally, you can also specify a Title and MimeType.

INSERT INTO EventsAttachments (CalendarId, EventId, FileURL, Title) VALUES ('df5bf39459e666e1f6835a287923a083f83bfbe21113051b2759a9f2fa40a7c9@group.calendar.google.com', '4fbitolj1eb2ilbspcm2l5jcvc', 'https://drive.google.com/file/d/1abc123/view', 'Meeting Notes')

Delete

To remove an attachment from an event, you must specify the CalendarId, EventId, and FileURL.

DELETE FROM EventsAttachments WHERE CalendarId = 'df5bf39459e666e1f6835a287923a083f83bfbe21113051b2759a9f2fa40a7c9@group.calendar.google.com' AND EventId = '4fbitolj1eb2ilbspcm2l5jcvc' AND FileURL = 'https://drive.google.com/file/d/1abc123/view'

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 Google Drive.
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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ShowDeleted	Boolean	Indicates whether to list cancelled events.