Skip to main content

Microsoft Dataverse

Availability
Available CoreAvailable StandardAvailable PlusAvailable ProAvailable Enterprise FlexAvailable Self-Managed EnterpriseAvailable PyAirbyte
Support Level
Marketplace
Connector Version
0.1.32 (last updated 5 months ago)
CDK Version
0.80.0
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 TypeAirbyte TypeNotes
Stringstring
UniqueIdentifierstring
DateTimetimestamp with timezone
Integerinteger
BigIntinteger
Moneynumber
Booleanboolean
Doublenumber
Decimalnumber
Statusinteger
Stateinteger
VirtualNoneWe skip virtual types

Other types are defined as string.

Features​

FeatureSupported?(Yes/No)Notes
Full Refresh SyncYes
Incremental SyncYes
CDCYesNot all entities support it. Deleted data only have the ID
Replicate Incremental DeletesYes
SSL connectionYes
NamespacesNo

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

Reference​

Config fields reference

Field
Type
Property name
string
client_id
string
client_secret_value
string
tenant_id
string
url
integer
odata_maxpagesize

Changelog​

Expand to review
VersionDatePull RequestSubject
0.1.322025-05-1060052Update dependencies
0.1.312025-05-0359292Update dependencies
0.1.302025-04-2658830Update dependencies
0.1.292025-04-1957684Update dependencies
0.1.282025-04-0557100Update dependencies
0.1.272025-03-2956631Update dependencies
0.1.262025-03-2256043Update dependencies
0.1.252025-03-0855454Update dependencies
0.1.242025-03-0154768Update dependencies
0.1.232025-02-2254356Update dependencies
0.1.222025-02-1546493Update dependencies
0.1.212024-09-26 Make Dataverse available on Airbyte Cloud
0.1.202024-09-2145777Update dependencies
0.1.192024-09-1445482Update dependencies
0.1.182024-09-0745224Update dependencies
0.1.172024-08-3144987Update dependencies
0.1.162024-08-2444640Update dependencies
0.1.152024-08-1744224Update dependencies
0.1.142024-08-1043653Update dependencies
0.1.132024-08-0343164Update dependencies
0.1.122024-07-2742612Update dependencies
0.1.112024-07-2042373Update dependencies
0.1.102024-07-1341920Update dependencies
0.1.92024-07-1041346Update dependencies
0.1.82024-07-0941247Update dependencies
0.1.72024-07-0640800Update dependencies
0.1.62024-06-2540340Update dependencies
0.1.52024-06-2139931Update dependencies
0.1.42024-06-0639265[autopull] Upgrade base image to v1.2.2
0.1.32024-05-2038397[autopull] base image + poetry + up_to_date
0.1.22023-08-2429732🐛 Source Microsoft Dataverse: Adjust source_default_cursor when modifiedon not exists
0.1.12023-03-1622805Fixed deduped cursor field value update
0.1.02022-11-1418646🎉 New Source: Microsoft Dataverse [python cdk]
Was this page helpful?