Finance | Project Operations, Human Resources, ...

Get a new data entity from 2 other data entity

(2) Share

Report

Posted on by D365FO Avatar

670

Hi Folks,

I have a requirement to create a new data entity which will be used for Odata from 2 existing standard data entities and some more new fields.

I have few doubts regarding the approach. Could you please solve them.

For this I have created a Composite data entity from the existing data entities. Is it a good approach??

I need to add some new fields in the new composite data entity, how can I do this and Can I only import and export this data entity in XML format?

Thanks in advance!!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

You can't use CompositeDataEntity in OData, if you want to use it, then you can use it only Using DMF only.
If you want to use OData you should create new data entity. (Not composite)
Do the 2 standard data entities have relationships between there Datasource's? If yes then you can combine them in one data entity.

Can you add more details about the standards entities and the new fields that you want to add?

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
D365FO Avatar 670 on at

Like (1)

Report

Hi Waed Ayyad,

I need to use the following two data entities

However, both entities have numerous data sources, which makes it difficult to figure out how to best achieve this functionality.

Could you please advise on how to approach this and retrieve the necessary vendor details efficiently?

Thank you for your help!

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,206 Super User 2025 Season 2 on at

Like (1)

Report

Hi D365FO Avatar,

As mentioned by Waed, you would need to create a new Data entity where you can include all tables needed as data sources. You can also consider some virtual fields instead of adding all tables as data sources, but that would be a design decision having performance in consideration. If you need multiple fields from a single table. then a data source would be better.

You are also mixing OData with import and export (XML format). Can you clarify if you need only OData or also Data management?
In case you need an XML response from OData, you can read the blog from Martin Drab: XML response from OData services – Goshoom.NET Dev Blog

Was this reply helpful? Yes No
D365FO Avatar 670 on at

Like (1)

Report

Okay and can we use this virtual unmapped fields which has been created in data entity to Odata ??

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,
Is your issue resolved? If yes, mark the answers that helped you as verified.
Thanks,
Waed Ayyad

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get a new data entity from 2 other data entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Get a new data entity from 2 other data entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates