JDBC Driver for Gmail

Build 21.0.8137


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

The labels of the message, separated by spaces. Gmail treats labels as mailboxes.

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.


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

Name Type Description
IncludeSpamTrash String

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

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137