Labels
Query Labels in Gmail.
Table Specific Information
Query the available Labels
Select
The driver uses the GMail REST API to process search criteria that refer to Id column. The driver processes other filters client-side within the driver.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Labels WHERE Id = 'abc'
Insert
Insert a simple Label.
INSERT INTO [Labels] (Name) VALUES ('LabelName')
Delete
Delete a label
DELETE FROM [Labels] WHERE Id = 'LabelId'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The immutable ID of the label. | |
| Name | String | False |
The display name of the label. | |
| MessageListVisibility | String | False |
The visibility of messages with this label in the message list in the Gmail web interface. Acceptable values: HIDE, SHOW. | |
| LabelListVisibility | String | False |
The visibility of the label in the label list in the Gmail web interface. Acceptable values: LabelHide, LabelShow, LabelShowIfUnread. | |
| Type | String | True |
The owner type for the label. | |
| MessagesTotal | Long | True |
The total number of messages with the label. | |
| ThreadsTotal | Long | True |
The total number of threads with the label. | |
| MessagesUnread | Long | True |
The number of unread messages with the label. | |
| ThreadsUnread | Long | True |
The number of unread threads with the label. |