c# get nested data value from json object

Question

Hello I have one json object which includes nested data such as below

{
"key1":"test",
"key2":{
  "key3" :"test2"
 }
}

and I have one List like below

  List<string> listkeys=  new List<string>() {"key1","key2.key3" }

I want to enter loop of listkeys and get value from json object dynamically.

foreach (int element in listkeys)
{
    //how can I get value with element
}

I couldn't find any solution.

Thanks in advance

Are you able to make a custom model, or use something like JObject.Parse? — gunr2171, May 03 '21 at 13:09
Does it answer your question? https://stackoverflow.com/questions/16079116/getting-data-from-a-deeply-nested-json-object — Tony Stark, May 03 '21 at 13:13

score 1 · Accepted Answer · answered May 03 '21 at 13:15

1

For Json.NET I recommend SelectToken. Please see Querying JSON with SelectToken.

foreach (var element in listkeys) // btw. var/string, not `int`
{
    JToken j = o.SelectToken($"$..{element}");
}

answered May 03 '21 at 13:15

tymtam

31,798
8
86
126

That is what I exactly look for. Thanks so much :) – mr. pc_coder May 03 '21 at 13:21
@tymtam Is it possible to change the value of the received `JToken`? – Toasty Aug 30 '22 at 12:30
In what sense change it? Maybe you could ask a separate question with an example showing what you're trying to achieve. – tymtam Aug 31 '22 at 00:24

score 0 · Answer 2 · answered May 03 '21 at 13:27

Assuming that you are using JSON.net to parse Json, you can do it this way.

foreach (string element in listkeys) // Quick fix, listkeys stores strings, not integers
{
    string[] keys = element.split("."); // "key2.key3" => ["key2", "key3"]
    JObject obj = <jsonObject>;
    foreach (string key in keys) // When key = "key2", obj = <jsonObject>["key2"], when key = "key3", obj = <jsonObject>["key2"]["key3"]
        obj = obj[key];
    <do something with obj>
}

Just replace the jsonObject with the Json object of yours.

c# get nested data value from json object

2 Answers2