Converting JSON Array to XML in C#

Question

All, I know this question has been asked multiple times, and I feel like I have looked at every single one of them on here! I have a C# Winforms application that is making a call to an outside webhook, pulling in JSON formatted data. I need to take this data and convert it to a data table, with the end result imported into a database. The thing I am stuck on, and have been for the last day and a half, is trying to parse the JSON data into XML.

Here is the JSON data (example) I am getting from the webhook:

 [
  ["Item Title",
   "Bidder Name",
   "Bidder Email",
   "Bidder Phone Number",
   "Bidder Username",
   "Bid Amount",
   "Bid Time",
   "Operation",
   "Auto Bid Amount",
   "Bidder Address",
   "Bidder City",
   "Bidder State",
   "Bidder Country"
  ],
  ["Test item 1(#)"],
  ["",
   "Tom Kelly",
   "[email protected]",
   "6303278300",
   "testaccount",
   "50.0",
   "07/09/2016 07:17 PM CDT",
   "Bid Amount",
   null,
   null,
   null,
   null,
  "US"
  ]
]

At first I tried using the DeserializeXMLNode function, but that didn't work.

XmlNode xml = JsonConvert.DeserializeXmlNode(body, "BiddingHistory");

Then I thought that I would use the DeserializeObject function, but again, not working.

var jRst = JsonConvert.DeserializeObject(body);

When I use the DeserializeObject function I am getting the following result:

    {[
  [
    "Item Title",
    "Bidder Name",
    "Bidder Email",
    "Bidder Phone Number",
    "Bidder Username",
    "Bid Amount",
    "Bid Time",
    "Operation",
    "Auto Bid Amount",
    "Bidder Address",
    "Bidder City",
    "Bidder State",
    "Bidder Country"
  ],
  [
    "Test Item 1"
  ],
  [
    "",
    "Tom Kelly",
    "[email protected]",
    "6303278300",
    "testaccount",
    "75.0",
    "07/30/2016 06:14 PM CDT",
    "Bid Amount",
    null,
    null,
    null,
    null,
    "US"
  ]
]}

After converting the object to a string, I ran this through the XMLNodeConverter, and it was failing on the "#" character, so I did a string replace and took out that character (wasn't needed anyway and I do not have control of what is coming to me in the JSON data) then ran my code again.

XmlNode xml = JsonConvert.DeserializeXmlNode(sBody, "BiddingHistory");

So now what I am getting is this error:

XmlNodeConverter can only convert JSON that begins with an object

Would someone please steer me in the right direction here? I'm thinking this is a simple thing to do and I am overcomplicating it.

Thanks.

tried this XmlDocument xdoc = JsonConvert.DeserializeXmlNode(yourjson);? — Raktim Biswas
– Raktim Biswas, Commented Jul 31, 2016 at 17:52

Raktim Biswas · Accepted Answer · 2016-07-31 18:10:22Z

6

You are getting an error because your JSON data is an array and what you have done is:

XmlNode xml = JsonConvert.DeserializeXmlNode(sBody, "BiddingHistory");

the above line of code will only work for JSON objects.

So, if your JSON is an Array, then try this:

XmlNode xml = JsonConvert.DeserializeXmlNode("{\"Row\":" + sBody + "}", "BiddingHistory").ToXmlString();

answered Jul 31, 2016 at 18:10

Raktim Biswas

4,1055 gold badges30 silver badges34 bronze badges

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

7 Comments

DadTo2 Over a year ago

Rakitić, I'm attempting this to see if it works, but am coming up with an error on my build. Error is: System.Xml.XmlDocument does not contain a definition for 'ToXmlString' and no extension method 'ToXmlString' accepting a first argument of type 'System.XmlDocument' could be found. I do have using System.Xml and using Newtonsoft.Json in my code. Anything else I might be missing here to try this out?

DadTo2 Over a year ago

Sorry, hit enter too quickly. Error above.

Raktim Biswas Over a year ago

you must have declared XmlDocument xmlDoc = new XmlDocument(); somewhere in your code...try replacing XmlDocument to XDocument.

DadTo2 Over a year ago

I did have that exact line five lines after inserting your suggestion, so I've taken that out, rebuilt and still have the same error. Here is the code I have with your line and the next three lines after: XmlNode xml = JsonConvert.DeserializeXmlNode("{\"Row\":" + sbody + "}", "BiddingHistory").ToXmlString(); var xmlReader = new XmlNodeReader(xml); DataSet dataSet = new DataSet(); dataSet.ReadXml(xmlReader);

DadTo2 Over a year ago

It's been a long weekend on this project. I just realized that what you suggested (with just very minor tweaking) worked and the JSON is now in XML format. Appreciate the help Rakitić. Now on to getting this dataset populated. Thanks again all!

|

Mostafiz · Accepted Answer · 2016-07-31 18:34:59Z

2

Use service stack from nuget Service Stack

add reference to your program

using ServiceStack;

Convert your json to object

var jRst = JsonConvert.DeserializeObject(body);

after that you can get xml using service stack like below

var xml = jRst.ToXml();

answered Jul 31, 2016 at 18:34

Mostafiz

7,3523 gold badges30 silver badges42 bronze badges

Collectives™ on Stack Overflow

Converting JSON Array to XML in C#

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related