Notifications
Announcements
No record found.
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:
Can you try [base URL]/data/VendorsV3?
I get error: Stack trace: An empty SQL statement descriptor list has been encountered.
Has database sync been completed successfully?
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.
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 Magno. I don't know what this is, but I was able to get the Vendors by using cross-company=true. Are there any differences between Vendors, VendorsV2, and VendorsV3 feature-wise?
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 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?
learn.microsoft.com/.../dynamics_vendor
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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
