Parsing JSON in C# with very large JSON array

Question

I'm trying to parse a big JSON array into a c# object. Now I know of the normal way where you take a class with matching keys to the JSON object and then assign each value of the JSON object to the matching key in the c# class. but this would be horribly inefficient for my purpose because im dealing with very large JSON objects here is an example:

    [{
  "storeId": "331",
  "storeName": "Bergen, Lagunen",
  "status": "Open",
  "address": {
    "street": "Laguneveien 1",
    "postalCode": "5239",
    "city": "Rådal",
    "gpsCoord": "60.297116;5.331159",
    "globalLocationNumber": "7080003251008",
    "organisationNumber": "888039902"
  },
  "telephone": "22 01 50 00",
  "email": "[email protected]",
  "category": "6",
  "openingHours": {
    "regularHours": [{
      "dayOfTheWeek": "Monday",
      "openingTime": "10:00",
      "closingTime": "18:00",
      "closed": false
    }, {
      "dayOfTheWeek": "Tuesday",
      "openingTime": "10:00",
      "closingTime": "18:00",
      "closed": false
    }, {
      "dayOfTheWeek": "Wednesday",
      "openingTime": "10:00",
      "closingTime": "18:00",
      "closed": false
    }, {
      "dayOfTheWeek": "Thursday",
      "openingTime": "10:00",
      "closingTime": "18:00",
      "closed": false
    }, {
      "dayOfTheWeek": "Friday",
      "openingTime": "10:00",
      "closingTime": "18:00",
      "closed": false
    }, {
      "dayOfTheWeek": "Saturday",
      "openingTime": "10:00",
      "closingTime": "15:00",
      "closed": false
    }, {
      "dayOfTheWeek": "Sunday",
      "openingTime": "",
      "closingTime": "",
      "closed": true
    }],
    "exceptionHours": [{
      "date": "2020-05-21",
      "openingTime": "",
      "closingTime": "",
      "message": "Stengt Kristi himmelfartsdag"
    }]
  },
  "lastChanged": {
    "date": "2020-05-04",
    "time": "00:02:04"
  }
}]

is there any way to dynamically make this into a c# object as you can in javascript using JSON.parse?

Check out Newtonsoft.Json and in particular the JArray.Parse method. — Jesse de Wit
– Jesse de Wit, Commented May 6, 2020 at 20:25
I don't see why you shouldn't create a class matching your object. It doesn't seem exceptionally large to me — Sami
– Sami, Commented May 6, 2020 at 20:26

Jesse de Wit · Accepted Answer · 2020-05-06 20:31:03Z

1

You say you have big json. I will assume that you say that because the json have many properties you don't need. If you do need all properties, I would just define a class containing all the properties.

That said. I think you have two real options if we'd go for Newtonsoft.Json.

1. Define a class with only the properties you need

public class Pruned
{
    public string StoreId { get; set; }
}

var prunedList = JsonConvert.DeserializeObject<List<Pruned>>(myJsonString);

2. Deserialize into a JArray and treat it as a dynamic object.

var jArray = JArray.Parse(myJsonString);
var firstStoreId = jArray[0]["storeId"];

answered May 6, 2020 at 20:31

Jesse de Wit

4,2071 gold badge23 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing JSON in C# with very large JSON array

1 Answer 1

1. Define a class with only the properties you need

2. Deserialize into a JArray and treat it as a dynamic object.

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1. Define a class with only the properties you need

2. Deserialize into a JArray and treat it as a dynamic object.

Comments

Your Answer

Sign up or log in

Post as a guest

Related