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: stackoverflow.com/questions/20727787/… — Edgaras
– Edgaras, Commented Sep 2, 2016 at 9:06

Community · Accepted Answer · 2017-05-23 12:16:22Z

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"];

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related