Creating JSON/REST API in D365 F&O

(0) Share

Report

Posted on by d365Dev

110

Hi,

I have a requirement where I need to create JSON/REST API which will be used by third party application.

We have third party application which is used by customers to process sales orders. Now they want to place sales order "on hold" in D365 F&O by calling from their application. I need to develop an interface to place sales order into on hold. Hence will be developing REST API which will be consumed by third party application and they will be sending sales order number as return data to API, which I will be using to process "On -hold" in D365 F&O.

Any body has worked on creating JSON/REST API from D365 F&O , please give some inputs on how to create REST API in D365 F&O.

I have never worked on creating JSON service from D365 F&O where as I have worked on consuming REST API.

Appreciate any help !

Thanks !

I have the same question (0)

All responses (9)

Answers (3)

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

Like (0)

Report

F&O already supports such things: look at OData services and custom services.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (1)

Report

You can develop custom service (https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/custom-services) that accepts SO id and put it on hold. Here is code example of a custom service

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/walkthrough-exposing-an-x-class-as-a-data-contract?redirectedfrom=MSDN

Was this reply helpful? Yes No
Verified answer

Rohin 4,624 on at

Like (1)

Report

Hey,

I had pretty similar requirement. I have used OData service for that . Just simply create a new Data Entity or use existing one with having Odata action method( static one with atribute SysODataActionAttribute) that accepts Salesorder Id as parameters and Do your stuff inside that action method( i.e. hold sales order in your case) . And then this OData action method is triggered by your 3rd party System.

Thanks

Was this reply helpful? Yes No
d365Dev 110 on at

Like (0)

Report

Hi Rohin,

Thanks for the reply. Was that bulk order update or single SO update ? I mean to ask if there are lot of SO's need to be updated on hold at once , whether is there any performance impact if we are using OData service.

Thank you !

Was this reply helpful? Yes No
d365Dev 110 on at

Like (0)

Report

Hi Ievgen,

Thanks for the quick reply. I went through these links but not able to find any code samples.. Do you have any example with code snippet on creating custom JSON service for D365 F&O ?

Thanks in advance !

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

The second of Ievgen's links shows how to create a custom service, including code samples.

In F&O, all custom services are automatically deployed to a JSON endpoint (and a SOAP endpoind, but that's not relevant for you). It's covered by Ievgen's first link (and my second link; they point to the same page). The page also contains a link to source code of a sample application showing how to call these services.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello d365Dev,

Just wanted to follow up on this one and ask if you have been able to get your issue resolved based on the information provided.

If this is the case then please be so kind and verify the answers.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
d365Dev 110 on at

Like (0)

Report

Rohin,

One small clarification needed, was that entity using "MCRHoldCodeTrans" as data source or "SalesTable"?, I have tried with "MCRHoldCodeTrans" as data source which is giving me an error saying "Sales order cannot be edited".

Was this reply helpful? Yes No
d365Dev 110 on at

Like (0)

Report

Thank you ! I am able to create custom JSON service and do my stuff.

Was this reply helpful? Yes No