topic Re: Convert XML string to JSON format in Application Development and Automation Discussions

Convert XML string to JSON format

former_member371634 — Wed, 27 Jul 2016 10:15:09 GMT

Hi,

I have a requirement where I have to convert a string in XML format into corresponding JSON format.

The existing serializer does not recognise the tags and treats the entire string as one long text.

I tried using the XML parser( SMUM_XML_PARSE) which would return an internal table with the tags and corresponding values. JSON string generated from it treats the tags and values as value fields.

I would like to know whether my approach is right here or whether I should go about it differently. Also, I would appreciate some guidance on converting a string in XML format into corresponding JSON format.

Regards,

Renjith

Re: Convert XML string to JSON format

Sandra_Rossi — Wed, 27 Jul 2016 13:38:24 GMT

One XML may correspond to several possibilities in JSON. I guess there could be a minimalist conversion function module (or whatever), but I feel it would be no sense, so my conclusion is that you always need a home made algorithm to convert. Why not with SMUM_XML_PARSE if it suits your requirement.

EDIT:

For instance, who knows if <tab><line>1<line></tab> is to be converted into {"tab":{"line":1}} or into {"tab":[{"line":"1"}]}

So you must create a program (see Horst answer)

PS: maybe a tool could be developped, which receives both XML + XSD, then it would be able to convert correctly.

Re: Convert XML string to JSON format

retired_member — Wed, 27 Jul 2016 14:54:01 GMT

If you want to do it in ABAP, you might

either write an XSLT (TA STRANS) that converts your XML into JSON-XML and transform the result into a JSON-writer.
or parse your XML with methods of the sXML-library, convert it to JSON-XML and render it into a JSON-writer.

Re: Convert XML string to JSON format

retired_member — Thu, 04 Aug 2016 09:06:02 GMT

I've written an example, how one could do it in ABAP now, see