Filters
Query Filters in Gmail.
テーブル固有の情報
利用可能なFilters をクエリします。
Select
ドライバーはGmail REST API を使用して、Id カラムを参照する検索条件を処理します。ドライバーは他のフィルタを、ドライバー内のクライアントサイドで処理します。
- Id '=' 演算子をサポート。
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM Filters WHERE ID = 123
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The server assigned ID of the filter. | |
| AddLabelIds | String | List of labels to add to the message. | |
| RemoveLabelIds | String | List of labels to remove from the message. | |
| Forward | String | Email address that the message should be forwarded to. | |
| From | String | The sender's display name or email address. | |
| To | String | The recipient's display name or email address. Includes recipients in the | |
| Subject | String | Case-insensitive phrase found in the message's subject. | |
| Query | String | Only return messages matching the specified query. Supports the same query format as the Gmail search box. | |
| NegatedQuery | String | The primary email address of the user. Writeable on create only. On update, a secondary email is added. | |
| HasAttachment | Boolean | Whether the message has any attachment. | |
| ExcludedChats | Boolean | Whether the response should exclude chats. | |
| Size | Integer | The size of the entire RFC822 message in bytes, including all headers and attachments. | |
| SizeComparison | String | How the message size in bytes should be in relation to the size field. |