Reference

Table MyMessages

Description

No description available

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_my_messages
INSERT send_message
UPDATE
UPSERT
DELETE
LOOKUP get_my_message

Examples

SSIS

Use Gmail Connector in API Source component to read data or in API Destination component to read/write data:

Read from MyMessages table using API Source

API Source - Gmail
Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.
Gmail
MyMessages
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

Read/write to MyMessages table using API Destination

API Destination - Gmail
Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.
Gmail
MyMessages
Select
There are no parameters to configure.
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get MyMessages 

SELECT * FROM MyMessages

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get MyMessages 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages';

EXEC (@MyQuery) AT [LS_TO_GMAIL_IN_GATEWAY];