How to create Dataverse table using WEB API

(0) Share

Report

Posted on by Community Power Pla...

How to create Dataverse table using WEB API.

I have Json data in my shared drive. Using this JSON data I want to create dataverse table in Powerapps using WEB API.

Please give me guidance and reference.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Any help on How to create Dataverse table using WEB API.

Was this reply helpful? Yes No
wwweber 146 on at

Like (0)

Report

There is a post regarding this from a few days ago with a good suggestion already. Basically the recommendation is looking at using dataflows

Create Dataverse table from API query - Power Platform Community (microsoft.com)

Direct link to documentation regarding dataflows
An overview of dataflows across Microsoft Power Platform and Dynamics 365 products - Power Query | Microsoft Learn

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (0)

Report
To create a new table within Dataverse, your web API endpoint will be:

POST [ENV_URL]/api/data/v9.2/EntityDefinitions

See https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/create-update-entity-def...for documentation on this.

To add or update rows within an existing Dataverse table, you could use Dataflow or if you want to use web API, your endpoint will be:

POST [ENV_URL]/api/data/v9.0/ENTITIY_SCHEMA_NAME

See https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/create-entity-web-api for documentation on this.

[ENV_URL] is of format:
https://NNNNNN.crmN.dynamics.com

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No