Query Dataverse Tables With HTTP POST

Step-by-step live demo of how to create Azure App Registration and query Microsoft Dataverse tables over HTTP POST to the CRM Dynamics 365 endpoints. Key steps include:

1) Create Azure App Registration with Client Secret
2) Grant delegated Azure App API permission "Access Common Data Service as organization users"
3)
Grant same Azure App GUID permission in PowerApps Admin Center
4) Grant "Service Reader" for target PowerApps Environment
5) Execute login HTTP POST to gain "access_token"
6) Execute query HTTP POST to gain JSON Dataverse table rows

Cheers

[It_Is_Shubham]

This was super helpful. You are awesome

[ammadkhan]

Man you are amazing... I will definitely try this... it opens many opportunities. I am wondering to create CRUD function from my web app and lets see if its respnsive

[andreww]

Thanks for this video it was very helpful! A situation I ran into:
I inserted a record where there were 3 columns, 1 of them being a business required column... I tried inserting it with those two columns that weren't a business required column and it was successful but when I try to do the same in powerapps website, it does not let me save the row... Do you know how/if I can make it not insert if a business required col is not present in the payload?

[filoadynato]

3:30 I get a 404 when tryng to GET the bearer token. Has this method been deprecated?

[heenachhabra]

is there a way to duplicate/clone table using API