Messages
Query Messages in Gmail.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
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. | |
| Content | String | False |
The content of the email. | |
| Date | Datetime | False |
The date when the email is sent. | |
| Size | Long | False |
The size in bytes of the email. | |
| Labels | String | False |
A comma separated list of labels that the email is part of. | |
| AttachmentIds | String | False |
A comma separated value of the ids of all attachments in the email. | |
| AttachmentPath | String | False |
The path of the attachment. | |
| Snippet | String | False |
The snippet of the email. | |
| 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. |