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

Name

download_message_attachments

Description

Downloads multiple attachments for a specified search condition / mailbox / folder

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Outlook Mail (Office 365) Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Outlook Mail (Office 365)

Read and write Microsoft Outlook Mail (Office 365) data effortlessly. Send, manage, and sync messages, attachments, and folders — almost no coding required.

Outlook Mail (Office 365)

Download Message Attachments (Multiple Files) - Using Search Condition

Required Parameters
User ID or Email	Fill-in the parameter...
SaveFolder	Fill-in the parameter...
Optional Parameters
MailFolderId
OverwriteFile	True

API Destination

API Destination - Outlook Mail (Office 365)

Read and write Microsoft Outlook Mail (Office 365) data effortlessly. Send, manage, and sync messages, attachments, and folders — almost no coding required.

Outlook Mail (Office 365)

Download Message Attachments (Multiple Files) - Using Search Condition

Required Parameters
User ID or Email	Fill-in the parameter...
SaveFolder	Fill-in the parameter...
Optional Parameters
MailFolderId
OverwriteFile	True

ODBC application

Use these SQL queries in your ODBC application data source:

Download multiple attachments with search condition

<p>Downloads Office 365 email attachments that match search criteria. You can combine conditions (e.g. has attachments only, sent after a date, subject contains text, from a specific sender). Supply <code>SaveFolder</code> and the search parameters in the <code>WITH</code> clause.</p>

SELECT * FROM download_message_attachments
WITH(
	  SaveFolder='c:\download',	
	  OverwriteFile='True',
 	  MailFolderId='INBOX', --or use mailbox ID
	  UserId='me', --or use "user-id" or use "email"
	  --search mail with attachments, sent after 2023-03-01, subject contains string "invoice" and  from email is microsoft-noreply@microsoft.com
	  SearchCriteria='hasAttachments eq true and sentDateTime gt 2023-03-01 and contains(subject, ''invoice'') and from/emailAddress/address eq ''microsoft-noreply@microsoft.com''  ',
	  EmailBodyFormat='HTML' --or text
)

--Check this link to learn more about search conditions: https://learn.microsoft.com/en-us/graph/filter-query-parameter?tabs=http

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Download multiple attachments with search condition

<p>Downloads Office 365 email attachments that match search criteria. You can combine conditions (e.g. has attachments only, sent after a date, subject contains text, from a specific sender). Supply <code>SaveFolder</code> and the search parameters in the <code>WITH</code> clause.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM download_message_attachments
WITH(
	  SaveFolder=''c:\download'',	
	  OverwriteFile=''True'',
 	  MailFolderId=''INBOX'', --or use mailbox ID
	  UserId=''me'', --or use "user-id" or use "email"
	  --search mail with attachments, sent after 2023-03-01, subject contains string "invoice" and  from email is microsoft-noreply@microsoft.com
	  SearchCriteria=''hasAttachments eq true and sentDateTime gt 2023-03-01 and contains(subject, ''''invoice'''') and from/emailAddress/address eq ''''microsoft-noreply@microsoft.com''''  '',
	  EmailBodyFormat=''HTML'' --or text
)

--Check this link to learn more about search conditions: https://learn.microsoft.com/en-us/graph/filter-query-parameter?tabs=http';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];