Microsoft Lists

Availability:

Airbyte Cloud Airbyte OSS PyAirbyte

Support Level:

Marketplace

Connector Version:

0.0.4(Last updated 19 hours ago)

Microsoft Lists connector enables seamless data integration and synchronization between Microsoft Lists and other destination. The connector leverages Microsoft Graph API to retrieve list items efficiently, ensuring smooth workflows and real-time data accessibility

Authentication

1. Register a New Application(If you don't have already)

Go to the Azure Portal Navigate to Azure Active Directory > App registrations > New registration. Provide the following details: Name: Enter a name for your app (e.g., Airbyte Lists Connector). Supported account types: Choose the option that suits your needs (e.g., Single tenant or Multitenant). Redirect URI: Leave it blank for now or provide one if needed. Click Register.

2. Configure API Permissions

In the App Overview page, go to API Permissions > Add a permission. Select Microsoft Graph. Choose Application Permissions: Sites.Read.All, Sites.ReadWrite.All After adding the permissions, click Grant admin consent to allow these permissions.

3. Create Client Secret

In your registered app, go to Certificates & secrets > New client secret. Add a description and select an expiration period. Click Add and copy the client secret value (you won’t be able to see it again).

4. Obtain Client ID and Tenant ID

Go to the Overview tab in your registered app. Copy the Application (client) ID and Directory (tenant) ID – you’ll need these for authentication.

5. Set Redirect URI

Go to Authentication > Add a platform. Select Web and enter your redirect URI (e.g., http://localhost:3000). Enable Access tokens and ID tokens if using OAuth2 for authentication.

Configuration

Input	Type	Description	Default Value
site_id	string	Site Id.
client_id	string	Client ID.
client_secret	string	Client secret.
application_id_uri	string	Application Id URI.
tenant_id	string	Tenant Id.
domain	string	Domain.

Streams

Stream Name	Primary Key	Pagination	Supports Full Sync	Supports Incremental
lists	id	DefaultPaginator	✅	❌
listcontenttypes	id	DefaultPaginator	✅	❌
listitems		DefaultPaginator	✅	❌
items		DefaultPaginator	✅	❌
columnvalues	id	DefaultPaginator	✅	❌

Changelog

Expand to review

Version	Date	Pull Request	Subject
0.0.3	2024-10-29	47925	Update dependencies
0.0.2	2024-10-28	47544	Update dependencies
0.0.1	2024-10-18		Initial release by @bishalbera via Connector Builder