Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / List all entities in D...
Finance forum
Answered

List all entities in Dynamics 365 for Finance and Operations

Posted on by 40

Hi,

We're using Power BI to report on data from our Dynamics 365 for Finance and Ops instance.  I've built a function in Power Query to convert the JSON reponse from the oData end point for a given entity to a table.  Now I'm trying to figure out a way to list all the available entities.

Is there a way to obtain a list of all the available data entities via the API?

Thanks!

Categories:
  • vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,326 on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    Hi AUaero,

    Please check all the replies and mark the answers as verified if those answers your question.

  • Deepak Agarwal Profile Picture
    Deepak Agarwal 132 on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    Hi, May I know whats the purpose of getting all the Data entity list. As suggested by Vinit, you can see all public data entity using Odata, try this link, docs.microsoft.com/.../odata

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,755 on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    You can review here - ajit-newdynamicsax.blogspot.com/.../how-to-list-down-data-entities-with.html

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    There are a couple of Data Management entities in F&O, which you can use to build a pbix.

    Alternatively, there are Excel entity and field lists in the technical reference documents;

    mbs.microsoft.com/.../axtechrefrep

    Finally, in addition to the entities that you're likely connecting to, there's also a Datamart behind F&O that contains a host of pre-built cubes and measures and drives a lot of the in-built reporting. You'll need a VM set up to access this though.

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,643 Moderator on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    You can get it using code as well. For example  by using metadata API . In below links see Martin's verified answer. You can use GetDataEntityViewNames method from API to get list of all data entities .

    community.dynamics.com/.../enumerate-label-prefix-for-label-search-functionality

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    Hi AUaero,

    If you go to Organization admininstration > Setup > Office integration > Excel workbook designer, you will get a list of all public entities with the functional name and the public name. The entity list from the Data Management workspace is only showing the entities which can be used with data management and might have some differences with the public entity list.

  • Verified answer
    vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,326 on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    Hi AUaero,

    To get a list of all OData entities from Dynamics 365 F&O use URL as : [Your organization's root URL]/data/

    example: mycomany.sandbox.operations.dynamics.com/data

    look at MS docs link docs.microsoft.com/.../odata for other features in D365FO.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: List all entities in Dynamics 365 for Finance and Operations

    Hi AUaero,

    You can find them in the D365FO data management workspace but for what reason do you need a list of all available entities?

    I assume that you won't need all of them, do you?

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans