{"id":874,"date":"2024-06-19T16:18:29","date_gmt":"2024-06-19T15:18:29","guid":{"rendered":"https:\/\/france.magicsoftware.com\/blog\/?p=874"},"modified":"2026-04-21T16:48:55","modified_gmt":"2026-04-21T15:48:55","slug":"office365-magic-xpi-read-mail-using-microsoft-graph","status":"publish","type":"post","link":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/office365-magic-xpi-read-mail-using-microsoft-graph\/","title":{"rendered":"Office365 – Magic xpi REST Connector – Read and Send Mail using Microsoft Graph"},"content":{"rendered":"\n

Describe the different steps for connecting Magic xpi with Office365 using REST Microsoft Graph API<\/p>\n\n\n\n

1\/ Define in Azure Portal An app registration and add permission for Office365 via Microsoft Graph<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Retrieve the ClientId, ClientSecret, TenantId in other to define this settings in the Magic xpi Resource Repository<\/p>\n\n\n\n

2\/ Open the Resource repository in Magic xpi Studio<\/p>\n\n\n\n

Define all the settings like below<\/p>\n\n\n\n

Set the scope with : offline_access IMAP.AccessAsUser.All<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

3\/ Click on the Paths Button and define 4 endpoints<\/p>\n\n\n\n

\/users\/{id}\/mailfolders\/inbox\/messages<\/p>\n\n\n\n

\/users\/{id}\/mailfolders\/inbox\/messages\/{messageid}\/attachments\/{attachid}\/$value<\/p>\n\n\n\n

\/users\/{id}\/mailfolders\/inbox\/messages\/{messageid}\/attachments<\/p>\n\n\n\n

\/{attachment_path}<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

4\/ Drag and Drop a REST Client connector and use \/users\/{id}\/mailfolders\/inbox\/messages<\/strong> endpoint<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Set the Id with the User uuid<\/p>\n\n\n\n

(*) You can make a GET<\/strong> on https:\/\/graph.microsoft.com\/v1.0\/users\/{Mailbox] to retrieve the UserUUID<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

5\/ Drag and Drop Datamapper connector to make a loop in other to download Mail attachments by calling a Subflow and passing the Id<\/p>\n\n\n\n

(*) In the example, we process only Mails that has attachment<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

6\/ In the called subflow, Make a GET on this URL : \/users\/{id}\/mailfolders\/inbox\/messages\/{messageid}\/attachments<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click OK and pass the MessageID and User UUID<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

7\/ Parse the JSON response and call another subflow to download Mail Attachment by passing the Name and AttachmentID<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

8\/ In the second subflow, make a get on this URL : \/{attachment_path}<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

set attachment_path : ‘\/users\/{User UUID}\/mailfolders\/inbox\/messages\/{MessageId}\/attachments\/{AttachId}\/$value<\/strong>‘<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Use the FileManagment to save the file content locally<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

9\/ To send Mail using REST Client connector<\/p>\n\n\n\n

Create a resource like below<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Scope should be : offline_access Mail.Send IMAP.AccessAsUser.All<\/strong><\/p>\n\n\n\n

The path must be in the format : \/users\/{id}\/sendMail<\/strong> : id<\/strong> can correspond to <\/p>\n\n\n\n

    \n
  • the userid, it can be retrieved directly from the admin console or by sending a GET on : https:\/\/graph.microsoft.com\/v1.0\/users<\/li>\n<\/ul>\n\n\n\n
      \n
    • the email From<\/li>\n<\/ul>\n\n\n\n

      The json body should be in the format like below<\/p>\n\n\n\n

      {\n  \"message\": {\n    \"subject\": \"Meet for lunch?\",\n    \"body\": {\n      \"contentType\": \"Text\",\n      \"content\": \"The new cafeteria is open.\"\n    },\n    \"toRecipients\": [\n      {\n        \"emailAddress\": {\n          \"address\": \"alem@magicsoftware.com\"\n        }\n      }\n    ],\n    \"ccRecipients\": [\n      {\n        \"emailAddress\": {\n          \"address\": \"alem@magicsoftware.com\"\n        }\n      }\n    ]\n  },\n  \"saveToSentItems\": \"false\"\n}<\/code><\/pre>\n\n\n\n
      Drag and Drop REST Client connector and configure it like below<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      10\/ After executing the flow, you should receive status 202<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      11\/ To send Mail using the Mail connector<\/p>\n\n\n\n
      You should define a Mail resource like below :<\/p>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      Drag and Drop the Mail connector and use the Quick Send method. The result should be the same.<\/p>\n\n\n\n
      \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
      Describe the different steps for connecting Magic xpi with Office365 using REST Microsoft Graph API 1\/ Define in Azure Portal An app registration and add permission for Office365 via Microsoft Graph Retrieve the ClientId, ClientSecret, TenantId in other to define this settings in the Magic xpi Resource Repository 2\/ Open the Resource repository in Magic […]<\/p>\n","protected":false},"author":1,"featured_media":913,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[4,28,32],"tags":[14,52],"class_list":["post-874","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magic-xpi","category-microsoft","category-office365","tag-magic-xpi","tag-office-365"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/06\/OFFICE365_MG13.png","_links":{"self":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/comments?post=874"}],"version-history":[{"count":37,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/874\/revisions"}],"predecessor-version":[{"id":3649,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/874\/revisions\/3649"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media\/913"}],"wp:attachment":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media?parent=874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/categories?post=874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/tags?post=874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}