how to recognize if a record belongs to which entity?

(0) Share

Report

Posted on by Dishant Sharma

I have a collection of records from different entities. I want to find the field name which contains the unique identifier for the particular record belonging to any entity.

Is there an API that can accept something like record type and return which is the unique identifier for that entity type?

Basically, I have to perform some kind of action based on unique identifier field of the entity?

All responses (5)

Answers (1)

Suggested answer

Dishant Sharma 30 on at

Like (0)

Report

RE: how to recognize if a record belongs to which entity?

Thank you so much for the reply. It actually solved my issue.
Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report

RE: how to recognize if a record belongs to which entity?

Hi Dishant,

Each definition entity type uses MetadataId as the unique identifier property, which it inherits from the MetadataBase EntityType.

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/use-web-api-metadata

Because the MetadataId is the primary key for definition items, retrieving individual items follows the same pattern used to retrieve business data tables.

GET /api/data/v9.0/EntityDefinitions(<Entity MetadataId>)

Refer to the following link for more details:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/retrieve-metadata-name-metadataid#retrieve-definition-items-by-metadataid
Suggested answer

XM-22040801-0 11 on at

Like (1)

Report

RE: how to recognize if a record belongs to which entity?

Hi,

What language and king of application do you use?

To get the PrimaryIdAttribute from the entity name, you can use this WebAPI request:

/api/data/v9.1/EntityDefinitions(LogicalName='account')?$select=PrimaryIdAttribute

To learn more, see: learn.microsoft.com/.../query-metadata-web-api
Dishant Sharma 30 on at

Like (0)

Report

RE: how to recognize if a record belongs to which entity?

Thank you so much for the reply. Actually, this field is not available in all entities. I tried looking it up in the knowledge article entity, but couldn't find it. Is there any other way or particular field which is universal to all the tables for achieving the same thing?
Suggested answer

BillurSamdancioglu 17,153 Most Valuable Professional on at

Like (1)

Report

RE: how to recognize if a record belongs to which entity?

Hi,

You may use dataareaid.