Finance | Project Operations, Human Resources, ...

D365FO : Custom API's output in JSON format issue

(0) Share

Report

Posted on by Chintan AX

Hello Experts,

Product : D365 finance and operation.

We have created one custom API and for that output is in JSON format.

Question : Is there any possible way to make KEY value dynamic?

currently output is coming as below screen shot.

I want to make marked field dynamic. It is User ID. And desired output is as below screen shot.

Thanks in advance.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

No, I don't think that it's possible.

And it would not make much sense. The field names should stay, and field values should be dynamic, reflecting the data of that you are passing.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Chintan AX,

Service output is based on contract structure and you can't change it in run-time. So I would say that it's not possible to change the key name dynamically. But you can always utilize azure services to transform the output from D365 to the needed one.

Was this reply helpful? Yes No
Chintan AX on at

Like (0)

Report

Hi Sergei,

Thanks for reply. Can you give us a hint about that. How can we do that with utilizing azure services?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report
There could be many ways but you could for example write a simple Azure Function to replace part of the JSON string with your dynamic version. I'd say that you can use whatever tool you're most comfortable with. And most likely you can find examples by searching the web.

This:

"userid": "SARA", "userdetails":

Should be replaced by:

"":

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Chintan AX,

I would look into Azure management API as entry point and put Logic App\Azure Function between Azure API and F&O. Logic app\Azure function in the middle is responsible for request to D365 and transform response from D365.

community.dynamics.com/.../empowering-d365-fo-service-endpoints-with-azure-api-management-service

Was this reply helpful? Yes No