How do I get value from nested json object in newtonsoft.json

Question

1.00/5 (1 vote)

See more:

I want to parse the keyValue Pair from the file without using the Class .

Basically what i want is :

Deserialize Json from file in C#

What I have tried:

MyOutput.json

    {
    "Platform Parent Dato Id": "23768",
    "Platform Dato Id": "24138",
    "Platform Dato Name": "Random Europe",
    "Platform mission Id": "111112",
    "Platform submission Id": "638687",
    "Platform submission Flight Id": "863524",
    "Start Date": "2017-12-01",
    "End Date": "2017-12-02",
    "Platform Compensation": 109.0909,
    "Total Value": 909.0909,
    "Goal": "200000.0000",
    "Value Information": {
      "Platform Compensation": [
        {
          "Platform mission Id": "111112",
          "Platform submission Id": "638687",
          "Platform submission Flight Id": "863524",
          "Value Rate": "14.0000",
          "Value": 109.0909
        }
      ]
    }
  },
  {
    "Platform Parent Dato Id": "23768",
    "Platform Dato Id": "24138",
    "Platform Dato Name": "Random Europe",
    "Platform mission Id": "111113",
    "Platform submission Id": "638687",
    "Platform submission Flight Id": "863524",
    "Start Date": "2017-12-01",
    "End Date": "2017-12-02",
    "Platform Compensation": 109.0909,
    "Total Value": 909.0909,
    "Goal": "200000.0000",
    "Value Information": {
      "Platform Compensation": [
        {
          "Platform mission Id": "111113",
          "Platform submission Id": "638687",
          "Platform submission Flight Id": "863524",
          "Value Rate": "12.0000",
          "Value": 109.0909
        }
      ]
    }
  }

<programs.cs>

static void Main(string[] args)
       {


           string jsonFilePath = @"Output.json";

           string json = File.ReadAllText(jsonFilePath);

           var dict = JsonConvert.DeserializeObject<Dictionary<string, Object>>(json);
           foreach (var kv in dict)
           {
               Console.WriteLine(kv.Key + ":" + kv.Value);
           }


       }

I want to print Data like :(One case1)
Platform Parent Dato Id: 23768
Case2:

and I am using a NewtonJson in order to get the Value Rate from the Value Information nest.

Output Should be
Value Rate": 14.0000

Thanks for the advanced
Looking forward for your response

Posted 12-Jul-22 21:38pm

Member 14837073

Updated 13-Jul-22 0:01am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2022-07-12T21:44:00

Solution 1

I wrote an article based on questions like yours in here that has the answers that you want: Working with JSON in C# & VB[^]

Posted 12-Jul-22 21:44pm

Graeme_Grant

OriginalGriff · Answer 2 · 2022-07-12T21:50:00

The Newtonsoft JSON package is designed to work with hierarchical classes: it has no provision for "random access" to properties.
DeserializeObject returns a class instance which contains the full "tree" of contained objects in the JSON data - it doesn't return key/value pairs!

Use a JSON-to-C#-Class converter like this: Convert JSON to C# Classes Online - Json2CSharp Toolkit[^] and it will construct the class templates you need to access the data:

// Root myDeserializedClass = JsonConvert.DeserializeObject<Root>(myJsonResponse);
    public class PlatformCompensation
    {
        [JsonProperty("Platform mission Id")]
        public string PlatformMissionId { get; set; }

        [JsonProperty("Platform submission Id")]
        public string PlatformSubmissionId { get; set; }

        [JsonProperty("Platform submission Flight Id")]
        public string PlatformSubmissionFlightId { get; set; }

        [JsonProperty("Value Rate")]
        public string ValueRate { get; set; }
        public double Value { get; set; }
    }

    public class Root
    {
        [JsonProperty("Platform Parent Dato Id")]
        public string PlatformParentDatoId { get; set; }

        [JsonProperty("Platform Dato Id")]
        public string PlatformDatoId { get; set; }

        [JsonProperty("Platform Dato Name")]
        public string PlatformDatoName { get; set; }

        [JsonProperty("Platform mission Id")]
        public string PlatformMissionId { get; set; }

        [JsonProperty("Platform submission Id")]
        public string PlatformSubmissionId { get; set; }

        [JsonProperty("Platform submission Flight Id")]
        public string PlatformSubmissionFlightId { get; set; }

        [JsonProperty("Start Date")]
        public string StartDate { get; set; }

        [JsonProperty("End Date")]
        public string EndDate { get; set; }

        [JsonProperty("Platform Compensation")]
        public double PlatformCompensation { get; set; }

        [JsonProperty("Total Value")]
        public double TotalValue { get; set; }
        public string Goal { get; set; }

        [JsonProperty("Value Information")]
        public ValueInformation ValueInformation { get; set; }
    }

    public class ValueInformation
    {
        [JsonProperty("Platform Compensation")]
        public List<PlatformCompensation> PlatformCompensation { get; set; }
    }

Then it's pretty trivial to get the data you want in a way that is easy to read, easy to understand, and easy to maintain.

Richard Deeming · Answer 3 · 2022-07-13T00:01:00

Solution 3

If you don't want to use specific classes, then you'll have to use LINQ to JSON, with the JObject class:

LINQ to JSON[^]

Posted 13-Jul-22 0:01am

Richard Deeming