Outlook Calendar

This document provides instructions for setting up the Outlook Calendar authentication integration for NocoDB.

Environment Variables

To enable OAuth2 authentication with Outlook Calendar, you need to set up the following environment variables:

Step 1: Register a Microsoft Entra Application

1. Log in to the Microsoft Entra admin center (or the Azure portal)
2. Navigate to Identity > Applications > App registrations
3. Click "New registration"
4. Fill out the form:

• Name: Your application name (e.g., "NocoDB")
• Supported account types: Choose who can use the integration. Select "Accounts in any organizational directory and personal Microsoft accounts" to support both work/school and personal accounts
• Redirect URI: Select the "Web" platform and enter the URL where Microsoft will redirect users after authorization (e.g., https://your-nocodb-instance.com/)

5. Click "Register"
6. Navigate to API permissions and add the following Microsoft Graph delegated permissions: Calendars.Read, User.Read, and offline_access

Step 2: Get Client ID and Client Secret

After registering the application:

1. Copy the "Application (client) ID" from the Overview page
2. Navigate to Certificates & secrets, click "New client secret", and copy the secret's Value (it is shown only once)

Step 3: Set Environment Variables

Configure your NocoDB instance with the following environment variables:

INTEGRATION_AUTH_OUTLOOK_CALENDAR_CLIENT_ID=your_outlook_client_id
INTEGRATION_AUTH_OUTLOOK_CALENDAR_CLIENT_SECRET=your_outlook_client_secret
INTEGRATION_AUTH_OUTLOOK_CALENDAR_REDIRECT_URI=your_redirect_uri
INTEGRATION_AUTH_OUTLOOK_CALENDAR_TENANT_ID=your_tenant_id

Where:

• your_outlook_client_id: The Application (client) ID from your app registration
• your_outlook_client_secret: The client secret value from your app registration
• your_redirect_uri: The redirect URI you specified when registering the application (e.g., https://your-nocodb-instance.com/api/v1/integrations/auth/outlook-calendar/callback)
• your_tenant_id: (Optional) Your Microsoft Entra tenant ID. Defaults to common, which allows both personal and work/school Microsoft accounts. Set it to your tenant ID to restrict sign-in to your organization

OAuth Scopes

This integration requests the following Microsoft Graph scopes:

• Calendars.Read: Read-only access to calendars and events
• User.Read: Read the profile of the connected account
• offline_access: Refresh the access token between sync runs

Access is read-only; NocoDB never modifies your calendar.