JDBC Driver for Gmail

Build 22.0.8462

Messages

Query Messages in Gmail.

Columns

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.

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
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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462