Download multiple messages as .EML files with search filters
Searches for messages by condition and downloads each as an .EML file (RFC 822 / MIME). Supply User Id, MailFolder Id, optional search conditions, and SaveFolder. Each message is saved as its own file; files can be opened in most email clients and include attachments.
SELECT * FROM download_messages_by_search
WITH(
SaveFolder='c:\download', --save as *.eml files
OverwriteFile='True',
MailFolderId='INBOX', --or use mailbox folder Id (see get_mailfolders endpoint)
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'' ',
)
--Check this link to learn more about search conditions: https://learn.microsoft.com/en-us/graph/filter-query-parameter?tabs=http