Microsoft Dataverse
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 | Connect 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 | Coming Soon |
| 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