Attachments
Query Attachments in Gmail.
Table Specific Information
Query the available Attachments
Select
The driver uses the GMail REST API to process search criteria that refer to MessageId, IncludeAttachmentData columns. The driver processes other filters client-side within the driver.
- MessageId supports the '=' operator.
- IncludeAttachmentData supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Attachments WHERE MessageId = 123 SELECT * FROM Attachments WHERE IncludeAttachmentData = true
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The X-Attachment-Id of the message part header. | |
| MessageId [KEY] | String | The ID of the message containing the attachment. | |
| Filename | String | The name of the attachment file. | |
| Size | Long | The size in bytes of the attachment. | |
| Data | String | The conent of the attachment. |
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 | |
| IncludeAttachmentData | Boolean | A boolean controling whether to include the attachment data or not. (Default: true) |