Json string to Xml

Question

I'm a new programmer and I'm really stuck (likely being so new and having so little knowledge) I need to convert a json string (something like this): [ { "Start": "date", "Finish": "date", "Subject": "", "Comments": "", "Site": "address", "Location": null, "Status": false, "Arrived": true, "Noshow": false, "Services": "Initial Consultation", "Attendees": [ { "AccountId": 1111, "AccountType": "MP", "Name": "MMS (FP), Support " }, { "AccountId": 2220915, "AccountType": "PA", "Name": "Test, Patient " } ] }, ] into XML like this: <?xml version="1.0" encoding="UTF-8"?> true 1111 MP MMS(FP), Support 2220915 PA Test, Patient date false Initial Consultation address date false ` And have tried Googling various answers to no avail. I've tried lots of permutations of JsonConvert.DecryptXmlNode(filename); but these all through up errors. The errors I've had include "Data at root level is invalid." and "Can only convert json that begins with a valid object". For the purposes of clarification, I've been sent hundreds of Json files (no idea what is in them) and need a sort of 'catch all' scenario. Thank you in advance. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Before you start, I recommend validating your JSON using https://jsonlint.com/. The outer square brackets are not necessary, and the trailing comma at the end should ideally be removed. Now, since you mentioned you are using C# and Newtonsoft Json.NET, you could try this in a console program's Program.cs file: using System; using System.Xml.Linq; //For the XDocument class using Newtonsoft.Json; //For JsonConvert class using System.IO; //For File class class JsonToXMLProgram { static void Main(string[] args) { string myJSONString = @File.ReadAllText(@"H:\MyJsonFile.json"); //Replace with your json files' locations. //This converts the JSON string to xml XDocument myXMLDocument = JsonToXML(myJSONString); //you could then check your xml by outputting it to the console... Console.WriteLine(myXMLDocument.ToString()); //..or by saving the file to disk string myXMLFilePath = @"H:\MyXmlDocument.xml"; //Replace with the path to your generated xml files. myXMLDocument.Save(myXMLFilePath); } public static XDocument JsonToXML(string jsonString) { XDocument xmlDoc; try { xmlDoc = JsonConvert.DeserializeXNode(jsonString, "Root", true); return xmlDoc; } catch (JsonException e) { Console.WriteLine("There appears to be an error in the json file. Please validate the json to ensure that it is free from errors."); Console.WriteLine("Details: " + e.Message); return new XDocument(); } } }