INBOX

Columns

Name

Type

References

Description

Id [KEY]

String

The identifier of the mail message.

Subject

String

The subject of the current message.

From

String

The sender email address of the current message.

To

String

The email address of the recipient.

CC

String

CCed recipient.

BCC

String

BCCed recipient.

Content

String

The content of the email.

Date

Datetime

The date and time the current message was sent.

Size

Long

The size in bytes of the current message.

Labels

String

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

AttachmentIds

String

A comma-separated list of the attachment ids.

AttachmentPath

String

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

Snippet

String

A snippet of the message.

ThreadId

String

The thread ID of the email.

HistoryId

String

The history id of the email.

Pseudo-Columns

Name

Type

Description

IncludeSpamTrash

String

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

Last updated