Microsoft Power Automate
Exposing Dataverse Tables using Odata
Prerequisite
1. Create an app in Azure for obtaining Client ID and Tenant ID
2. Register for client Secret code
3. Provide roles to Dataverse tables for accessing data
Authentication in Dataverse works with OAuth protocol , which requires a bearer key for accessing the data.
The initial call should be for obtaining the Bearer token , once the token is established actual calls be initiated using the token.
For testing , Postman is the excellent tool. The reference session below provides info on setting the environment and initiating the calls.
Postman Setup.
1. Create a new environment
2. Save the frequently used values as variables.
3. Get Access token
4. Using the access token carryout GET call
Reference :
https://my.gapinthevoid.com/2021/02/making-microsoft-dataverse-odata.html
https://www.youtube.com/watch?v=CTYrrUYrqYk