Power BI Connector for Gmail

Build 20.0.7654

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654