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

All responses (6)

Answers (0)

Layan Jwei 7,349 Super User 2024 Season 2 on at

Like (0)

Report

OData Entities For Finance & Operations

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
CU29112247-0 6 on at

Like (0)

Report

OData Entities For Finance & Operations

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

Thanks!
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

OData Entities For Finance & Operations

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...
CU29112247-0 6 on at

Like (0)

Report

OData Entities For Finance & Operations

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!
Layan Jwei 7,349 Super User 2024 Season 2 on at

Like (1)

Report

OData Entities For Finance & Operations

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
Martin Dráb 230,445 Most Valuable Professional on at

Like (1)

Report

OData Entities For Finance & Operations

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.