How to read a Json string with dynamic Node using c#?

Question

How to read a Json string with dynamic Node using c# ? I am not able to read the keys and sub nodes in the key.

      {
         "2030417": [{
          "country": "Malaysia",
          "push": 20543,
          "click": 752,
          "ctr": 3.66,
          "cpc": 0.03,
          "conversion": 0,
          "conversionrate": 0,
          "cpa": 0,
          "SOV%": "3.87"
         }],
         "2032769": [{
          "country": "India",
          "push": 10460,
          "click": 0,
          "ctr": 0,
          "cpc": 0.001,
          "conversion": 7,
          "conversionrate": 0.07,
          "cpa": 2.22,
          "SOV%": "0.28"
         }]
        }

Hint to the solution lies over here: http://stackoverflow.com/questions/20727787/deserialize-json-string-to-dictionarystring-object — Edgaras, Sep 02 '16 at 09:06
Take a look here: https://thewayofcode.wordpress.com/2012/09/18/c-dynamic-object-and-json-serialization-with-json-net/ — Rami Yampolsky, Sep 02 '16 at 09:30

score 1 · Answer 1 · edited May 23 '17 at 12:16

You can either:

Use the dynamic object & call properties on the fly:

dynamic d = JObject.Parse("{number:1000, str:'string', array: [1,2,3,4,5,6]}");

Console.WriteLine(d.number);
Console.WriteLine(d.str);
Console.WriteLine(d.array.Count);

You can also iterate through different properties if needed:

JObject d = JObject.Parse("{\"2030417\":[{\"country\":\"Malaysia\",\"push\":20543,\"click\":752,\"ctr\":3.66,\"cpc\":0.03,\"conversion\":0,\"conversionrate\":0,\"cpa\":0,\"SOV%\":\"3.87\"}],\"2032769\":[{\"country\":\"India\",\"push\":10460,\"click\":0,\"ctr\":0,\"cpc\":0.001,\"conversion\":7,\"conversionrate\":0.07,\"cpa\":2.22,\"SOV%\":\"0.28\"}]}";);

var country = d["2030417"][0]["country"];

How to read a Json string with dynamic Node using c#?

1 Answers1