Excel Add-In for Gmail

Build 24.0.9060

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)

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060