SSIS Components for Gmail

Build 23.0.8839


Query SENT Messages in Gmail.


Name Type ReadOnly References Description
Id [KEY] String False

The identifier of the mail message.

Subject String False

The subject of the current message.

From String False

The sender email address of the current message.

To String False

The email address of the recipient.

CC String False

CCed recipient.

BCC String False

BCCed recipient.

Content String False

The content of the email.

Date Datetime False

The date and time the current message was sent.

Size Long False

The size in bytes of the current message.

Labels String False

A comma separated list of labels that the email is part of.

AttachmentIds String False

A comma-separated list of the attachment ids.

AttachmentPath String False

A comma-separated list of the attachments content. Used in INSERT to set the local path of the file to attach.

Snippet String False

A snippet of the message.

ThreadId String False

The thread ID of the email.

HistoryId String False

The history id of the email.

Headers String False

A list of headers of the email.

RawMessage String False

The entire email message in an RFC 2822 formatted and base64url encoded string. Only returned when MessageFormat=raw.


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

Name Type Description
IncludeSpamTrash String

Include messages from SPAM and TRASH in the results. (Default: false)

MessageFormat String

The format to return the message in: minimal, full, raw, or metadata. (Default: full)

LabelsFilter String

Set this to a comma-separated list of labels that the email should be part of.

SearchQuery String

Only return messages matching the specified query. Supports the same query format as the Gmail search box. This will take precedence over any other SQL criteria.

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