SENT
Query SENT Messages in Gmail.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The identifier of the mail message. | |
| Subject | String | False |
The subject of the current message. | |
| From | String | False |
The sender email address of the current message. | |
| To | String | False |
The email address of the recipient. | |
| CC | String | False |
CCed recipient. | |
| BCC | String | False |
BCCed recipient. | |
| Content | String | False |
The content of the email. | |
| Date | Datetime | False |
The date and time the current message was sent. | |
| Size | Long | False |
The size in bytes of the current message. | |
| Labels | String | False |
A comma separated list of labels that the email is part of. | |
| AttachmentIds | String | False |
A comma-separated list of the attachment ids. | |
| AttachmentPath | String | False |
A comma-separated list of the attachments content. Used in INSERT to set the local path of the file to attach. | |
| Snippet | String | False |
A snippet of the message. | |
| ThreadId | String | False |
The thread ID of the email. | |
| HistoryId | String | False |
The history id of the email. | |
| Headers | String | False |
A list of headers of the email. | |
| RawMessage | String | False |
The entire email message in an RFC 2822 formatted and base64url encoded string. Only returned when MessageFormat=raw. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| IncludeSpamTrash | String |
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) |
| LabelsFilter | String |
Set this to a comma-separated list of labels that the email should be part of. |
| 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. |