Microsoft Outlook Connector

Integration with Microsoft Outlook using Microsoft's Graph API

Introduction

Microsoft Outlook API allows the users to send and retrieve Microsoft outlook emails with the right access set to their Microsoft accounts. The Goal of this connector is to integrate Tulip with Microsoft using Microsoft’s Graph API(v1.0) using HTTP Connectors & provide our customers with an out-of-box connector that can be imported into their instance.

Purpose

This documentation highlights different connector functions that can be built by doing HTTP calls to Microsoft’s Graph API(v1.0) to interact with the Microsoft Outlook to showcase various read and write actions on the outlook that could be leveraged for various use cases.

API Doc

Microsoft Graph API Documentation

Pre-Requisites

1. Create an account on Microsoft 365 & configure the OAuth 2.0 credentials in Microsoft Entra ID.

2. Register API with the required scopes in the Microsoft portal. Azure - Entra ID

Video of setting up the connector for excel:

You can follow the same steps to set up the outlook connector as well.

Tulip Connection Details

The following information would need to be configured on Tulip’s

Connectors.

1. Running On: Cloud Connector Host
2. Host: graph.microsoft.com
3. Port:443
4. TLS: Yes

OAuth 2(Admin/Operator): Authentication will be carried forward to all

the Connector Functions

Connector Functions

1) Get all Emails from Mailbox

Purpose

This connector will fetch all the emails from the mailbox.

Endpoint

HTTP GET call to the endpoint: https://graph.microsoft.com:443/v1.0/me/messages

Required Input

No Inputs required

Output Extractor

1. mailID: Unique identifier of the Email which will be used to carry out the other tasks.
2. mailCreatedDateTime: Email created date and time.
3. mailSubject: Subject of an Email.
4. mailBodyPreview: Content of an Email.
5. mailSenderAddress: Email address of the sender.
6. mailToRecipientAddress: Email address of the receiver.

2) Send an alert Email for Specific User

Purpose

This connector will send an email to a specific user/group user.

Endpoint

HTTP GET call to the endpoint: https://graph.microsoft.com:443/v1.0/me/sendMail

Required Input

The following are the request body parameters that are to be passed

1. mailSubject- Email subject.
2. mailContent- Email content.
3. emailAddress- Receiver Email address.

3) Send an alert Email for Multiple Users

Purpose

This connector will send an email to Multiple users.

Endpoint

HTTP GET call to the endpoint:  https://graph.microsoft.com:443/v1.0/me/sendMail

Required Input

The following are the URL parameters that are to be passed

1. mailSubject- Email subject.
2. mailContent- Email content.
3. emailAddress1- Receiver Email address.
4. emailAddress2- Receiver Email address.
5. emailAddress3- Receiver Email address.

Further Reading

Check out more information regarding Microsoft Connectors

• Microsoft Calendar Connector
• Microsoft Teams Connector
• Microsoft Excel Connector