RecId field not present in standard entity

(0) Share

Report

Posted on by Iulian Cordobin

8,201

Hello,

I want to know, is there a reason why MS didn't include the RecId field in the standard entities (of course I did not look at all the entities, now I am working with the EcoResReleasedDistinctProductV2Entity)?

Just to be clear on what I want: a lot of APIs on the CSU require the product RecId, and I would get these recids from the dataverse dual-write enabled tables; but since I have no RecId in the FO entity in the first place and I do not want to extend the entity, I am wondering why this data was not included by default?

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Iulian Cordobin,

There is some RecId field available in standard entities. Refer to the entities like DirPartyBaseEntity where you will have RecId of LogisticsElectronicAddress table (PrimaryContactEmailRecordId). For some entities they didn't add that one, if you want you need to add that via extension.

Mostly data entities will be used in open in excel or some other integration purposes, so I guess instead of adding RecId values they have added the values that will be more in more readable format.

Thanks,

Girish S.

Was this reply helpful? Yes No
Verified answer

Israel Gonzalez 737 on at

Like (0)

Report
Copy link

Link copied!

Hi Lulian,

I recomend you create a new custom entity with the fields you want, that is the way if you need some fields like RecId, dataAreaId, etc.

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Record IDs aren't supposed to be exposed to external systems and people. RecId are considered an internal detail of F&O; natural keys (such as product numbers or customer IDs) should be used for communication with other systems.

This should explain why entites normally don't expose RecId and why it's considered a bad practice.

Your need to use them suggests that someone didn't respect the pattern.

What is CSU?

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report
Copy link

Link copied!

Hi all,

Thanks for your answers.

I do agree with the statement that integrations should use natural keys.

But, now the question comes: if the API exposed by the CSU breaks this pattern, is it ok? The endpoint Commerce/Products/GetEstimatedAvailability requires (only) the RecId of the Product.

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report
Copy link

Link copied!

Commerce Scale Unit.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you need it, you can add RecId to a standard entity (via an extension), or create a new entity for your purposes.

Was this reply helpful? Yes No
Israel Gonzalez 737 on at

Like (0)

Report
Copy link

Link copied!

As I said.

Was this reply helpful? Yes No