EventAttachments
Displays all file attachments associated with calendar events. This view allows you to analyze or extract files linked to scheduled meetings or appointments.
テーブル固有の情報
Select
Event Id(必須)を指定してEventAttachments をクエリできます。
SELECT * FROM [EventAttachments] WHERE EventId = 'event id'
このクエリは、指定されたEvent の添付ファイルを、コンテンツを含めずにリストとして取得します。
Columns
| Name | Type | Description |
| eventId | String | Unique identifier of the event to which the attachment is linked. This serves as a foreign key that ties the attachment record to a specific event in the Exchange calendar. |
| id [KEY] | String | Unique identifier of the attachment object. This ID is used to retrieve or manage the attachment independently. |
| contentType | String | Specifies the media type (MIME type) of the attachment content, such as text/plain, image/jpeg, or application/pdf, allowing clients to correctly interpret the file format. |
| isInline | Bool | Indicates whether the attachment is intended to be displayed inline within the body of the event, such as embedded images or HTML content. |
| lastModifiedDateTime | Datetime | Timestamp reflecting the last time the attachment metadata or content was modified. Useful for synchronization and change tracking. |
| name | String | Name of the attachment, typically representing the original filename, which helps identify the content of the attachment. |
| size | Int | Size of the attachment in bytes. This can be used to manage file transfer limits or optimize storage and bandwidth usage. |
| userId | String | Identifier of the user who added or owns the attachment. This can be used for audit trails or access control. |