Take specific value from a JSON or XML

Question

Hello, I have an entire JSON inside a string and I need to turn it into an object in order to access some data... I’ll leave the code below to see if you can help me.

My JSON is in that string:

string json = Newtonsoft.Json.JsonConvert.SerializeXmlNode(doc);

part of the JSON:

{
"?xml":{"@version":"1.0","@encoding":"Windows-1252","@standalone":"yes"},
  "VFPData": {
    "row": [
      {
        "@numero": "000",
        "@descricao": "Menu principal",
      },
      {
        "@numero": "001",
        "@descricao": "Arquivos",
      }
    ]
  }
}

I need to access the values of these @descrição.

I’m using .Net Core Razor Pages... someone there could give me a hand with this ???

JSON(JSON Visualize from VS):

the @descricao is the @des_mn0, that I need to take.

AS I AM DOING:

public class DadosMenu
{
    [JsonProperty("VFPData")]
    public VFP vfp { get; set; }
}
public class VFP
{
    [JsonProperty("row")]
    public Row[] row { get; set; }
}
public class Row
{
    [JsonProperty("@des_mn0")]
    public string des { get; set; }
}

(public IActionResult OnGet(){}):

var xml = System.IO.File.ReadAllText(@"C:\Dados\VS\MenuXML\menuV11.Xml");

XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
string json = JsonConvert.SerializeXmlNode(doc).ToString();

DadosMenu result = JsonConvert.DeserializeObject<DadosMenu>(json);

for (int i = 1; i < 9; i++)
{
    descr +=  result.vfp.row[i].des + " - ";
}
HttpContext.Session.SetString("xmltojson", descr);

EDIT: Okay, I’m already getting the values I need... thank you all for the answers, and I’ve updated the question, showing how I’m doing to get the values.

If possible, if you can do the same (take a specific value) in an XML, it will save me a little work... then I will leave part of the XML below, so you can know how to do...

OBS:

1 - XML refers to the same json subject. I just transformed it.

2 - I need to save this data I took, in a lista, so that I can then use them to assemble a menu.(nav-bar)

(XML)

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
    <xsd:schema id="VFPData" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
        <xsd:element name="VFPData" msdata:IsDataSet="true">
            <xsd:complexType>
                <xsd:choice maxOccurs="unbounded">
                    <xsd:element name="row" minOccurs="0" maxOccurs="unbounded">
                        <xsd:complexType>
                            <xsd:attribute name="num_mn0" use="required">
                                <xsd:simpleType>
                                    <xsd:restriction base="xsd:string">
                                        <xsd:maxLength value="15"/>
                                    </xsd:restriction>
                                </xsd:simpleType>
                            </xsd:attribute>
                            <xsd:attribute name="des_mn0" use="required">
                                <xsd:simpleType>
                                    <xsd:restriction base="xsd:string">
                                        <xsd:maxLength value="200"/>
                                    </xsd:restriction>
                                </xsd:simpleType>
                            </xsd:attribute>
                        </xsd:complexType>
                    </xsd:element>
                </xsd:choice>
                <xsd:anyAttribute namespace="http://www.w3.org/XML/1998/namespace" processContents="lax"/>
            </xsd:complexType>
        </xsd:element>
    </xsd:schema>
<row num_mn0="000" des_mn0="Menu principal"/>
<row num_mn0="001" des_mn0="Arquivos"/>

I need to get the value of des_mn0.

EDIT2:

error that appears when trying to answer Alisson:

Onget:

XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
string json = JsonConvert.SerializeXmlNode(doc);

DadosMenu result = JsonConvert.DeserializeObject<DadosMenu>(json);

ViewData["DadosMenu"] = result.vfp.row;

return Page();

I had, yesterday, created a list that I keep all the information I need... I just don’t know how to get this data in HTML, look how I did:

XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
string json = JsonConvert.SerializeXmlNode(doc);

DadosMenu result = JsonConvert.DeserializeObject<DadosMenu>(json);

List<string> MenuPrincipal = new List<string>();
int i = 1;
while (result.vfp.row[i].men != "")
{
    if (result.vfp.row[i].men == "_MSYSMENU")
    {
        MenuPrincipal.Add(result.vfp.row[i].des);
    }
    else
    {
        break;
    }
    i++;
}

ViewData["MenuPrincipal"] = MenuPrincipal;

return Page();

Answer 1

Convert JSON

To convert JSON to object using the public Json.NET your model must follow the same structure as your JSON so that the component can convert. Classes and properties have to respect JSON names so you can use the annotation JsonProperty.

In your JSON you have a Vfpdata object with an array of Row object, which contains the data, so your model would be as follows:

Model:

public class DadosMenu
{
    [JsonProperty("VFPData")]
    public VFP vfp { get; set; }
}

public class VFP
{
    [JsonProperty("row")]
    public List<Row> row { get; set; }
}

public class Row
{
    [JsonProperty("@des_mn0")]
    public string des { get; set; }
}

With the model created according to JSON Deserializeobject will be able to populate the object correctly.

---

View

As you mentioned on the issue’s Edit and in the comments, you need this data to mount the nav-bar from the menu in your view.

Now with the data populated in the objects, you can in your controller return the list in several ways, I believe the two most common is by Viewdata and by model in strongly typed view.

Having this data in View either by Viewdata or Model you can do the for and generate your Nav-bar directly on Razor.

Note: The two examples will be in the code, just remove what you will not use.

Example:

Controller

public IActionResult OnGet(){
    var xml = System.IO.File.ReadAllText(@"C:\Dados\VS\MenuXML\menuV11.Xml");

    XmlDocument doc = new XmlDocument();
    doc.LoadXml(xml);
    string json = JsonConvert.SerializeXmlNode(doc).ToString();

    DadosMenu result = JsonConvert.DeserializeObject<DadosMenu>(json);

    // Caso queira retornar por ViewData utilize esta linha abaixo
    ViewData["DadosMenu"] = result.vfp.row; 

    // Nesta linha retornara para a View e ela deve ser anotada com 
    // @model ObjetoModelDaView
    return View(result.vfp.row);
}

View

// Usar essa linha se optar por Fortemente Tipada
// Esta linha é quem define o tipo da View
// Tem que ser o mesmo tipo que voce vai retornar no controller em return View(objeto)
@model List<Row>

<nav class="navbar navbar-expand-lg navbar-light bg-light">
  <a class="navbar-brand" href="#">Navbar</a>
  <div class="collapse navbar-collapse" id="navbarNav">
    <ul class="navbar-nav">
      @{
        // Usar se optar por ViewData    
        var rows = ViewData.DadosMenu as List<Row>; 

        // Se for usar Fortemente Tipada trocar rows por Model
        // Pois o Model da view é a List<Row>
        for (Row row : rows) {
          <li class="nav-item">
            <a class="nav-link" href="#">@row.des</a>
          </li>
        }
      }          
    </ul>
  </div>
</nav>

Answer 2

I suggest you use the library Json.net that can be downloaded here.

Then it’s just:

using Newtonsoft.Json;

...
var result = JsonConvert.DeserializeObject<teste>(json);

Where the teste corresponds to the object type that corresponds to the string of your Json.

Answer 3

Edited the question and closing that XML that came wrong stands as an example:

XML:

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
    <xsd:schema id="VFPData" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
        <xsd:element name="VFPData" msdata:IsDataSet="true">
            <xsd:complexType>
                <xsd:choice maxOccurs="unbounded">
                    <xsd:element name="row" minOccurs="0" maxOccurs="unbounded">
                        <xsd:complexType>
                            <xsd:attribute name="num_mn0" use="required">
                                <xsd:simpleType>
                                    <xsd:restriction base="xsd:string">
                                        <xsd:maxLength value="15"/>
                                    </xsd:restriction>
                                </xsd:simpleType>
                            </xsd:attribute>
                            <xsd:attribute name="des_mn0" use="required">
                                <xsd:simpleType>
                                    <xsd:restriction base="xsd:string">
                                        <xsd:maxLength value="200"/>
                                    </xsd:restriction>
                                </xsd:simpleType>
                            </xsd:attribute>
                        </xsd:complexType>
                    </xsd:element>
                </xsd:choice>
                <xsd:anyAttribute namespace="http://www.w3.org/XML/1998/namespace" processContents="lax"/>
            </xsd:complexType>
        </xsd:element>
    </xsd:schema>
    <row num_mn0="000" des_mn0="Menu principal"/>
    <row num_mn0="001" des_mn0="Arquivos"/>
<VFPData/>

Classes:

using System;
using System.ComponentModel;
using System.Xml.Serialization;

[Serializable()]
[DesignerCategory("code")]
[XmlType(AnonymousType = true)]
[XmlRoot(Namespace = "", IsNullable = false)]
public partial class VFPData
{
    [XmlElement("row")]
    public VFPDataRow[] Rows { get; set; }
}

[Serializable()]
[DesignerCategory("code")]
[XmlType(AnonymousType = true)]
public partial class VFPDataRow
{     
    [XmlAttribute("num_mn0")]
    public string Number { get; set; }        
    [XmlAttribute("des_mn0")]
    public string Description { get; set; }
}

Code creating a typed data with this information:

var serializer = new XmlSerializer(typeof(VFPData));
using (var textReader = new StreamReader("./data.xml"))
{
    VFPData data = (VFPData)serializer.Deserialize(textReader);
}

---

JSON:

Basically modeling for classes and with the package Json.NET configuring Jsonproperty, example:

public class Rootobject
{
    [JsonProperty("?xml")]
    public Xml Xml { get; set; }
    [JsonProperty("VFPData")]
    public Vfpdata Vfpdata { get; set; }
}

public class Xml
{
    [JsonProperty("@version")]
    public string Version { get; set; }
    [JsonProperty("@encoding")]
    public string Encoding { get; set; }
    [JsonProperty("@standalone")]
    public string Standalone { get; set; }
}

public class Vfpdata
{
    [JsonProperty("row")]
    public Row[] Rows { get; set; }
}

public class Row
{
    [JsonProperty("@numero")]
    public string Numero { get; set; }
    [JsonProperty("@descricao")]
    public string Descricao { get; set; }
}

and carrying the json:

var json = System.IO.File.ReadAllText("./data.json");
Rootobject root = JsonConvert.DeserializeObject<Rootobject>(json);

Ref. Documentation - Json.NET

Answer 4

1- You are using the Dados as an object of deserialization:

Dados result = JsonConvert.DeserializeObject<Dados>(json);

But the object to which the string json refers is the DadosMenu

2- You are trying to get the property @des_mn0 but the example JSON has the property @descricao