EndPoint Get Message Attachments
Name
get_message_attachments
Description
Get the list of attachments linked to the specified message Id. [API reference]
Parameters
| Parameter | Label | Required | Options | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| UserId | User ID or Email | YES | The Microsoft Mail user ID GUID or email address for the account to read messages from. (Examples: '4ff54a77-9c09-4274-958f-83bdc0a53900' or 'first.last@domain.com') | |||||||||||
| MessageId | Message ID | YES | The message Id for which to get attachments from. | |||||||||||
| OrderBy | Order By | NO |
|
Order the specified column by ascending or descending order [API reference] | ||||||||||
| SearchCriteria | Search Criteria | NO |
|
Data filter (e.g. somecolumn -eq 'somevalue') [API reference] | ||||||||||
| PageSize | Page Size | NO | The number of records to include in each page of results [API reference] |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(1000)
|
1000 | False |
|
| Name |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| ContentType |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| IsInline |
DT_BOOL
|
bit
|
False |
||
| LastModifiedDateTime |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| Size |
DT_I4
|
int
|
False |
||
| ContentId |
DT_WSTR
|
nvarchar(2000)
|
2000 | False |
|
| ContentBytes |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
| ODataType |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| ODataMediaContentType |
DT_WSTR
|
nvarchar(200)
|
200 | False |
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Outlook Mail (Office 365) Connector in API Source component to read data or in API Destination component to read/write data:
Get Message Attachments using API Source
Outlook Mail (Office 365)
Get Message Attachments
Get Message Attachments using API Destination
Outlook Mail (Office 365)
Get Message Attachments
ODBC application
Use these SQL queries in your ODBC application data source:
Get all attachments linked to the specified message ID
SELECT * FROM get_message_attachments
WITH (MessageId='AAXkADIwNzNhODMyLTZiMTQtNDhiMC02OWQzLTc5YTY5M2IyMjk0NABGAyAAAACbj2hVuNphT74wylrfU4ixBwAbUV6IxRnpQrqzrb2WfacdAAAAAAEMAAAbUV6IxRnpQrqzrb2WfacdAAAysBnxAAA=')SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get all attachments linked to the specified message ID
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_message_attachments
WITH (MessageId=''AAXkADIwNzNhODMyLTZiMTQtNDhiMC02OWQzLTc5YTY5M2IyMjk0NABGAyAAAACbj2hVuNphT74wylrfU4ixBwAbUV6IxRnpQrqzrb2WfacdAAAAAAEMAAAbUV6IxRnpQrqzrb2WfacdAAAysBnxAAA='')';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_OUTLOOK_MAIL_OFFICE_365_IN_DATA_GATEWAY];