List all entities in Dynamics 365 for Finance and Operations

(0) Share

Report

Posted on by AUaero

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!

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,699 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Deepak Agarwal 8,585 on at

Like (0)

Report

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

Was this reply helpful? Yes No
vinitgoyal2005 6,332 on at

Like (0)

Report

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.

Was this reply helpful? Yes No