Create custom xml from json using C#

Hi vidyashree,

As you have not provided the expected output, so i am guessing you are looking output as below.

Code

string data = @"{
                'result': [
                    ['id', 'name'],
                    [1, 'A S Peta'],
                    [2, 'Aachara'],
                    [3, 'Aanjangaon'],
                    [4, 'Aanjar'],
                    [5, 'Aathankarai'],
                    [6, 'Abu'],
                    [7, 'Abu Road'],
                    [8, 'Achanta'],
                    [9, 'Addanki'],
                    [10, 'Addavaram'],
                    [11, 'Adipur'],
                    [12, 'Adirampattinam'],
                    [13, 'Adoni']
                    ]
                }";
data = data.Replace("['id', 'name'],", "").Remove(0, data.IndexOf("'result':") + "'result':".Length).Replace("}", "");
data = Regex.Replace(data, @"\[([0-9]+),", m => string.Format("{0}'id':'{1}'", "{", m.Groups[1].Value.ToString()));
data = Regex.Replace(data, @"\'([A-Z a-z 0-9]+)\'\]", m => string.Format(",'name':'{0}'{1}", m.Groups[1].Value, "}"));
data = data.Replace("'", "\"");
var xml = XDocument.Load(JsonReaderWriterFactory.CreateJsonReader(new MemoryStream(Encoding.ASCII.GetBytes(data)), new XmlDictionaryReaderQuotas()));

OutPut as XML

<root type="array">
  <item type="object">
    <id type="string">1</id>
    <name type="string">A S Peta</name>
  </item>
  <item type="object">
    <id type="string">2</id>
    <name type="string">Aachara</name>
  </item>
  <item type="object">
    <id type="string">3</id>
    <name type="string">Aanjangaon</name>
  </item>
  <item type="object">
    <id type="string">4</id>
    <name type="string">Aanjar</name>
  </item>
  <item type="object">
    <id type="string">5</id>
    <name type="string">Aathankarai</name>
  </item>
  <item type="object">
    <id type="string">6</id>
    <name type="string">Abu</name>
  </item>
  <item type="object">
    <id type="string">7</id>
    <name type="string">Abu Road</name>
  </item>
  <item type="object">
    <id type="string">8</id>
    <name type="string">Achanta</name>
  </item>
  <item type="object">
    <id type="string">9</id>
    <name type="string">Addanki</name>
  </item>
  <item type="object">
    <id type="string">10</id>
    <name type="string">Addavaram</name>
  </item>
  <item type="object">
    <id type="string">11</id>
    <name type="string">Adipur</name>
  </item>
  <item type="object">
    <id type="string">12</id>
    <name type="string">Adirampattinam</name>
  </item>
  <item type="object">
    <id type="string">13</id>
    <name type="string">Adoni</name>
  </item>
</root>