Microsoft Outlook 365

Connection Type Alteryx Tool. The latest version is available from from the Alteryx Community.
Type of Support Read

Release Notes

Version Description
v1.1.0
  • Authentication occurs using user's browser instead of embedded CEF in Designer to comply with modern security policies

  • Compatible with Alteryx Designer version:

    • 2021.4.2 Patch 4

    • 2022.1.1 Patch 2

    • 2022.2 and later

v1.0.0
  • Compatible with Alteryx Designer version 2021.4 and later.

  • Initial release.

  • Built-in multitenant Azure App with an option to use a custom Azure App (including single tenant app).

  • Requires Outlook 365 account.

  • Proxy support.

Alteryx Tools Used to Connect

Custom API Application Setup

For more information on how to build and manage an application using the Microsoft Azure cloud services, refer to the Azure documentation.

  1. Navigate to Microsoft Azure.
  2. Sign in with your Microsoft Azure Active Directory account.
  3. On the Home screen use Search, or go to the upper left corner menu to open the Azure Active Directory service.
  4. Open App registrations in the left menu.
  5. Select + New registration.
  6. Specify the Name of the app.
  7. Choose desired account type – both Single tenant and Multitenant are allowed.
  8. In the Redirect URI(optional) part:
    1. For Outlook 365 version 1.0.0: Select Single-page application (SPA) from the dropdown and set the 2 URLs:
      • https://cef.alteryx.com/designer/oauthcallback
      • https://login.live.com/oauth20_desktop.srf
    2. For Outlook 365 version 1.1.0 and later: Select Web-page application (WPA) from the dropdown menu and set the URL:

      • http://localhost/

  9. Select Register.
    The Application (client) ID is your Client ID.
    The Directory (tenant) ID is your Tenant ID.
  10. Go to API permissions to add these Delegated permissions - Microsoft Graph
    1. Calendars.ReadWrite
    2. Mail.ReadWrite.Shared
    3. User.Read
    4. User.ReadBasic.All
  11. To use service principal (app-only authentication) proceed to Certificates & secrets and add New client secret. Copy the Value as it won't be accessible again once you leave the page – this is your Client Secret.
    In API permissions add these Application permissions - Microsoft Graph
    1. Calendars.ReadWrite
    2. Mail.ReadWrite
    3. User.Read.All