SSIS Components for Gmail

Build 23.0.8839


Query Messages in Gmail.


Name Type ReadOnly References Description
Id [KEY] String False

The Id of the message. Automatically assigned when the mail is created.

Subject String False

The subject of the email.

From String False

The address where the email is from.

To String False

The address where the email is sent to.

Content String False

The content of the email.

Date Datetime False

The date when the email is sent.

Size Long False

The size in bytes of the email.

Labels String False

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

AttachmentIds String False

A comma separated value of the ids of all attachments in the email.

AttachmentPath String False

The path of the attachment.

Snippet String False

The snippet of the email.

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