Microsoft Outlook Calendar

Retrieve all the events from your Microsoft Outlook Calendar or from any resources you have read access to. This capability is provided by the Calendar office365 plugin, which you need to install. Please see Installing plugins.

How to set up

  • From the Azure Portal, go to Entra ID > App registrations and select New registration.

  • Set a name and a redirect URI pointing back to your Dataiku instance. It should follow this structure: https://<<your Dataiku instance domain>>:<<your Dataiku instance port>>/dip/api/oauth2-callback Unless your Dataiku instance is on a localhost, the URI has to point to a https secured server.

  • Click on the newly created app. Copy the Application ID. Then go to the Certificates & secrets > New client secret tab. Set a description, choose an expiration date, and copy the value of the created secret.

  • Then navigate to the API permissions tab and add the following permissions: offline_access, Calendars.ReadWrite.

How to use

To use this capability, the user has to go to the Dataiku profile page > Credentials > Plugins, and click on the edit icon corresponding to the calendar-office365 preset. This will redirect the user to the Microsoft Authentication page where they can allow Dataiku to access the data from their Calendar account.

This capability has two components: a custom dataset and a recipe.

In a Dataiku flow, you can add a dataset by clicking on + ADD ITEM > Connect or create > Calendar office365. Then, select the authentication preset created and activated in the previous steps. Specify the ID of the calendar you want to consult. By default, it will be empty, which will retrieve the user’s personal calendar. You need to narrow your Calendar Events search by adding a start and end date (mandatory).

In some instances, you may want to retrieve the calendar of several resources, several time ranges, or a combination of both. To do so, create a dataset containing the combinations you want to retrieve, say a list of calendar ids of several resources.

Then use it as an input to the Calendar office365 recipe: in your Dataiku flow, click + ADD ITEM > Recipe > Calendar office365.

Use the list of calendar ID as input and create an output dataset. Pick a column name corresponding to each condition you want to search (any combination of calendar ids (optional), start dates and end dates (both mandatory)).

Next, run the recipe and the calendars corresponding to each line of the input dataset will be retrieved in the output dataset.