This article is intended to get started with the Microsoft Outlook 365 connector in Qlik Application Automation.
Authentication and Authorization
To authenticate with Microsoft Outlook 365 you create a new connection. The connector makes use of OAuth2 for authentication and authorization purposes. You will be prompted with a popup screen to consent a list of permissions for Qlik Application Automation to use. The Oauth scopes that are requested are:
Sending Email with the Microsoft Outlook 365 connector
The scope of this connector has been limited to only sending emails. Currently, we do not enable sending email attachments and are looking to provide this functionality in the future. The suggested approach is to upload files to a different platform, e.g. Onedrive or Dropbox and create a sharing link that can be included in the email body.
The following parameters are available on the Send Email block:
To: A comma separated list of recipients;
CC: A comma separated list of recipients to which the email should be copied;
BCC: A comma separated list of recipients to which the email should be blind copied;
Subject: A title for your email;
Type: Choose between plain text email or HTML;
Body: The content of your email. You can use HTML for your email if chosen as the type.
Generating a report and sending an email with the report
As we do not currently support email attachments, we need to first generate a sharing link in Onedrive or an alternative file sharing service. The following automation shows how to generate a report from a Qlik Sense app, upload the report to Microsoft Onedrive, create a sharing link and send out an email with the sharing link in the body. This automation is also attached as JSON in the attachment to this post.