EndPoint Get My Message by Id [only works with User Credentials]

Name

get_my_message

Description

Get the mail message by message Id for the specified user ID or email address. [API reference]

Parameters

Parameter

Label

Required

Options

Description

MessageId

Message Id

YES

The Microsoft Mail message ID GUID for the message to read. (Example: 'c3220464-7209-453c-8840-3cf4de0afaa6')

EmailBodyFormat

Email Body Format

YES

Option	Value
html	html
text	text

SelectedColumns

Selected Columns

Select the individual columns to be included in the response, to reduce the response size and increase performance [API reference]

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
ReceivedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
HasAttachments	`DT_BOOL`	`bit`		`False`
Subject	`DT_WSTR`	`nvarchar(800)`	800	`False`
BodyPreview	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
SenderEmailAddressName	`DT_WSTR`	`nvarchar(800)`	800	`False`
SenderEmailAddress	`DT_WSTR`	`nvarchar(800)`	800	`False`
Importance	`DT_WSTR`	`nvarchar(500)`	500	`False`
SentDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
CreatedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
LastModifiedDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
ChangeKey	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
ToRecipients	`DT_WSTR`	`nvarchar(1190)`	1190	`False`
CcRecipients	`DT_WSTR`	`nvarchar(1190)`	1190	`False`
BccRecipients	`DT_WSTR`	`nvarchar(1190)`	1190	`False`
ToRecipient1	`DT_WSTR`	`nvarchar(200)`	200	`False`
ToRecipient2	`DT_WSTR`	`nvarchar(200)`	200	`False`
ToRecipient3	`DT_WSTR`	`nvarchar(200)`	200	`False`
ToRecipient4	`DT_WSTR`	`nvarchar(200)`	200	`False`
ToRecipient5	`DT_WSTR`	`nvarchar(200)`	200	`False`
CcRecipient1	`DT_WSTR`	`nvarchar(200)`	200	`False`
CcRecipient2	`DT_WSTR`	`nvarchar(200)`	200	`False`
CcRecipient3	`DT_WSTR`	`nvarchar(200)`	200	`False`
CcRecipient4	`DT_WSTR`	`nvarchar(200)`	200	`False`
CcRecipient5	`DT_WSTR`	`nvarchar(200)`	200	`False`
BccRecipient1	`DT_WSTR`	`nvarchar(200)`	200	`False`
BccRecipient2	`DT_WSTR`	`nvarchar(200)`	200	`False`
BccRecipient3	`DT_WSTR`	`nvarchar(200)`	200	`False`
BccRecipient4	`DT_WSTR`	`nvarchar(200)`	200	`False`
BccRecipient5	`DT_WSTR`	`nvarchar(200)`	200	`False`
Categories	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
ParentFolderId	`DT_WSTR`	`nvarchar(1200)`	1200	`False`
ConversationId	`DT_WSTR`	`nvarchar(1200)`	1200	`False`
ConversationIndex	`DT_WSTR`	`nvarchar(1200)`	1200	`False`
IsDeliveryReceiptRequested	`DT_BOOL`	`bit`		`False`
IsReadReceiptRequested	`DT_BOOL`	`bit`		`False`
IsRead	`DT_BOOL`	`bit`		`False`
IsDraft	`DT_BOOL`	`bit`		`False`
WebLink	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
InferenceClassification	`DT_WSTR`	`nvarchar(800)`	800	`False`
InternetMessageHeaders	`DT_NTEXT`	`nvarchar(MAX)`		`False`
BodyContentType	`DT_WSTR`	`nvarchar(500)`	500	`False`
BodyContent	`DT_NTEXT`	`nvarchar(MAX)`		`False`
FromEmailAddressName	`DT_WSTR`	`nvarchar(800)`	800	`False`
FromEmailAddress	`DT_WSTR`	`nvarchar(800)`	800	`False`
ReplyTo	`DT_WSTR`	`nvarchar(1190)`	1190	`False`
UniqueBodyContentType	`DT_WSTR`	`nvarchar(500)`	500	`False`
UniqueBodyContent	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
FlagFlagStatus	`DT_WSTR`	`nvarchar(800)`	800	`False`
ODataETag	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
InternetMessageId	`DT_WSTR`	`nvarchar(1800)`	1800	`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 My Message by Id [only works with User Credentials] using API Source

Outlook Mail (Office 365)

Get My Message by Id [only works with User Credentials]

SSIS API Source - Read from table or endpoint

Get My Message by Id [only works with User Credentials] using API Destination

Outlook Mail (Office 365)

Get My Message by Id [only works with User Credentials]