How to add field from 'Item' table to data entity

(0) Share

Report

Posted on by Sameerkulkarni20

Hi All ,

My current use case is to find the last modifed date of a product through the Odata apis of Dynamics 365 FnO

I see that the 'modifed date and time ' field is present in the Items table on the Dynamics 365 UI .

However this field is not present when I fetch the DistinctProduct entity from the Odata apis .

My question is :How can we add this field from the Items table to the DistinctProducts / ReleasedDistinctProducts Odata entity ?

I have tried the approach through the custom field but , for the existing field it is not getting added in the data entity

Step by step approach if any will be extremely helpful .

Thanks in advance ...

Sameer Kulkarni.

I have the same question (0)

All responses (7)

Answers (0)

Martin Dráb 236,124 Most Valuable Professional on at

Like (0)

Report

RE: How to add field from 'Item' table to data entity

Adding an extra field to an entity requires a customization. It can't be done by users through GUI.

Note that you can map an entity field to the table field without any code - but it still needs to be done by a developer and deployed in the same way as code changes.

Was this reply helpful? Yes No
Sameerkulkarni20 15 on at

Like (0)

Report

RE: How to add field from 'Item' table to data entity

Hi , we don't have access to deploy custom X++ code on our Dynamics 365 instance . Is there any way we can add the unmapped fields to entity from the Dynamics 365 UI?

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report

RE: How to add field from 'Item' table to data entity

Can you try adding a unmapped field in the entity(IsComputed set to No) and populate the value in PostLoad method? Usually postLoad works for exporting the data.

Was this reply helpful? Yes No
Sameerkulkarni20 15 on at

Like (0)

Report

RE: How to add field from 'Item' table to data entity

Yes , I have tried using the GET method , also in the metadata I am unable to get the attribute for the entity

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report

RE: How to add field from 'Item' table to data entity

Are you using GET to fetch the details of the entity?

Was this reply helpful? Yes No
Sameerkulkarni20 15 on at

Like (0)

Report

RE: How to add field from 'Item' table to data entity

Actually , In the Odata Entity , I am unable to view / fetch the attribute , 'Modified Date and time'

However i can see the same from the Released Products , view in Dynamics 365 .

How can i add the 'modified date ' field to the data entity?

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report

RE: How to add field from 'Item' table to data entity

HI Sameer,

In your OData API, can you include the condition to fetch the last modified date ?

I could not understand your requirement ? Can you explain it?

Was this reply helpful? Yes No

Community site session details

How to add field from 'Item' table to data entity

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to add field from 'Item' table to data entity

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates