Converting JSON to XML

Question

I trying to convert JSON output into XML. Unfortunately I get this error:

JSON root object has multiple properties. The root object must have a single property in order to create a valid XML document. Consider specifing a DeserializeRootElementName.

This is what I up to now created.

string url = string.Format("https://graph.facebook.com/{0}?fields=posts.fields(message)&access_token={1}", user_name, access_token);

HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;

using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
{
    StreamReader reader = new StreamReader(response.GetResponseStream());
    jsonOutput = reader.ReadToEnd();
    Console.WriteLine("THIS IS JSON OUTPUT: " + jsonOutput);
}
XmlDocument doc = (XmlDocument)JsonConvert.DeserializeXmlNode(jsonOutput);
Console.WriteLine(doc);

And this is my JSON output:

{"id":"108013515952807","posts":{"data":[{"id":"108013515952807_470186843068804","created_time":"2013-05-14T20:43:28+0000"},{"message":"TEKST","id":"108013515952807_470178529736302","created_time":"2013-05-14T20:22:07+0000"}

How can I solve this problem?

jwaliszko · Accepted Answer · 2013-07-09T21:20:53.120

38

Despite the fact your JSON provided in the question is not complete, you have multiple properties at the top level as indicated by the exception. You have to define the root for it to get valid XML:

var doc = JsonConvert.DeserializeXmlNode(jsonOutput, "root");

EDIT: In order to print out your XML with indentation you can use XDocument class from System.Xml.Linq namespace: XDocument.Parse(doc.InnerXml).

edited Jul 09 '13 at 21:20

answered May 15 '13 at 10:13

jwaliszko

16,942
22
92
158

Do you have an idea how to display XML? I get this System.Xml.XmlDocument :( – lukso May 15 '13 at 10:30
1

You can use `XDocument` class from `System.Xml.Linq` namespace to print out your XML with indentation: `XDocument.Parse(doc.InnerXml)`. – jwaliszko May 15 '13 at 11:19

score 4 · Answer 2 · answered Jul 01 '13 at 00:19

I thought it's worth linking to the Documentation for turning xml to json and the other way around.

The guys are right..

// To convert an XML node contained in string xml into a JSON string   
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
string jsonText = JsonConvert.SerializeXmlNode(doc);

// To convert JSON text contained in string json into an XML node
XmlDocument doc = (XmlDocument)JsonConvert.DeserializeXmlNode(json);

Termininja · Answer 3 · 2016-01-08T10:23:56.867

3

You can do JSON-to-XML also by using the .NET Framework (System.Runtime.Serialization.Json):

private static XDocument JsonToXml(string jsonString)
{
    using (var stream = new MemoryStream(Encoding.ASCII.GetBytes(jsonString)))
    {
        var quotas = new XmlDictionaryReaderQuotas();
        return XDocument.Load(JsonReaderWriterFactory.CreateJsonReader(stream, quotas));
    }
}

edited Jan 08 '16 at 10:23

answered Sep 05 '15 at 11:24

Termininja

6,620
12
48
49

1

Thanks ..:) . nice answer – Vishal Sen Dec 02 '15 at 08:24
My XML returns with a type. How do I remove the type example true – Kristina Lex Feb 18 '19 at 10:06
1

@KristinaLex check comments here https://stackoverflow.com/questions/814001/how-to-convert-json-to-xml-or-xml-to-json/32412316#32412316 – Termininja Feb 19 '19 at 08:02

score 1 · Answer 4 · answered Jun 21 '13 at 11:58

1

DeserializeXmlNode returns XDcument. If needed XNode use FirstNode.

//string jsonOutput="{"id":"108013515952807","posts":{"data":[{"id":"108013515952807_470186843068804","created_time":"2013-05-14T20:43:28+0000"},{"message":"TEKST","id":"108013515952807_470178529736302","created_time":"2013-05-14T20:22:07+0000"}";
var myelement= JsonConvert.DeserializeXmlNode(jsonOutput, "myelement").FirstNode;

answered Jun 21 '13 at 11:58

tetris

121
1
3

Wrong method. Use DeserializeXNode(...) for XDocument – Fried Sep 21 '17 at 12:35

score 0 · Answer 5 · answered May 15 '13 at 10:09

Your shared JSON is invalid please go through http://jsonformatter.curiousconcept.com/ and validate your JSON first.

Yourt JSON should look like:

{
   "id":"108013515952807",
   "posts":{
      "data":[
         {
            "id":"108013515952807_470186843068804",
            "created_time":"2013-05-14T20:43:28+0000"
         },
         {
            "message":"TEKST",
            "id":"108013515952807_470178529736302",
            "created_time":"2013-05-14T20:22:07+0000"
         }
      ]
   }
}

score 0 · Answer 6 · answered Aug 06 '19 at 14:51

0

Adding on @jwaliszko's answer, converting json to XDocument:

XDocument xml = JsonConvert.DeserializeXNode(json);

answered Aug 06 '19 at 14:51

OfirD

9,442
5
47
90

Converting JSON to XML

6 Answers6

Linked