C# effective way to get JSON property value from nested JSON response

Question

I am getting a HTTP response as JSON string. I am converting the response as JObject. Response contains "sessions" node and it contains more sessions value each sessions contains "events" with one or multiple "events" each events contains "Type" and "ArbitaryData" ArbitaryData contains "interest".

I am trying to take all the "interest" values, from all the sessions and all the events but if the event type = "search".

what's the effective way to do that other than doing for loop?

 JObject json = JObject.Parse(guestJsonResponse);
 var sessions = json.SelectToken("sessions");
 var events = sessions.SelectTokens("events");

Below is my JSON string response example

  {
  "firstName":"fn",
  "lastName":"ln",
   "gender":"male",
  "sessions":[
  {
     "currency":"USD",
     "events":[
        {
           "type":"SEARCH",
           "status":"PROCESSED",
           "arbitraryData":{
              "interest":"Health"
           }
        },
        {
           "type":"CHECK",
           "status":"PROCESSED",
           "arbitraryData":{
              "interest":"Dental"
           }
        }
     ]
  },
  {
     "currency":"USD",
     "events":[
        {
           "type":"SEARCH",
           "status":"PROCESSED",
           "arbitraryData":{
              "interest":"Health"
           }
        },
        {
           "type":"CHECK",
           "status":"PROCESSED",
           "arbitraryData":{
              "interest":"Dental"
           }
        }
     ]
  },
  {
     "currency":"USD",
     "events":[
        {
           "type":"SEARCH",
           "status":"PROCESSED",
           "arbitraryData":{
              "interest":"Health"
           }
        },
        {
           "type":"CHECK",
           "status":"PROCESSED",
           "arbitraryData":{
              "interest":"Dental"
           }
        }
     ]
  }
   ]
     }

You could create a DTO class, parse the JSON into an instance of that class and then use LINQ to filter out unwanted objects in the list — Julian, Oct 05 '22 at 19:09
Take a look at here https://stackoverflow.com/questions/23645034/jobject-parse-vs-jsonconvert-deserializeobject — Batuhan, Oct 05 '22 at 19:34

Serge · Accepted Answer · 2022-10-05T19:42:22.560

2

This code will return all the "interest" values, from all the sessions where the event type = "SEARCH"

List<string> interests = ((JArray)JObject.Parse(json)["sessions"])
                              .SelectMany(i => ((JArray)i["events"]))
                              .Where(x => (string)x["type"] == "SEARCH")
                              .Select(x => (string)x["arbitraryData"]["interest"])
                              .ToList();

edited Oct 05 '22 at 19:42

answered Oct 05 '22 at 19:30

Serge

40,935
4
18
45

Code only answer. – Poul Bak Oct 05 '22 at 19:32
@PoulBak "I am trying to take all the "interest" values, from all the sessions and all the events but if the event type = "search". This is my answer – Serge Oct 05 '22 at 19:34
I don't need an explanation, but OP and later searchers might. – Poul Bak Oct 05 '22 at 19:37
Please mark as solution if this is your answer @user1428019 – Batuhan Oct 05 '22 at 19:42
@PoulBak I added some description – Serge Oct 05 '22 at 19:43

C# effective way to get JSON property value from nested JSON response

1 Answers1