Visitor : 248

Read Comments

Microsoft Dataverse O Data queries

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

 




Add Comments