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
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
| 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.
| 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 |
- Application (client) ID
- Directory (tenant) ID
- Client secrets
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
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 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] |