Microsoft Dataverse

Availability: Airbyte Cloud: ❌, Airbyte OSS: ✅
Support Level: Community
Latest Version: 0.1.2
Definition Id: 9220e3de-3b60-4bb2-a46f-046d59ea235a

Sync overview

This source can sync data for the Microsoft Dataverse API to work with Microsoft Dataverse.

This connector currently uses version v9.2 of the API

Output schema

This source will automatically discover the schema of the Entities of your Dataverse instance using the API https://<url>/api/data/v9.2/EntityDefinitions?$expand=Attributes

Data type mapping

Integration Type	Airbyte Type	Notes
String	string
UniqueIdentifier	string
DateTime	timestamp with timezone
Integer	integer
BigInt	integer
Money	number
Boolean	boolean
Double	number
Decimal	number
Status	integer
State	integer
Virtual	None	We skip virtual types

Other types are defined as string.

Features

Feature	Supported?(Yes/No)	Notes
Full Refresh Sync	Yes
Incremental Sync	Yes
CDC	Yes	Not all entities support it. Deleted data only have the ID
Replicate Incremental Deletes	Yes
SSL connection	Yes
Namespaces	No

Getting started

Requirements

• Application (client) ID
• Directory (tenant) ID
• Client secrets

Setup guide

The Microsoft Dataverse API uses OAuth2 for authentication. We need a 'client_credentials' type, that we usually get by using an App Registration. https://learn.microsoft.com/en-us/power-apps/developer/data-platform/authenticate-oauth

The procedure to generate the credentials and setup the necessary permissions is well described in this post from Magnetism blog: https://blog.magnetismsolutions.com/blog/paulnieuwelaar/2021/9/21/setting-up-an-application-user-in-dynamics-365

CHANGELOG

Version	Date	Pull Request	Subject
0.1.2	2023-08-24	29732	🐛 Source Microsoft Dataverse: Adjust source_default_cursor when modifiedon not exists
0.1.1	2023-03-16	22805	Fixed deduped cursor field value update
0.1.0	2022-11-14	18646	🎉 New Source: Microsoft Dataverse [python cdk]