web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Data model of data entities in D365FO

(0) ShareShare
ReportReport
Posted on by 100

Hello,

How can I export data model of all data entities in D365FO belonging to specific ISV model in order to send it to third party app developers for mapping data with their entities?

Thanks

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,075 Super User 2025 Season 2 on at

    Hi andjelalj,

    What is the purpose of this? Some ISV's don't support all of their functionality with data entities. Wouldn't it be better to first check what tables are required in a certain integration and then check if there is a suitable data entity or not?

  • devgirlX Profile Picture
    100 on at

    Hi Andre,

    Our partners required to send them XML file of data entity structure in order to map entities with their entities.

  • huijij Profile Picture
    19,811 on at

    Hi andjelalj,

    The similar article in Finance Forum:

    How to import and export the xml file

    regards

  • devgirlX Profile Picture
    100 on at

    Hi huijij,

    I dont need to export data to XML file, I need a document of entity metadata, I need the structure of entities, what fields it has etc so they (from another company) can compare and map their data entities with ours.

  • Suggested answer
    Martin Dráb Profile Picture
    237,965 Most Valuable Professional on at

    You've attached "restapi" tag, which suggests that you're interested in consuming data entities via OData (which is a REST-ful service). And the OData service already offers metadata - just navigate to [your F&O environment URL]/data/$metadata.

    It even fulfils your requirement in getting metadata in XML.

    Note that this metadata is often used to generate service clients (e.g. through OData v4 Client Code Generator), allowing to consume the service in strongly-typed object-oriented manner.

  • devgirlX Profile Picture
    100 on at

    Hi Martin,

    I already did that, but is it possible to filter only data entities that belong to our model and how can I save this URL as a document?

  • Martin Dráb Profile Picture
    237,965 Most Valuable Professional on at

    Saving the content that the locator (URL) points to is easy: open it in a web browser (wait until it's fully loaded, which may take a while), then press Ctrl+S and choose where to save it.

    If you're use a prefix for your entities, you could extract just entities with this prefix from the file. Alternatively you could generate a list of your entities (e.g. by using the metadata API or simply looking into files in your model folder), iterate this list by a script and extract data from the file.

    But... are you sure that they won't use any standard entities? Maybe you should simply give then full metadata and then let them pick the entities they need, regardless if they were developed by Microsoft, ISVs or yourself.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 434 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans