CODEWITHSUNDEEP
c#jsonjson.net
André Castro
André Castro

Reputation: 83

JSON Newtonsoft C# - Deserialize specific fields in JSON file

I am working with a huge JSON file, where is just needed to extract some fields inside it. I've been searching some ways to deserialize, but don't want to create the whole Class and Object in C# with all the fields inside the JSON, this would be a lot of useless memory.

I can get the JSON file using a Webclient:

using (WebClient wc = new WebClient())
{
   jsonWeb = wc.DownloadString("http://link_to_get_JSON");
}

//Deserialize into a JObject
JObject obj = JObject.Parse(jsonWeb);

//Tried to access the info with
var val = obj.PropTwo;
var solution = obj.Descendants().OfType<JProperty>().Where(p => p.Name == "solverSolution").Select(x => x.Value.ToString()).ToArray();

I really could not find a way to get the wanted fields inside the JObject. Inside the JSON, the only information is needed is the solverSolution:{} below:

{
   "content":
   [
      {
         "id":"f4d7e7f5-86ab-4155-8336-ca5f552cb3b4",
         "name":"m1",
         "description":"m1",
         "maxHeight":2000.0,
         "layers":6,
         "pallet":{},
         "product":{},
         "solverSolution":
         {
            "id":"106ef605-d95e-4c74-851b-63310fbcbc7d",
            "name":"solver",
            "maxHeight":2000.0,
            "layers":6,
            "solution":[
            {
               "X1":0,
               "Y1":0,
               "Z1":0,
               "X2":296,
               "Y2":246,
               "Z2":220
            },
            ...
            "default":false
         },
         "customSolutions":[0]
      },
     {},
     ...
   ],
   "pageable":{},
   "totalPages":1,
   "last":true,
   "totalElements":7,
   "first":true,
   "sort":{},
   "number":0,
   "numberOfElements":7,
   "size":20
}

Here I leave my appreciation and gratitude for the community beforehand. Cheers,

André Castro.

Upvotes: 2

Views: 2921

Answers (3)

Nkosi
Nkosi

Reputation: 247018

Then use only the desired properties in your object, making sure to follow the structure of the desired model.

public partial class RootObject {
    [JsonProperty("content")]
    public Content[] Content { get; set; }
}

public partial class Content {
    [JsonProperty("solverSolution")]
    public SolverSolution SolverSolution { get; set; }
}

public partial class SolverSolution {
    [JsonProperty("id")]
    public Guid Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("maxHeight")]
    public double MaxHeight { get; set; }

    [JsonProperty("layers")]
    public long Layers { get; set; }

    [JsonProperty("solution")]
    public Solution[] Solution { get; set; }

    [JsonProperty("default")]
    public bool Default { get; set; }
}

public partial class Solution {
    [JsonProperty("X1")]
    public long X1 { get; set; }

    [JsonProperty("Y1")]
    public long Y1 { get; set; }

    [JsonProperty("Z1")]
    public long Z1 { get; set; }

    [JsonProperty("X2")]
    public long X2 { get; set; }

    [JsonProperty("Y2")]
    public long Y2 { get; set; }

    [JsonProperty("Z2")]
    public long Z2 { get; set; }
}

The parser will ignore the rest that do not map to properties of the object model.

var root = Jsonsonvert.DeserializeObject<RootObject>(jsonWeb);
var solverSolution = root.Content[0].SolverSolution;

How can I get all SolverSolution

SolverSolution[] solutions = root.Content.Select(content => content.SolverSolution).ToArray();

Upvotes: 5

BitByBit
BitByBit

Reputation: 21

I use:

JsonConvert.DeserializeObject<dynamic>(stringInput)

to get anonymouse type I need

Then you can use something like this to get specific part:

var obj = JsonConvert.DeserializeObject<dynamic>(input)["content"][0]["solverSolution"];

It's easy and gets me job done.

Edit: Side note, please next time when you upload json just cut off parts that are not needed so I can serialize it, took me some time to fix it :D

Upvotes: 2

Cleyton Silva
Cleyton Silva

Reputation: 43

You can use a JObject to parse all Json. Then, you can map a specific children to your object.

Reference

Upvotes: 0

Related Questions