EndPoint Get My Message by Id

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

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.