Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Get a new data entity ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Get a new data entity from 2 other data entity

(2) ShareShare
ReportReport
Posted on by D365FO Avatar 493
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
  • Waed Ayyad Profile Picture
    Waed Ayyad 7,608 Super User 2025 Season 1 on at
    Get a new data entity from 2 other data entity

    Hi, 

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

    Thanks,

    Waed Ayyad

  • D365FO Avatar Profile Picture
    D365FO Avatar 493 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 292,575 Super User 2025 Season 1 on at
    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 Profile Picture
    D365FO Avatar 493 on at
    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 Profile Picture
    Waed Ayyad 7,608 Super User 2025 Season 1 on at
    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

     
     
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans