Finance | Project Operations, Human Resources, ...

ODATA Patch / Update a field value of the entity key

(0) Share

Report

Posted on by Sebastian Aurand

1,650

Hello,

I created a custom entity based on the table HcmPersonSkill. I'm trying to update the field "HcmPersonSkill.RatingLevelDate" via ODATA patch which is part of the primary key of the table as well as the entity key. Unfortunatly the update is not processed. I could not even see the new value from the JSON Body in the Debugger. Other fields like "HcmPersonSkill.Experience" are transferred and updated correctly and displayed in the variables in the debugger:

5226.pastedimage1665147924889v1.png

Do you have any idea why this value is not transferred?

Thanks

Sebastian

I have the same question (0)

All responses (5)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Does it work with the standard entity? If not, then we don't necessarily need to talk about your custom entity, because the problem can be demonstrated on the standard one. If it works there and not with your entity, the question is what you changed.

By the way, RatingLevelDate isn't a part of the primary key of HcmPersonSkill table. The primary key is SurrogateKey, i.e. RecId.

Was this reply helpful? Yes No
Sebastian Aurand 1,650 on at

Like (0)

Report

Thanks Martin for your response. The standard entity ("HcmPersonSkillEntity") shows the identical behaviour ("YearsOfExperience" is updated and "LevelDate NOT):

Whereas in the UI of D365 you could change the "LevelDate".

Was this reply helpful? Yes No
JV13 41 on at

Like (0)

Report

@Sebastian, Did you get any resolution to this, I am also facing the same issue. Is there a way to update that date value in your example (or a field which is part of entity key) using odata patch call?

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Try this way.

Try updating entity from ssms. If it works, then do a post request to update the data.

Was this reply helpful? Yes No
Suggested answer

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Hi Sebastian,

The Entity key for the standard entity HcmPersonSkillEntity is[PartyNumber, LevelType, HrmSkillLevelType and LevelDate]
url/data/PersonSkills(PartyNumber='xx',LevelType=Microsoft.Dynamics.DataEntities.HrmSkillLevelType'yy',SkillId='zz',LevelDate=2023-12-22T12:00:00Z)

Which means, that you can update any field except those 4 fields. If you want to change those fields, then you need to insert a new record.

if for example, you use DMF to import into this entity, you'll notice that if you pass existing values for the combination of those 4 fields, an update will occur. However, if you make the value of one of those fields different than an existing value, then an insert will occur.

So I think, if you want to update LevelDate, it needs to not be part of the entity key in ur custom entity. --try it and let us know please

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No