Can't get the property of json object

Question

I'm trying to get the property of this json:

{
  "dateFrom": "2021-01-01",
  "dateTo": "",
  "totalOrderCount": 2,
  "ordersPerPage": 1000,
  "pageNumber": 1,
  "error": null,
  "orders": {
    "50000": {"offerId": 595},
    "50001": {"offerId": 595}
  }
}

This is my code:

string content = "{... json ...}";
dynamic data = JObject.Parse(content);
dynamic GartnerOrders = data.orders;

With that I can acces the orderId like this:

foreach (var order in orders)
{
    string offerId= order.Last.offerId;
}

But how do I get the orderNo? Here 50000 and 50001

Deserialize it to POCO and be done with it. Orders will be a dictionary — TheGeneral, Sep 01 '21 at 22:01
Maybe this will help: https://stackoverflow.com/questions/6522358/how-can-i-get-a-list-of-keys-from-json-net — tromgy, Sep 01 '21 at 22:05
https://stackoverflow.com/questions/25052293/deserialize-json-to-c-sharp-classes — TheGeneral, Sep 01 '21 at 22:15
If you really wanted to do this the slowest most cumbersome way possible `var result = JObject.Parse(input)["orders"].Cast().Select(x => (x.Name, Value :x.Value["offerId"].ToObject()))` — TheGeneral, Sep 01 '21 at 22:38

Serge · Accepted Answer · 2021-09-01T23:05:39.353

Try this

var jsonDeserialized = JsonConvert.DeserializeObject<Root>(json); 
jsonDeserialized.ordersList= jsonDeserialized.orders
Select(kvp => new Order { OrderNo=kvp.Key, offerId =kvp.Value.offerId}).ToList();

var order=jsonDeserialized.ordersList.Where(i=> i.OrderNo=="50001").FirstOrDefault() ;

output

{"OrderNo":"50001","offerId":595}

classes

public class Order

{
    public string OrderNo {get;set;}
    public int offerId { get; set; }
}


public class Root
{
    public string dateFrom { get; set; }
    public string dateTo { get; set; }
    public int totalOrderCount { get; set; }
    public int ordersPerPage { get; set; }
    public int pageNumber { get; set; }
    public object error { get; set; }
    public Dictionary<string, Order> orders { get; set; }
    public List<Order> ordersList {get;set;}
}

score 0 · Answer 2 · answered Sep 01 '21 at 22:36

You can do this easily as @TheGeneral mentioned - by deserializing it as a POCO.

See example using JsonSoft below:

Define the classes:

public class Data {
    public stirng dateFrom { get; set; }
    public stirng dateTo { get; set; }
    public int totalOrderCount { get; set; }
    public int ordersPerPage { get; set; }
    public int pageNumber { get; set; }
    public stirng error { get; set; }
    public List<Order> Orders { get; set; }
    
}

public class Orders {
    public int OfferId { get; set; }
}

Import NewtonSoft.Json

Now deserialize the json:

var data = Json.Deserialize<Data>(json);

Then you can do what you want:

var oders = data.Orders;

foreach (var order in orders)
{
    ...
}

Can't get the property of json object

2 Answers2