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