OData Entities For Finance & Operations

(1) Share

Report

Posted on by CU29112247-0

Am trying to create an API to read data from D365 F&O by using OData Entities, right now am just on a "testing" stage since am barely new with Dynamics, am doing some GET calls from postman but am getting some issues when trying to get the Production Orders. I've confirmed that there are Production Orders in the system, but when I try to access the data using any of the following, i get empty results, I've confirmed I can access data since I've no problems getting the Products.

URL/data/ProductionOrderHeaders?cross-company=true
URL/data/ProductionOrderHeaders

Any Idea?

Categories:

Dynamics 365 general

I have the same question (0)

All responses (7)

Answers (0)

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

If in doubt, I usually check directly the view in database. If you can't do that, try it at least in the browser. Open the form with production orders to verify that there are any and then keep the first part of the URL and change the rest to /data/ProductionOrderHeaders?cross-company=true. This will make sure that you're looking into the right environment and there are no issues with Postman or so.

It's possible that you have data in ProdTable but the entity returns nothing - it returns just those with ProdType = Standard. Maybe that's your problem.

1 people found this reply helpful.

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

If you go to SQL and select the entity, does it return data? If it doesn't then this means you don't have data and postman is acting correctly

Was this reply helpful? Yes No
CU29112247-0 6 on at

Like (0)

Report

I don't have direct access to the SQL Database but the ERO administrator provided me access to Synapse, from there I've confirmed that the stgD365.ProdTable has the records am looking for.

Something that might help as a background the ERP Administrator has limited knowledge on dynamics, I am working for them trying to implement an APS system with D365, that's why my access and knowledge is limited.

I've tried using the url and ProductionOrderHeaders?cross-company=true but still no luck (it did worked with PurchaseOrdeHeaders btw). I dont get any records or information, any other suggestion?

One thing I did noticed is that in the OData Entities table inside of Finances & Operation there is another "Production Orders" entity but it's set to "IsShared = No". I've read that the only way to change this value is by connecting Visual Studio to the Dataverse and create a new Entity.

Does that ring a bell on you guys?

Thank you!

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

All right, you've confirmed that the entity doesn't return any data (by using ProductionOrderHeaders?cross-company=true in the right environment), there we can forget Postman and such things for now.

If the entity returns no data but the table have some (please look into the F&O environment, not a data lake, because they don't have to match), the reason may be in the filter on ProdType. You didn't react to my previous remark about it; maybe it's time to take a look...

Was this reply helpful? Yes No
CU29112247-0 6 on at

Like (0)

Report

Hey Martin, thanks again for your reply, sorry for my ignorance here but, how can i check the filter you mention?

Thanks!

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (0)

Report

You need to check a development environment, open the entity from visual studio and see if you find any ranges

Also in the devBox, if you go to SQL and select the entity then it returns nothing, then this will mean it's either there are ranges on the entity that is causing it to not return data or maybe there is a range on the entity that is causing this.

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Do you still need help? If not, then please verify the answers that helped.

Was this reply helpful? Yes No

Join the conversation

Community site session details

OData Entities For Finance & Operations

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

OData Entities For Finance & Operations

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates