You’re offline. This is a read only version of the page.
Announcements
103
Hello, I'm having a very trivial problem and I don't know what I'm doing wrong.
I am integrating into a D365 F&O test environment using OData. I am able to authenticate using access token and in Azure Active Directory applications I have assigned the Admin user to the Azure client Id I'm using, so I should be able to have access to everything. I see that I have vendors when I look at Accounts Payable > All vendors, but when I do https://[base URL]/data/Vendors all I get empty JSON that looks like this:
Hi tl2022,
There are way more data entities in Dynamics 365 Finance and Operations compared to OData endpoints in Business Central. There is only some generic information for OData on F&O. Like Magno mentioned, a list with entities and fields is available in the application itself, but in many cases, the fields names are not clear without viewing exported data first.
As far as I know, there's not.
An easy way to list the OData points that you have available is to navigate through [base URL]/data. In the D365 you can also go to the Data Management data entities and see the target fields.
Hi Magno, I was looking at that section of the documentation as well, and was trying to find some documentation like the page below for Business Central, where they give me the details of all the fields for each entity. Do you know where I can find a similar resource for F&O?
It means that for some reason, this data entity has been updated by MS. It could be new fields, for example. And not to break processes that are using this data entity, a new version of the data entity is released.
I recommend always using the latest version available. Even if the versioning keeps old versions working, at some point they can be deprecated.
About the documentation, you can find it here: Integration between finance and operations apps and third-party services - Finance & Operations | Dynamics 365 | Microsoft Learn
Hi, I added 'cross-company=true' and after removing response size limitation on Postman was able to get back what looks to be all the vendors. Thanks!
In Azure Active Directory applications, I have the integration using an "Admin" user that has the "System administrator" role. Currently just trying to get things up and running, but later will definitely create a integrations user instead of using admin user to do this.
Is there any API documentation page available for F&O like they have for Business Central (learn.microsoft.com/.../). Or do I have to just query the metadata for the entities and figure it out myself?
Hi tl2022,
The "Vendors" entity name is correct. It is case-sensitive, but you used the starting capital correctly. What is the default startup company for your user? Odata is taking the default company, unless you add the next parameters in your url: ?cross-company=true
E.g. https://[base URL]/data/Vendors?cross-company=true
Do you have the system administrator role or another business role? If you don't have the system administrator role, you would need to have permissions on the data entity for the vendors to be able to access them using public services, like OData.
Has database sync been completed successfully?
Can you try [base URL]/data/VendorsV3?
#1
André Arnaud de Cal...
294,099
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
