INBOX
Query SENT Messages in Gmail.
テーブル固有の情報
利用可能なINBOX をクエリします。
Select
ドライバーはGmail REST API を使用して、Id、Subject、From、To、Date、ThreadId、IncludeSpamTrash、MessageFormat、LabelsFilter、SearchQuery カラムを参照する検索条件を処理します。ドライバーは他のフィルタを、ドライバー内のクライアントサイドで処理します。
- Id '=' 演算子をサポート。
- Subject '=' 演算子をサポート。
- From '=' 演算子をサポート。
- To '=' 演算子をサポート。
- Date '>,>=,<,<=,=' 演算子をサポート。
- ThreadId '=' 演算子をサポート。
- IncludeSpamTrash '=' 演算子をサポート。
- MessageFormat '=' 演算子をサポート。
- LabelsFilter '=' 演算子をサポート。Set this to a comma-separated list of labels that the email should be part of (apart from INBOX).The emails that are returned can also be part of other labels not specified on the filter.
- SearchQuery supports the '=' 演算子をサポート。 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.
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM INBOX WHERE Id = '123' SELECT * FROM INBOX WHERE Subject = '123' SELECT * FROM INBOX WHERE [From] = '[email protected]' SELECT * FROM INBOX WHERE [To] = '[email protected]' SELECT * FROM INBOX WHERE [Date] >= '12/12/12 12:12:12' SELECT * FROM INBOX WHERE [ThreadId] = '123' SELECT * FROM INBOX WHERE [IncludeSpamTrash] = 'true' SELECT * FROM INBOX WHERE [MessageFormat] = 'raw' SELECT * FROM INBOX WHERE [LabelsFilter] = 'IMPORTANT, STARRED' SELECT * FROM INBOX WHERE [SearchQuery] = 'from:[email protected]'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The identifier of the mail message. | |
| Subject | String | The subject of the current message. | |
| From | String | The sender email address of the current message. | |
| To | String | The email address of the recipient. | |
| CC | String | CCed recipient. | |
| BCC | String | BCCed recipient. | |
| Content | String | The content of the email. | |
| Date | Datetime | The date and time the current message was sent. | |
| Size | Long | The size in bytes of the current message. | |
| Labels | String | A comma separated list of labels that the email is part of. | |
| AttachmentIds | String | A comma-separated list of the attachment ids. | |
| AttachmentPath | String | A comma-separated list of the attachments content. Used in INSERT to set the local path of the file to attach. | |
| Snippet | String | A snippet of the message. | |
| ThreadId | String | The thread ID of the email. | |
| HistoryId | String | The history id of the email. | |
| Headers | String | A list of headers of the email. | |
| RawMessage | String | 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. |