Home / Questions / 236343
Accepted
Richard Víquez Pérez
Asked: 2020-02-09 08:06:13 +0800 CST 2020-02-09 08:06:13 +0800 CST

Deserialize a JSON with variable property names

  • 772

I have the following JSON:

{
  "-LY2_Np3-jTOC9T0-Xzb": {
      "Descripcion": "Se realizo una factura(p) en tienda: 3 por el usuario: ARMANDO",
      "Fecha": "2019-02-06",
      "Hora": "10:13:01 AM",
      "Monto": "10763.5",
      "Tipo": "Transaccion"
  },
  "-LY2j1Fbl195pooEich8": {
      "Descripcion": "Se realizo una factura(f) en tienda: 3 por el usuario: ARMANDO",
      "Fecha": "2019-02-06",
      "Hora": "10:55:10 AM",
      "Monto": "26900",
      "Tipo": "Transaccion"
  },
  "-LY2jyHCM1DtZAxdxt7W": {
      "Descripcion": "Se realizo una factura(p) en tienda: 3 por el usuario: ARMANDO",
      "Fecha": "2019-02-06",
      "Hora": "10:59:16 AM",
      "Monto": "29830",
      "Tipo": "Transaccion"
  },
  "-LY2nQxcbMGO0oP5vmOM": {
      "Descripcion": "Se realizo una factura(p) en tienda: 3 por el usuario: ARMANDO",
      "Fecha": "2019-02-06",
      "Hora": "11:14:24 AM",
      "Monto": "9830",
      "Tipo": "Transaccion"
  }
}

As you can see the id is dynamic. How can I deserialize this file in C#?

c#

2 Answers

  1. In these cases you can deserialize using a Dictionary. Create a class for the items

    public class Item
{
    public string Descripcion { get; set; }
    public string Fecha { get; set; }
    public string Hora { get; set; }
    public string Monto { get; set; }
    public string Tipo { get; set; }
}

    And then you deserialize like this:

    var resultado = JsonConvert.DeserializeObject<Dictionary<string, Item>>(json);

    Each of the dictionary keys are the ids, for example you can get the first element like this:

    var item = resultado["-LY2_Np3-jTOC9T0-Xzb"];
    • 3
  2. Best Answer

    Here

    How to convert a JObject to List<>

    the same problem was raised, where it has dynamic properties.

    Basically you define the class

    public class Class1
{
   public string Descripcion { get; set; }
   public DateTime Fecha { get; set; }
   //resto propiedades
}

    And then you can useJObject.Parse()

       JObject jObj = JObject.Parse(json);

    var result = from item in jObj.Properties()
                 select new Class1(){
                     Descripcion = item.Value["Descripcion"].ToString(),
                     Fecha= Convert.ToDateTime(item.Value["Fecha"]),
                     //resto
                 };

    foreach(var item in result)
    {
        Console.WriteLine("{0}, {1}, ...", item.Descripcion , item.Fecha, ...);
    }
    • 2