EndPoint Download Message Attachments (Multiple Files) - Using Search Condition

Contents

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

Name

download_message_attachments

Description

Downloads multiple attachments for a specified search condition to select Mails

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')

SaveFolder

YES

Specify a disk folder path to save file(s) to

EmailBodyFormat

Email Body Format

YES

Option	Value
html	html
text	text

MailFolderId

OverwriteFile

Option	Value
True	True
False	False

SearchCriteria

Search Criteria

Option	Value
None
From specific email	'from/emailAddress/address eq 'microsoft-noreply@microsoft.com'
Has Attachments	hasAttachments eq true
Has Attachments, Sent After, and Subject containing 'party'	hasAttachments eq true and sentDateTime gt 2023-03-01 and contains(subject, 'party')
Received before	receivedDateTime lt 2023-02-01
Sent after	sentDateTime gt 2023-03-01
Sent after (dynamic)	sentDateTime gt <>
Search by Internet MessageId	contains(internetMessageId,''59e62584-e364-453a-8444-5591a324ddaa@az.centralus.production.microsoft.com'') Has attachment(s)=hasAttachments eq true
Subject contains 'case'	contains(subject, 'case')
Subject starts with 'Your'	startsWith(subject, 'Your')
Subject does not start with 'Your'	not(startsWith(subject, 'Your'))
Only normal importance	importance eq 'normal'
Only low importance	importance eq 'low'
Only high importance	importance eq 'high'
Only if delivery receipt requested	isDeliveryReceiptRequested eq true
Only if delivery receipt not requested	isDeliveryReceiptRequested eq false
Only if read receipt requested	isReadReceiptRequested eq true
Only if read receipt not requested	isReadReceiptRequested eq false
Only if message is read	isRead eq true
Only if message is unread	isRead eq false
Only if message is a draft	isDraft eq true
Only if message is not a draft	isDraft eq false
Body content contains	contains(body/content, 'money')
From Sender 'John Doe'	sender/emailAddress/name eq 'John Doe'

Data filter (e.g. somecolumn -eq 'somevalue'), you can use Date time functions for dynamic date. You can use keywords like now,today,yesterday,monthstart,monthend,yearstart,yearend,weekstart,weekend along with operator + / - [hour,minute,second,day,month,year] [API reference]

OrderBy

Order By

Option	Value
None
AscendingOrder	SomeColumn asc
DescendingOrder	SomeColumn desc

Order the specified column by ascending or descending order [API reference]

PageSize

Page Size

The number of records to include in each page of results [API reference]

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_STR`	`varchar(255)`	255	False
MessageId	`DT_STR`	`varchar(255)`	255	False
Name	`DT_WSTR`	`nvarchar(500)`	500	False
ContentId	`DT_STR`	`varchar(255)`	255	False
ContentType	`DT_STR`	`varchar(255)`	255	False
ContentLocation	`DT_STR`	`varchar(1000)`	1000	False
IsInLine	`DT_BOOL`	`bit`		False
LastModifiedDateTime	`DT_DBTIMESTAMP`	`datetime`		False
Size	`DT_I4`	`int`		False
SavedPath	`DT_WSTR`	`nvarchar(4000)`	4000	False
SavedSize	`DT_I8`	`bigint`		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.