web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

FO/Commerce/CRM connector in OData only

(0) ShareShare
ReportReport
Posted on by 38

Hello,

My company and I are new to the Dynamics products. We use Dynamics Finance and Operations (and the Commerce/Retail module) and the CRM. We need to develop a middleware application between the Dynamics products and our internal applications. This middleware will be a simple REST API, its tasks will be: the OData/HTTP calls, authentication and put some results in cache.

We would like to implement the middleware in Java (my company's official programming language) and use OData (read product data from FO, create sales quotation, get some prices in FO Commerce, modify customer values in the CRM...), but we're afraid some features/services/modules (now or in the future) are only accessible by some C# SDK.

Do you guys know some stuff (features, services, modules, APIs, etc) in the Dynamics world a client/application can not access through OData/HTTP ?

We did a few tests using a ASP.NET Web API and the OData connected service but we were a bit disappointing: it's hard to integrate this in a CI/CD environment (generate the C# code in the pipeline on different Dynamics environment/different $metadata files), documentation is hard to find and the generated code is kind of difficult to use (in comparison of what we expected. e.g. to pass "$top" query param or "oun" headers you have to use hooks on the DataServiceContext instance). Of course we would like to use our Java technologies but we're afraid that in X years our company installs another module only accessible from a C# SDK.

Please feel free to contact me if you have any questions. Thank you

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi JuniorD,

    Please post your issue to D365 Finance forum for further help:

    Dynamics 365 Finance - Forums, Blogs, Support

  • Suggested answer
    JuniorD Profile Picture
    38 on at
    Do you guys know some stuff (features, services, modules, APIs, etc) in the Dynamics world a client/application can not access through OData/HTTP ?
    After a few months using D365, I can say:
    - OData API calls are fine with CRM and Commerce (CSU), for F&O it's a bit more complex: some entities are very very slow (7 seconds to respond) and you have a limited quota for calls on F&O.
    - To extract data from F&O headquarter, use a BYOD (beware, it's deprecated) or a Data lake, do not use OData. Some entities are not exposed in OData and if you extract a lot of data (you can paginate the calls) you will be blocked by the quota.
    - I'm not using the C# SDK. I wrote my own using Java REST clients and it works fine.
     
    If you're in the same situation I was in, good luck to you.
     

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 176

#2
ManoVerse Profile Picture

ManoVerse 56 Super User 2026 Season 1

#3
Niki Patel Profile Picture

Niki Patel 42

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans