VIDEO – 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

VIDEO

CODE

• https://github.com/spjeff/Query-Dataverse-Tables-With-HTTP-POST

SCREENSHOTS

REFERENCES

• https://giangpham.io/blog/acquiring-an-oauth-access-token-from-dynamics-365-crm-online/
• https://community.dynamics.com/365/f/dynamics-365-general-forum/317299/dynamics-365-oauth-for-webapi