Endpoint Get message attachment for user
Name
get_message_attachment
Description
Gets a specific attachment included on a specific message for the specified user
Related Tables
Parameters
| Parameter | Required | Options | ||||||
|---|---|---|---|---|---|---|---|---|
|
Name:
Label: MessageId |
YES | |||||||
|
Name:
Label: AttachmentId |
YES | |||||||
|
Name:
Label: ApiVersion The version of the API to use. |
||||||||
|
Name:
Label: UserId Enter the Gmail user ID. |
|
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Data |
DT_TEXT
|
varchar(MAX)
|
||
| Size |
DT_I4
|
int
|
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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:
| Required Parameters | |
|---|---|
| MessageId | Fill-in the parameter... |
| AttachmentId | Fill-in the parameter... |
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 message attachment for user:
| Required Parameters | |
|---|---|
| MessageId | Fill-in the parameter... |
| AttachmentId | Fill-in the parameter... |
ODBC application
Use these SQL queries in your ODBC application data source:
Get MessageAttachments
SELECT * FROM MessageAttachments
get_message_attachment endpoint belongs to
MessageAttachments
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 MessageAttachments
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MessageAttachments';
EXEC (@MyQuery) AT [LS_TO_GMAIL_IN_GATEWAY];
get_message_attachment endpoint belongs to
MessageAttachments
table(s), and can therefore be used via those table(s).