Gravity
Search…
⌃K

MailMessages

Columns

Name
Type
ReadOnly
References
Description
Id [KEY]
String
True
The identifier of the mail message.
Mailbox
String
False
The current mailbox that the item is listed in. Updating this value will move the message to a new mailbox.
Subject
String
False
The subject of the current message.
FullFrom
String
True
The sender name and email address of the current message.
From
String
True
The sender email address of the current message.
FullTo
String
True
A semicolon-separated list of names and email addresses of the recipients.
To
String
False
A semicolon-separated list of the email addresses of the recipients.
FullCC
String
True
A semicolon-separated list of names and email addresses of the CCed recipients.
CC
String
False
A semicolon-separated list of the email addresses of the CCed recipients.
FullBCC
String
True
A semicolon-separated list of the names and email addresses of the BCCed recipients. This field is only applicable for sent mail.
BCC
String
False
A semicolon-separated list of the email addresses of the BCCed recipients. This field is only applicable for sent mail.
Date
Datetime
True
The date and time the current message was sent.
MessageBody
String
False
The message body. This field can only be set if you specify a single Id in SELECT.
Attachments
String
False
A semicolon-separated list of the attachment file names (with the path specified if reading from a file) included in the message.
AttachmentData
String
False
A semicolon-separated list of the base-64-encoded attachment data included in the message. The file name in the Attachments field must also be specified to use this field.
Size
Int
True
The size in bytes of the current message.
Flags
String
False
The flags set on the current message.
Labels
String
False
The labels of the message, separated by spaces. Gmail treats labels as mailboxes.
ThreadId
String
True
The Gmail thread Id associated with the current message. Several messages may have the same thread Id.
MsgId
String
True
The Gmail message Id associated with the current message. This is a globally unique Id assigned by Google separate from the IMAP Id/UID.
PartIds
String
True
The Id of the message part.
PartFilenames
String
True
The file name of the message part.
PartContentTypes
String
True
The content type of the message part.
PartSizes
String
True
The size of the message part.
Headers
String
True
The message headers for the specified mail message. This field is only available if you specify a single Id in SELECT or set IncludeMessage connection property to true.
AttachmentHeaders
String
True
The attachment headers for the specified mail message. This field is only available if you specify a single Id in SELECT or set IncludeMessage connection property to true.
ContentIds
String
True
The content id headers for the specified mail message. This field is only available if you specify a single Id in SELECT or set IncludeMessage connection property to true.

Pseudo-Columns

Name
Type
Description
SearchCriteria
String
The search criteria to use for the search operation (i.e., SENTSINCE dd-MMM-yyyy). The exact format of the search criteria is specified by the IMAP RFCs. The string consists of one or more search keys and their corresponding values, if any, separated by spaces. For example: 'SINCE 1-Feb-1994 NOT FROM Smith'.
ItemsPerPage
String
The maximum number of items to return per page.
The default value is 25.
IsHTML
String
This field sets whether the email has an HTML or plain-text encoding.
The default value is TRUE.
Importance
String
The importance of the mail message.
The allowed values are UNSPECIFIED, LOW, NORMAL, HIGH.
The default value is UNSPECIFIED.
Priority
String
The priority of the mail message.
The allowed values are UNSPECIFIED, NONURGENT, URGENT, NORMAL.
The default value is UNSPECIFIED.
Sensitivity
String
The sensitivity of the mail message.
The allowed values are UNSPECIFIED, PERSONAL, PRIVATE, COMPANYCONFIDENTIAL.
The default value is UNSPECIFIED.
DeliveryNotification
String
The email address to send a delivery notification to.
ReadReceipt
String
The email address to send a read receipt to.
ShowLabels
String
This field sets whether to show labels or not.
The default value is TRUE.
ShowThreadId
String
This field sets whether to show the thread Id or not.
The default value is TRUE.
ShowMsgId
String
This field sets whether to show the unique Gmail Id or not.
The default value is TRUE.
UIDMode
String
If this value is set to true, permanent message Ids are used instead of the default temporary Ids.
The default value is FALSE.
HasAttachments
String
If this value is set to true, only messages with attachments will be listed. If false, all messages will be listed.
DownloadAttachments
String
If true, attachments will be downloaded with the messages. Available only when specifying a single message Id or the Include Messages connection property is true. By default organizes attachments in subfolders with the message Id as name.
The default value is FALSE.
AttachmentFolder
String
The folder to download attachments to. If this is set, AttachmentData will not contain data, which will be written to files.
EMLFolder
String
The folder where the complete MIME message, which is saved as an EML file, is downloaded to. If multiple messages are selected, subfolders will be created for each message.
Overwrite
String
This field sets whether or not to overwrite attachments and EML files.
The default value is FALSE.
IncludeMessage
String
This field sets whether or not to include the message content in the response.
The default value is FALSE.