TDV Adapter for Gmail

Build 21.0.8137

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)

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137