Cmdlets for Gmail

Build 20.0.7654

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'

Insert

Create a simple message.

INSERT INTO [INBOX] (Subject, To, Content) VALUES ('Test Subject', 'test@gmail.com', 'Content')

Delete

You must specify the Id of the Message to delete it.

DELETE FROM INBOX WHERE Id = '123' 

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The identifier of the mail message.

Subject String False

The subject of the current message.

From String False

The sender email address of the current message.

To String False

The email address of the recipient.

CC String False

CCed recipient.

BCC String False

BCCed recipient.

Content String False

The content of the email.

Date Datetime False

The date and time the current message was sent.

Size Long False

The size in bytes of the current message.

Labels String False

The labels of the message, separated by spaces. Gmail treats labels as mailboxes.

AttachmentIds String False

A comma-separated list of the attachment ids.

AttachmentPath String False

A comma-separated list of the attachments content. Used in INSERT to set the local path of the file to attach.

Snippet String False

A snippet of the message.

ThreadId String False

The thread ID of the email.

HistoryId String False

The history id of the email.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IncludeSpamTrash String

Include messages from SPAM and TRASH in the results. (Default: false)

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