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?

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (1)

Report

Hi,

You may use dataareaid.

Was this reply helpful? Yes No
Dishant Sharma 30 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

XM-22040801-0 11 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Leah Ju Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dishant Sharma 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No