SSIS Components for Gmail

Build 20.0.7656

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 Id, MessageId, IncludeAttachmentData columns. The driver processes other filters client-side within the driver.

  • Id supports the '=' operator.
  • MessageId supports the '=' operator.
  • IncludeAttachmentData supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Attachments WHERE ID = 123
SELECT * FROM Attachments WHERE MessageId = 123
SELECT * FROM Attachments WHERE IncludeAttachmentData = true

Columns

Name Type References Description
Id [KEY] String The ID of the attachment.
MessageId 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

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

Name Type Description
IncludeAttachmentData Boolean A boolean controling whether to include the attachment data or not.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656