Skip to main content

Notifications

Retrieve API Data of an entity in Microsoft D365 Dataverse (Quick Guide)

Original Post: How to view API Data of an entity in Microsoft Dataverse (Quick Guide)

In our daily work with Power Apps and Power Automate, we often come across the following question:

How can we quickly retrieve API data from a Dataverse entity?

In this article, we will give you a step-by-step guide on how to quickly access this data.


In Power Apps, go to the desired table and select "Tools" -> "API link to table data" to view all data. To quickly retrieve a specific record, the following method is the fastest:

Click on API link to table data.

Click on API link to table data.

At first the whole table data is visible

At first the whole table data is visible

Simply modify the API link for the entire table to include filter=contactid eq ' ' and paste in the record ID. You can quickly get the record ID by opening the record in the application and copying it from the URL.

Look into the red box, there is the record ID (GUID) we need.

Look into the red box, there is the record ID (GUID) we need.


Example: https://xxxx.xxxx.dynamics.com/api/data/v9.2/contacts?$filter=contactid eq 'a8513a15-194b-ef11-accd-000d3a46e6b9'

That's it. Now you see the API data of an entity.

That's it. now you see the API data of an entity


I hope the instructions were able to help some of you.

Comments