Loading

Please help me convert XML string to Json string

Please help me convert XML string to Json string

bonvoath

9y3.8kVisual Basic .NET

I'm try converting from xml string to json string as below:

I have xml string structure like this.

<items>
<item>
<id>1id>
<name>Name 1name>
item>
<item>
<id>2id>
<name>Name 2name>
item>
items>

When I try convert to json. I got result as array of item. It's good result.

{
"items": {
"item": [
{
"id": "1",
"name": "Name 1"
},
{
"id": "2",
"name": "Name 2"
}
]
}
}

But when my xml have only one item.

<items>
<item>
<id>1id>
<name>Name 1name>
item>
items>

I got result as object of item.

{
"items": {
"item": {
"id": "1",
"name": "Name 1"
}
}
}

But the exactly result I want to get like this.

{
"items": {
"item": [
{
"id": "1",
"name": "Name 1"
}
]
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Try like below(use JSON.NET library):
XmlSerializer mySerializer1 = new XmlSerializer(typeof(items2));
StreamReader myStreamReader1 = new StreamReader(@"C:\Users\mohapam\documents\visual studio 2015\Projects\ConsoleApplication1\ConsoleApplication1\XMLFile1 - Copy.xml");
items2 myResponseData1 = (items2)mySerializer1.Deserialize(myStreamReader1);


string json2 = JsonConvert.SerializeObject(myResponseData1);
XML Data:
xml version="1.0" encoding="utf-8" ?>
<items2>
  <item2>
    <id>1id>
    <name>Name1name>
  item2>
items2>
Model class:
[Serializable]
public class items2
{
    [XmlElement]
    public List item2 { get; set; }
}

[Serializable]
public class item2
{
    public int id { get; set; }
    public string name { get; set; }
}
Ranjeet Patra9y ago
Have a look at the below links:

http://stackoverflow.com/questions/36929478/xml-string-to-json-javascript

http://stackoverflow.com/questions/7769829/tool-javascript-to-convert-a-xml-string-to-json

https://davidwalsh.name/convert-xml-json

https://social.msdn.microsoft.com/Forums/en-US/824374d0-a1a2-4edf-a09f-b0c34eaae180/how-to-convert-string-xml-to-json-in-c?forum=xmlandnetfx