Advanced Analytica Advanced Analytica: IBOM
← All connectors
Outlook logo

Source connector

Outlook

Set up Outlook as a source and move its data into your chosen destination.

Version 0.0.39 community alpha

Outlook

Sync emails, mailboxes and conversations from Microsoft Outlook/Exchange Online through the Microsoft Graph API. The connector uses delegated permissions to support multiple tenants.

Prerequisites

You need:

  • A Microsoft Entra ID (formerly Azure AD) tenant
  • An account with at least the Cloud Application Administrator role
  • An Azure App Registration with the required API permissions

Setup

Step 1: Register an application

  1. Sign in to the Microsoft Entra admin center
  2. Go to Identity > Applications > App registrations
  3. Select New registration
  4. Enter a display name for your application, such as “Airbyte Outlook Connector”
  5. Under Supported account types, select the appropriate option:
    • Accounts in this organizational directory only: Single-tenant (your organization only)
    • Accounts in any organizational directory: Multi-tenant (any Microsoft Entra organization)
    • Accounts in any organizational directory and personal Microsoft accounts: Multi-tenant with personal accounts
  6. Leave Redirect URI blank for now. You’ll configure it in Step 3.
  7. Select Register

After registration, note the Application (client) ID shown on the Overview page.

Step 2: Configure API permissions

The connector requires these Microsoft Graph API permissions:

  1. In your app registration, go to API permissions
  2. Select Add a permission > Microsoft Graph > Delegated permissions
  3. Add these permissions:
    • Mail.Read: Lets the app read the signed-in user’s mailbox. You need this permission to access email messages and their attachments.
    • User.Read: Lets users sign in and lets the app read their profiles.
  4. Select Add permissions

Note: The Mail.Read delegated permission doesn’t require admin consent when accessing the signed-in user’s own mailbox. However, your tenant’s policies may require admin consent for every permission.

For more information about these permissions, see the Microsoft Graph permissions reference.

Step 3: Configure the redirect URI

  1. In your app registration, go to Authentication
  2. Under Platform configurations, select Add a platform
  3. Select Web
  4. Enter the redirect URI provided by Airbyte during OAuth configuration
  5. Select Configure

Microsoft sends the authentication response to the redirect URI after the user signs in. Airbyte provides this URI when you configure the connector.

Step 4: Create a client secret

  1. In your app registration, go to Certificates & secrets
  2. Under Client secrets, select New client secret
  3. Add a description, such as “Airbyte Outlook Connector Secret”
  4. Select an expiry period. Microsoft recommends less than 12 months.
  5. Select Add
  6. Important: Copy the secret value immediately. It won’t appear again after you leave this page.

Step 5: Get OAuth credentials

To get the refresh token required for Airbyte configuration:

  1. Use the OAuth 2.0 authorisation flow with your Client ID and Client Secret
  2. Request these scopes: https://graph.microsoft.com/Mail.Read https://graph.microsoft.com/User.Read offline_access
  3. After user consent, exchange the authorisation code for an access token and refresh token
  4. Save the refresh token for your Airbyte configuration

For detailed OAuth flow instructions, see Get access on behalf of a user.

Configuration

InputTypeDescriptionDefault Value
client_idstringOAuth Client ID. The Client ID of your Microsoft Azure application
tenant_idstringTenant ID (Optional). Azure AD Tenant ID (optional for multi-tenant apps, defaults to ‘common’)common
client_secretstringOAuth Client Secret. The Client Secret of your Microsoft Azure application
refresh_tokenstringRefresh Token. Refresh token obtained from Microsoft OAuth flow

Streams

Stream NamePrimary KeyPaginationSupports Full SyncSupports Incremental
profileNo pagination✅❌
mailboxesidDefaultPaginator✅❌
messagesidDefaultPaginator✅❌
messages_detailsidNo pagination✅❌
conversationsconversationIdDefaultPaginator✅❌

Stream details

messages: Retrieves every message from the signed-in user’s mailbox through the /me/messages endpoint. It includes Inbox, Sent Items, Deleted Items and other mail folders.

mailboxes: Retrieves information about mail folders in the user’s mailbox.

profile: Retrieves the signed-in user’s profile information.

conversations: Retrieves conversation threads from the user’s mailbox.

messages_details: Retrieves detailed information about individual messages.

Filters and limitations

You can’t currently filter emails by these criteria:

  • Specific mailbox or folder path
  • Email subject
  • Sender or recipient
  • Date ranges

The connector retrieves every message from the signed-in user’s mailbox through the /me/messages endpoint. Microsoft Graph API supports OData query parameter filtering, including $filter. However, the connector doesn’t currently provide these parameters as configuration options.

After extraction, you can filter messages in these ways:

  • Use Airbyte Mappings to filter rows by field values
  • Apply filters in your data warehouse or transformation tool after syncing
  • Use Microsoft Graph API directly with custom filtering parameters

For more information about Microsoft Graph Mail API capabilities, see the Microsoft Graph Mail API documentation.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
0.0.392026-11-1091668Update dependencies
0.0.382026-11-0390668Update dependencies
0.0.372026-10-2790017Update dependencies
0.0.362026-10-2089353Update dependencies
0.0.352026-10-1388740Update dependencies
0.0.342026-10-0687966Update dependencies
0.0.332026-09-2987290Update dependencies
0.0.322026-09-2286749Update dependencies
0.0.312026-09-1586159Update dependencies
0.0.302026-09-0885608Update dependencies
0.0.292026-08-1884714Update dependencies
0.0.282026-08-1184064Update dependencies
0.0.272026-08-0483570Update dependencies
0.0.262026-07-2883050Update dependencies
0.0.252026-07-2182529Update dependencies
0.0.242026-07-1481937Update dependencies
0.0.232026-06-3081193Update dependencies
0.0.222026-06-2380580Update dependencies
0.0.212026-06-1679998Update dependencies
0.0.202026-06-0979429Update dependencies
0.0.192026-06-0278902Update dependencies
0.0.182026-04-2877353Update dependencies
0.0.172026-04-2176688Update dependencies
0.0.162026-03-1774968Update dependencies
0.0.152026-03-0373816Update dependencies
0.0.142026-01-2072166Update dependencies
0.0.132026-01-1471676Update dependencies
0.0.122025-12-1870526Update dependencies
0.0.112025-11-2570123Update dependencies
0.0.102025-11-1869707Update dependencies
0.0.92025-10-2969010Update dependencies
0.0.82025-10-2168311Update dependencies
0.0.72025-10-1467772Update dependencies
0.0.62025-10-0767343Update dependencies
0.0.52025-09-3066389Update dependencies
0.0.42025-09-0965826Update dependencies
0.0.32025-08-2365161Update dependencies
0.0.22025-08-1564942Fix docker image entrypoint for platform syncs
0.0.12025-08-14Initial release by @saif-qureshi-341 via Connector Builder
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.