Endpoint Get a Specific Attachment included in a Specific Message for the Current User
Name
get_my_message_attachment
Description
Gets a specific attachment included on a specific message for the current user
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
|
If the column you are looking for is missing, consider customizing Gmail Connector.
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
API Source - Gmail
Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.
Gmail
Get a Specific Attachment included in a Specific Message for the Current User
| Required Parameters | |
|---|---|
| MessageId | Fill-in the parameter... |
| AttachmentId | Fill-in the parameter... |
API Destination
API Destination - Gmail
Read / search Gmail messages, download attachments, send mail and more using Gmail REST API.
Gmail
Get a Specific Attachment included in a Specific Message for the Current 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 a specific attachment included in a specific message for the current user
SELECT * FROM get_my_message_attachment
WITH
(
"MessageId" = 'abcd-1234-messageid',
"AttachmentId" = 'abcd-1234-attachmentid'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get a specific attachment included in a specific message for the current user
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_my_message_attachment
WITH
(
"MessageId" = ''abcd-1234-messageid'',
"AttachmentId" = ''abcd-1234-attachmentid''
)';
EXEC (@MyQuery) AT [LS_TO_GMAIL_IN_GATEWAY];