Skip to main content

Outlook 365

The Qlik Outlook 365 Connector enables you to access and fetch data from your Outlook 365 account and load it directly into your Qlik Sense app.

Tip:

The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.

Connecting to data sources

Supported offerings

  • Qlik Sense Desktop
  • Qlik Sense Enterprise on Windows
  • QlikView

This connector must be installed separately.

Ways to access your data

To access your Outlook 365 data, you need to authenticate the connector with your Outlook 365 account credentials. After you create a connection, select Outlook 365 as your data source, select the prompt/consent level, and select Authenticate. You are redirected to an Outlook 365 login page. Log in with your credentials to retrieve an authentication code, and enter it into the connector.

Loading data from tables

After you authenticate the connector with your account credentials, use the tables to fetch your data. Below are use cases for some of the available tables:

Tables that can be loaded
Table Description
MyProfile Fetches the currently authenticated user's Outlook 365 profile information.
MailFolders Fetches a list of folders in a user's mailbox.
Mail Fetches a list of messages from Outlook mail, with optional search and filter queries.
Attachments Fetches the properties and relationships of any attachments, attached to the specified event/message ID.
DownloadAttachment Fetches an attachment and downloads it to disk.
GetAttachmentAsBinary Fetches attachments as binary.
Calendar Fetches a list of events in a calendar. The list contains single instance meetings and series masters.
Contacts Fetches a list of contacts.
Users Fetches a list of users.

Reference - Outlook 365 developer documentation

You can refer to the Outlook 365 documentation to learn more about the requirements and restrictions imposed by the Web API.

Troubleshooting

You receive an error message that you have reached the API rate limit

Possible cause  

You have exceeded the API limits that are imposed by the Outlook 365 API.

Proposed action  

To reduce the impact of reaching the API rate limits, develop your app with the following in mind:

  • Extract only the data you need.
  • Reload one Outlook 365-based application at a time.
  • Ensure that loops in your script that make API calls will not result in infinite loops.