MailMessages

List Google mail messages.

Columns

Name	Type	Description
Id [KEY]	String	The ID of the current message. Note that the ID may not be constant from connection to connection. The ID is determined by google based on the number of messages in the mailbox, and when the message was first placed into the mailbox.
FromName	String	The sender name of the current message. If it is set in the WHERE clause of a SELECT query, a name-based SearchCriteria is generated.
FromEmail	String	The sender email address of the current message.
ToName	String	The To names of the message.
ToEmail	String	The To email addresses of the current message.
CCName	String	The CC names of the message.
CCEmail	String	The CC email addresses of the message.
Attachments	String	The attachment file names included in the message.
Date	Datetime	The date the current message was received.
Flags	String	The flags set on the current message.
Size	Int	The size, in bytes, of the current message.
Subject	String	The subject of the current message. If it is set in the WHERE clause of a SELECT query, a subject-based SearchCriteria is generated.
Labels	String	The Gmail labels associated with the current message.
ThreadId	String	The Gmail thread id associated with the current message. Several messages may have the same thread id.

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
Email	String	The user name for the Google Account credentials.
Password	String	The password for the Google Account credentials.
Mailbox	String	The mailbox to search in or list messages from. Defaults to Inbox. The default value is Inbox.
SearchCriteria	String	The search criteria to use for the search operation (ie, 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'. The value of this field is overwritten when Subject or FromName is specified.
MaxResults	String	The maximum number of messages to list. The default value is 100.
ShowLabels	String	Whether to return the Gmail labels. Setting to true may result in slower performance. The default value is FALSE.
ShowThreadId	String	Whether to return the Gmail thread id. Setting to true may result in slower performance. The default value is FALSE.