Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

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

SCREENSHOTS

REFERENCES

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲