Microsoft Outlook 365

Version:

2023.1

Last modified: September 20, 2023

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

Release Notes

Version	Description
v1.2.0	Compatible with Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later. Compatible with AMP engine only. Added support for DCM. DCM is required for running this connector on Alteryx Server. FIPS capable. Added new calendar intervals. Fixed issue where Outlook 365 Input failed to read emails with .msg attachments. (TPM-2151) Fixed issue where search didn’t work for certain query parameters. (TPM-523) Minor bugfixes and improvements.
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 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 custom Azure App (incl. single tenant app). Requires Outlook 365 account.. Proxy support.

Alteryx tools used to connect

Link

Outlook 365 Input Tool

If you drag and drop a message to an email, Outlook attaches it as EML Outlook Item. Outlook 365 doesn’t support the EML Outlook Item files and will skip them.

Data Connection Manager

Outlook Input supports Data Connection Manager for an easier and a safer storage of your credentials. Create a connection to Outlook and easily reuse the stored credentials in workflows that include Outlook Input. Alteryx Server requires stored credentials to successfully run the published workflows.

Enable AMP Engine

Make sure you have the AMP engine enabled for the workflows which contain Outlook Input to leverage the full potential of Designer capabilities.

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.

Navigate to Microsoft Azure.
Sign in with your Microsoft Azure Active Directory account.
On the Home screen use Search, or go to the upper left corner menu to open the Azure Active Directory service.
Open App registrations in the left menu.
Select + New registration.
Specify the Name of the app.
Choose desired account type – both Single tenant and Multitenant are allowed.
In the Redirect URI part:
1. For Outlook 365 version 1.0.0: Select Single-page application (SPA) from the dropdown menu and set the two 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/
Select Register.
The Application (client) ID is your Client ID.
The Directory (tenant) ID is your Tenant ID.
Go to API permissions to add these Delegated permissions - Microsoft Graph
1. openid
2. offline_access
3. profile
4. email
5. User.Read
6. User.ReadBasic.All
7. User.ReadWrite
8. Mail.Read
9. Mail.ReadWrite
10. Mail.ReadWrite.Shared
11. Calendars.ReadWrite
12. Calendars.ReadWrite.Shared