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 value 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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| IncludeSpamTrash | String |
Include messages from SPAM and TRASH in the results. (Default: false) |