Is it Possible to Convert Json to XML in blob field in D365 Business central? How?

(0) Share

Report

Posted on by user 123

161

I am trying to integrate a third party application With Business central V21.4. I am able to send the request to application using API and also getting the response.

In response, this application provide data in JSON format. ( { Name : Content , Name 2 : Content ...}) I am storing that data in Blob field. I need to convert this data from JSON to XML file and need to separate that data by Comma separator and save that XML file with the particular name. ( Note: There can be N number of responses in that XML file)

I tried to search it on google, but no luck.

I have attached SS also. can you please suggest me some example or solutions? Screenshot-_2800_392_2900_.png_2D00_640x480.png_2D00_640x480.png

All responses (2)

Answers (0)

Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Is it Possible to Convert Json to XML in blob field in D365 Business central? How?

Hi,

You can visit the below link, see if it help you

andreilungu.com/.../
Suggested answer

Bilal Haider 45 on at

Like (0)

Report

RE: Is it Possible to Convert Json to XML in blob field in D365 Business central? How?

Hi,

The file looks like a payment file. You can try function from codeunit 1237. There are other helper functions available