Finance | Project Operations, Human Resources, ...

Get a new data entity from 2 other data entity

(1) Share

Report

Posted on by D365FO Avatar

359

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

All responses (5)

Answers (0)

Waed Ayyad 6,623 Super User 2024 Season 2 on at

Like (0)

Report

Get a new data entity from 2 other data entity

Hi

It seems you got the answer about virtual unmapped field on the following thread: Solved: Are unmapped Virtual fields are accessible to Odata

Regarding this question, can you verify the answers that helped you in this thread.

Thanks,
Waed Ayyad
D365FO Avatar 359 on at

Like (1)

Report

Get a new data entity from 2 other data entity

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

André Arnaud de Cal... 291,559 Super User 2024 Season 2 on at

Like (1)

Report

Get a new data entity from 2 other data entity

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
D365FO Avatar 359 on at

Like (1)

Report

Get a new data entity from 2 other data entity

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!
Suggested answer

Waed Ayyad 6,623 Super User 2024 Season 2 on at

Like (1)

Report

Get a new data entity from 2 other data entity

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

Get a new data entity from 2 other data entity

Helpful resources

Quick Links

Congratulations 2024 Spotlight Stars!

Meet the Top 10 leaders for December!

Get Started Blogging in the Community

Leaderboard

Featured topics

Product updates

Get a new data entity from 2 other data entity

Helpful resources

Quick Links

Congratulations 2024 Spotlight Stars!

Meet the Top 10 leaders for December!

Get Started Blogging in the Community

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates