Converting JSON Array Entries to XML

Question

I wanted to convert the JSON data into XML contains the JSON array entries into the same. JSON data which I am converting is as below

{
   "userName":[
      "user1",
      "user2"
   ],
   "referenceNumber":"098784866589157763",
   "responseCode":"00",
   "responseDesc":"Success."
}

To convert the JSON to XML using below C# code

XmlDocument doc = JsonConvert.DeserializeXmlNode(jsonData, "response");

which is converting JSON to below XML

<response>
    <userName>user1</userName>
    <userName>user2</userName>
    <referenceNumber>098784866589157763</referenceNumber>
    <responseCode>00</responseCode>
    <responseDesc>Success.</responseDesc>
</response>

but expected output XML is as below

<response>
    <userName>
        <element>user1</element>
        <element>user2</element>
    </userName>
    <referenceNumber>098784866589157763</referenceNumber>
    <responseCode>00</responseCode>
    <responseDesc>Success.</responseDesc>
</response>

Is there any way to achieve the same?

You have to transform it manually. please avoid using the extremely dated System.Xml.XmlDocument family of APIs and use the modern System.Xml.Linq.XDocument apis that will save you many headaches as you implement your transformation. — Aluan Haddad
– Aluan Haddad, Commented Jun 15, 2020 at 6:22

MBB · Accepted Answer · 2020-06-16 04:09:06Z

1

If you can use the LINQ to XML, which is elegant way to manipulate XML documents, then below is one of the ways to achieve the requirement:

   XElement root = JsonConvert.DeserializeXNode(jsonData, "response").Root;

       // Create elements for userName in new XML
   var docFinal = new XDocument(new XElement("response" , new XElement("userName",            
                  from user in root.Descendants("userName") select new XElement("element", user.Value))));

        //Add remaining XML Attributs
   docFinal.Root.Add(root.Elements()
                   .Select(x => new XElement(x.Name, x.Value)).Where(x => x.Name != "userName"));

        //OUTPUT 
        //<response>
        //  <userName>
        //    <element>user1</element>
        //    <element>user2</element>
        //  </userName>
        //  <referenceNumber>098784866589157763</referenceNumber>
        //  <responseCode>00</responseCode>
        //  <responseDesc>Success.</responseDesc>
        //</response>

edited Jun 16, 2020 at 4:09

answered Jun 15, 2020 at 15:02

MBB

1,6954 gold badges11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dbc Over a year ago

Just use JsonConvert.DeserializeXNode(jsonData, "response").Root not XElement.Parse(JsonConvert.DeserializeXmlNode(jsonData, "response").InnerXml) -- you're deserializing to an XmlDocument then formatting and parsing again to an XDocument.

Collectives™ on Stack Overflow

Converting JSON Array Entries to XML

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related