INBOX
Query SENT Messages in Gmail.
Table Specific Information
Query the available INBOX
Select
The driver uses the GMail REST API to process search criteria that refer to Id, Subject, From, To, Date, Labels, ThreadId, IncludeSpamTrash columns. The driver processes other filters client-side within the driver.
- Id supports the '=' operator.
- Subject supports the '=' operator.
- From supports the '=' operator.
- To supports the '=' operator.
- Date supports the '>,>=,<,<=,=' operators.
- Labels supports the '=' operator.
- ThreadId supports the '=' operator.
- IncludeSpamTrash supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM INBOX WHERE Id = '123' SELECT * FROM INBOX WHERE Subject = '123' SELECT * FROM INBOX WHERE [From] = 'test@gmail.com' SELECT * FROM INBOX WHERE [To] = 'test@gmail.com' SELECT * FROM INBOX WHERE [Date] >= '12/12/12 12:12:12' SELECT * FROM INBOX WHERE [Labels] = 'INBOX' SELECT * FROM INBOX WHERE [ThreadId] = '123' SELECT * FROM INBOX WHERE [IncludeSpamTrash] = 'true'
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 | The labels of the message, separated by spaces. Gmail treats labels as mailboxes. | |
| 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. |
Pseudo-Columns
Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| IncludeSpamTrash | String | Include messages from SPAM and TRASH in the results. (Default: false) |