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.
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.
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
Any help on How to create Dataverse table using WEB API.
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional