How to convert XML data object to json?

Question

i have the following xml in the view's C# block

@{

var xmlDoc = "<class Title="SOCIAL HISTORY" ID="1" ParentID="0">
  <helpNavNode Title="ALCOHOL CONSUMPTION" ID="2" ParentID="1">
    <helpNavNode Title=" Never" ID="3" ParentID="2" Narrative="ALCOHOL CONSUMPTION: Never" />
    <helpNavNode Title=" Occasionally" ID="4" ParentID="2" Narrative="ALCOHOL CONSUMPTION: Occasionally" />
    <helpNavNode Title=" Socially" ID="5" ParentID="2" Narrative="ALCOHOL CONSUMPTION: Socially" />
    <helpNavNode Title=" Daily (3 beers/day) (6 pack/day)" ID="6" ParentID="2" Narrative="ALCOHOL CONSUMPTION: Daily (3 beers/day) (6 pack/day)" />
    <helpNavNode Title=" Is Alcoholic" ID="7" ParentID="2" Narrative="ALCOHOL CONSUMPTION: Is Alcoholic" />
    <helpNavNode Title=" History of Alcoholism" ID="8" ParentID="2" Narrative="ALCOHOL CONSUMPTION: History of Alcoholism" />
    <helpNavNode Title=" None" ID="26" ParentID="2" Narrative="ALCOHOL CONSUMPTION: None" />
    <helpNavNode Title="Alcoholism Screen Question" ID="39" ParentID="2">
      <helpNavNode Title=" Ever had a drinking problem? Last drink? " ID="40" ParentID="39" Narrative="ALCOHOL CONSUMPTION:Alcoholism Screen Question: Ever had a drinking problem? Last drink? " />
    </helpNavNode>
  </helpNavNode>
  <helpNavNode Title="MARITAL STATUS" ID="9" ParentID="1">
    <helpNavNode Title=" Married" ID="10" ParentID="9">
      <helpNavNode Title=" x 10 years" ID="15" ParentID="10" Narrative="MARITAL STATUS: Married: x 10 years" />
    </helpNavNode>
    <helpNavNode Title=" Divorced" ID="11" ParentID="9" Narrative="MARITAL STATUS: Divorced" />
    <helpNavNode Title=" Single" ID="12" ParentID="9" Narrative="MARITAL STATUS: Single" />
  </helpNavNode>
  <helpNavNode Title="Recreational drug use" ID="13" ParentID="1" Narrative=":Recreational drug use" />
  <helpNavNode Title="OCCUPATION" ID="14" ParentID="1">
    <helpNavNode Title=" works for  x 27 years" ID="25" ParentID="14" Narrative="OCCUPATION: works for  x 27 years" />
  </helpNavNode>
  <helpNavNode Title=" 1 child" ID="16" ParentID="1" Narrative=": 1 child" />
  <helpNavNode Title=" 2/3/4/5/6 children" ID="17" ParentID="1" Narrative=": 2/3/4/5/6 children" />
  <helpNavNode Title="Activities" ID="18" ParentID="1">
    <helpNavNode Title=" walks regularly" ID="19" ParentID="18" Narrative="Activities: walks regularly" />
    <helpNavNode Title=" cycles for exercise" ID="20" ParentID="18" Narrative="Activities: cycles for exercise" />
    <helpNavNode Title=" runs 3 days/week" ID="21" ParentID="18" Narrative="Activities: runs 3 days/week" />
    <helpNavNode Title=" hunting and fishing" ID="22" ParentID="18" Narrative="Activities: hunting and fishing" />
    <helpNavNode Title=" hiking and camping" ID="23" ParentID="18" Narrative="Activities: hiking and camping" />
    <helpNavNode Title=" swims regularly" ID="24" ParentID="18" Narrative="Activities: swims regularly" />
  </helpNavNode>
  <helpNavNode Title="Tobacco Use" ID="27" ParentID="1">
    <helpNavNode Title="Cigar, Cigarette, Pipe, Smokeless" ID="30" ParentID="27">
      <helpNavNode Title="10/pk year" ID="32" ParentID="30" Narrative="Tobacco Use:Cigar, Cigarette, Pipe, Smokeless:10/pk year" />
    </helpNavNode>
    <helpNavNode Title="Quit Date" ID="35" ParentID="27" Narrative="Tobacco Use:Quit Date" />
    <helpNavNode Title="Year Started" ID="36" ParentID="27" Narrative="Tobacco Use:Year Started" />
  </helpNavNode>
  <helpNavNode Title="SocHx  Template" ID="37" ParentID="1">
    <helpNavNode Title=" Living situation:  Occupation:  Tobacco:  EtOH:  Rec. drugs: " ID="41" ParentID="37" Narrative="SocHx  Template: Living situation:  Occupation:  Tobacco:  EtOH:  Rec. drugs: " />
    <helpNavNode Title=" Living situation:  Occupation:  Tobacco:  EtOH:  Rec. drugs: " ID="42" ParentID="37" Narrative="SocHx  Template: Living situation:  Occupation:  Tobacco:  EtOH:  Rec. drugs: " />
  </helpNavNode>
</class>";

}

How do i convert the above xml to json from C#?
How do i convert the above xml to json from jquery?

UPDATE

here is the console.log( {"class":{"@Title":"SOCIAL HISTORY","@ID":"1","@ParentID":"0","helpNavNode":[{"@Title":"ALCOHOL CONSUMPTION","@ID":"2","@ParentID":"1","helpNavNode":[{"@Title":" Never","@ID":"3","@ParentID":"2","@Narrative":"ALCOHOL CONSUMPTION: Never"},{"@Title":" Occasionally","@ID":"4","@ParentID":"2","@Narrative":"ALCOHOL CONSUMPTION: Occasionally"},{"@Title":" Socially","@ID":"5","@ParentID":"2","@Narrative":"ALCOHOL CONSUMPTION: Socially"},{"@Title":" Daily (3 beers/day) (6 pack/day)","@ID":"6","@ParentID":"2","@Narrative":"ALCOHOL CONSUMPTION: Daily (3 beers/day) (6 pack/day)"},{"@Title":" Is Alcoholic","@ID":"7","@ParentID":"2","@Narrative":"ALCOHOL CONSUMPTION: Is Alcoholic"},{"@Title":" History of Alcoholism","@ID":"8","@ParentID":"2","@Narrative":"ALCOHOL CONSUMPTION: History of Alcoholism"},{"@Title":" None","@ID":"26","@ParentID":"2","@Narrative":"ALCOHOL CONSUMPTION: None"},{"@Title":"Alcoholism Screen Question","@ID":"39","@ParentID":"2","helpNavNode":{"@Title":" Ever had a drinking problem? Last drink? ","@ID":"40","@ParentID":"39","@Narrative":"ALCOHOL CONSUMPTION:Alcoholism Screen Question: Ever had a drinking problem? Last drink? "}}]},{"@Title":"MARITAL STATUS","@ID":"9","@ParentID":"1","helpNavNode":[{"@Title":" Married","@ID":"10","@ParentID":"9","helpNavNode":{"@Title":" x 10 years","@ID":"15","@ParentID":"10","@Narrative":"MARITAL STATUS: Married: x 10 years"}},{"@Title":" Divorced","@ID":"11","@ParentID":"9","@Narrative":"MARITAL STATUS: Divorced"},{"@Title":" Single","@ID":"12","@ParentID":"9","@Narrative":"MARITAL STATUS: Single"}]},{"@Title":"Recreational drug use","@ID":"13","@ParentID":"1","@Narrative":":Recreational drug use"},{"@Title":"OCCUPATION","@ID":"14","@ParentID":"1","helpNavNode":{"@Title":" works for x 27 years","@ID":"25","@ParentID":"14","@Narrative":"OCCUPATION: works for x 27 years"}},{"@Title":" 1 child","@ID":"16","@ParentID":"1","@Narrative":": 1 child"},{"@Title":" 2/3/4/5/6 children","@ID":"17","@ParentID":"1","@Narrative":": 2/3/4/5/6 children"},{"@Title":"Activities","@ID":"18","@ParentID":"1","helpNavNode":[{"@Title":" walks regularly","@ID":"19","@ParentID":"18","@Narrative":"Activities: walks regularly"},{"@Title":" cycles for exercise","@ID":"20","@ParentID":"18","@Narrative":"Activities: cycles for exercise"},{"@Title":" runs 3 days/week","@ID":"21","@ParentID":"18","@Narrative":"Activities: runs 3 days/week"},{"@Title":" hunting and fishing","@ID":"22","@ParentID":"18","@Narrative":"Activities: hunting and fishing"},{"@Title":" hiking and camping","@ID":"23","@ParentID":"18","@Narrative":"Activities: hiking and camping"},{"@Title":" swims regularly","@ID":"24","@ParentID":"18","@Narrative":"Activities: swims regularly"}]},{"@Title":"Tobacco Use","@ID":"27","@ParentID":"1","helpNavNode":[{"@Title":"Cigar, Cigarette, Pipe, Smokeless","@ID":"30","@ParentID":"27","helpNavNode":{"@Title":"10/pk year","@ID":"32","@ParentID":"30","@Narrative":"Tobacco Use:Cigar, Cigarette, Pipe, Smokeless:10/pk year"}},{"@Title":"Quit Date","@ID":"35","@ParentID":"27","@Narrative":"Tobacco Use:Quit Date"},{"@Title":"Year Started","@ID":"36","@ParentID":"27","@Narrative":"Tobacco Use:Year Started"}]},{"@Title":"SocHx Template","@ID":"37","@ParentID":"1","helpNavNode":[{"@Title":" Living situation: Occupation: Tobacco: EtOH: Rec. drugs: ","@ID":"41","@ParentID":"37","@Narrative":"SocHx Template: Living situation: Occupation: Tobacco: EtOH: Rec. drugs: "},{"@Title":" Living situation: Occupation: Tobacco: EtOH: Rec. drugs: ","@ID":"42","@ParentID":"37","@Narrative":"SocHx Template: Living situation: Occupation: Tobacco: EtOH: Rec. drugs: "}]}]}} );

thanks

What did your try? Show us your code? – CodeNotFound Feb 16 '16 at 20:30 — CodeNotFound, Feb 16 '16 at 20:30

score 2 · Accepted Answer · edited May 23 '17 at 11:59

2

C# - Xml to Json

Use JsonNet from Newtonsoft.

Example:

string xml = @"<person id='1'>
  <name>Alan</name>
  <url>http://www.google.com</url>
  <role>Admin1</role>
</person>";

XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);

string json = JsonConvert.SerializeXmlNode(doc);

(documentation)

Jquery - Xml to Json

See Convert XML to JSON (and back) using Javascript

edited May 23 '17 at 11:59

Community

1
1

answered Feb 16 '16 at 20:31

NikolaiDante

18,469
14
77
117

plus one - you kept it short, sharp and sweet!! – jim tollan Feb 16 '16 at 21:04
@NikolaiDante the conversion is successful but when tried to access the json object (to display the content of it) console.log(@doc) this prints the content but the console of chrome gives the following error message 'Uncaught SyntaxError: Unexpected token & i have updated my orignal post wit the error msg – zeelong Feb 16 '16 at 21:23
@NikolaiDante it complaining abut having those & signs – zeelong Feb 16 '16 at 21:24
@zeelong its probably best to [ask](http://stackoverflow.com/questions/ask) a new question. – NikolaiDante Feb 16 '16 at 21:25
@NikolaiDante okay i will post it! – zeelong Feb 16 '16 at 21:25
@zeelong include your current code and if possible a [mcve](http://stackoverflow.com/help/mcve) – NikolaiDante Feb 16 '16 at 21:27
@NikolaiDante i have posted it in here http://stackoverflow.com/questions/35443466/why-after-converting-xml-to-a-json-it-displays-so-many-sign-that-gives-error – zeelong Feb 16 '16 at 21:36

How to convert XML data object to json?

1 Answers1

Linked