Power BI Connector for Gmail

Build 20.0.7654


Query Filters in Gmail.

Table Specific Information

Query the available Filters


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 Filters WHERE ID = 123


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.

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