Draft
Query Draft Messages in Gmail.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The Id of the draft.Automatically assigned when the mail is created. | |
| MessageId | String | True |
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. | |
| CC | String | False |
The primary email address of the user. Writeable on create only. On update, a secondary email is added. | |
| BCC | String | False |
The primary email address of the user. Writeable on create only. On update, a secondary email is added. | |
| Content | String | False |
The content of the email. | |
| Date | Datetime | False |
The date when the email is sent. | |
| Size | Long | True |
The size in bytes of the email. | |
| Labels | String | True |
A comma separated value of labels that the email is part of. | |
| AttachmentIds | String | True |
A comma separated value of the ids of all attachments in the email. | |
| Snippet | String | True |
The snippet of the email. | |
| ThreadId | String | True |
The thread id of the email. | |
| HistoryId | String | True |
The history id of the email. | |
| Headers | String | True |
A list of headers of the email. | |
| RawMessage | String | True |
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 |
| AttachmentPath | String |
The path of the attachment. |
| IncludeSpamTrash | Boolean |
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) |
| 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. |