Database Connectors
      Back to home
      1. Seek Connect Help Center
      2. Database Connectors

      Microsoft Dataverse Source Connector

      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​

      Other types are defined as string.

      Features​

      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