Answered

Common Data Model definitions to Dataverse

(0) Share

Report

Posted on by itsopaz

I have Common Data Model schemas for my tables, is there a way of using those schema json files to create these tables.

Web API can be used to define tables, but the json schema used is EntityMetadata type and not CDM json schema. (Out of the box tables in dataverse (business unit, teams etc.) are based on the CDM).

Converting the files by hand is not really a option and creating these tables using the interface is too manual. Do i need to write some kind of JSON to JSON converter or is there some better options for this kind of process.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Jonathan Manrique 2,687 on at

Like (0)

Report

Hi @itsopaz

In principle, what you ask cannot be done, that is what the user interface that allows you to create the tables is for.
Then there are tools developed by third parties using the Microsoft SDK that can allow you certain functionalities.
One of them is the XRMToolBox and in it there is a plugin that allows you to duplicate the tables, that is, you have a table A and you need to create a B with the same fields, you can do it

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution
Follow me on Linkedin, I talk about Power Platform
www.linkedin.com/in/jonathan-manrique-rios

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

I’m a bit confused by what you mean by you have Common Data Model schemas for your tables. Do you mean you have a set of custom tables that are common for your organization? Or are you extending Microsoft’s CDM by adding fields to the existing tables?

If you are trying to automatically create new tables based on a schema you have, I would recommend creating a console app or WPF desktop app and use the SDK - it’s C# so it’s pro-code but you could target many environments this way.

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/org-service/create-custom-entity

Alternatively you can deploy your custom tables as solutions to your org? Perhaps using pipelines or ALM accelerator to deploy to every environment in your tenant?

Was this reply helpful? Yes No