Reference

Endpoint Get a Specific Message for a Specific User

Name

get_message

Description

Gets a specific message for the specified user

Related Tables

MessageAttachments , Messages

Parameters

Parameter Required Options
Name: Id

Label: Id

 YES
Name: ApiVersion

Label: ApiVersion

The version of the API to use.
Name: UserId

Label: UserId

Enter the Gmail user ID.
Option Value
Enter Your User Id
Example User Id firstname.lastname@domain.com

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(500) 500
Subject DT_WSTR nvarchar(300) 300
BodySnippet DT_WSTR nvarchar(4000) 4000
To DT_WSTR nvarchar(200) 200
ToEmail DT_WSTR nvarchar(200) 200
Date DT_WSTR nvarchar(200) 200
From DT_WSTR nvarchar(200) 200
FromEmail DT_WSTR nvarchar(200) 200
PlainTextBody DT_NTEXT nvarchar(MAX)
HtmlBody DT_NTEXT nvarchar(MAX)
ContentType DT_WSTR nvarchar(200) 200
LabelIds DT_WSTR nvarchar(500) 500
ThreadId DT_WSTR nvarchar(500) 500
PayloadMimeType DT_WSTR nvarchar(200) 200
PayloadBodySize DT_I4 int
SizeEstimate DT_I4 int
HistoryId DT_WSTR nvarchar(500) 500
InternalDate DT_WSTR nvarchar(200) 200
MessageDate DT_DBTIMESTAMP datetime
GoogleSmtpSource DT_WSTR nvarchar(4000) 4000
ReturnPath DT_WSTR nvarchar(500) 500
ReceivedSPF DT_WSTR nvarchar(500) 500
Rfc822MessageID DT_WSTR nvarchar(200) 200
MIMEVersion DT_WSTR nvarchar(20) 20
Mailer DT_WSTR nvarchar(200) 200
ThreadIndex DT_WSTR nvarchar(500) 500
ContentLanguage DT_WSTR nvarchar(100) 100
If the column you are looking for is missing, consider customizing Gmail Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Message Id DT_WSTR nvarchar(300) 300
Required columns that you need to supply are bolded.

Examples

SSIS

Use Gmail Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the MessageAttachments table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Gmail
Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.
Gmail
MessageAttachments
Required Parameters
Id Fill-in the parameter...
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the MessageAttachments table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get a specific message for a specific user:

API Destination - Gmail
Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.
Gmail
MessageAttachments
Lookup
Required Parameters
Id Fill-in the parameter...
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get a specific message by id 

SELECT * FROM Messages Where Id='1910abb2f0a52aee'

get_message endpoint belongs to MessageAttachments , Messages table(s), and can therefore be used via those table(s).

SQL Server

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

Get a specific message by id 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Messages Where Id=''1910abb2f0a52aee''';

EXEC (@MyQuery) AT [LS_TO_GMAIL_IN_GATEWAY];

get_message endpoint belongs to MessageAttachments , Messages table(s), and can therefore be used via those table(s).