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
– Julian, Commented Oct 5, 2022 at 19:09
Take a look at here stackoverflow.com/questions/23645034/… — Batuhan
– Batuhan, Commented Oct 5, 2022 at 19:34

Serge · Accepted Answer · 2022-10-05 19:42:22Z

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 5, 2022 at 19:42

answered Oct 5, 2022 at 19:30

Serge

44.4k4 gold badges26 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Poul Bak Over a year ago

Code only answer.

Serge Over a year ago

@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

Poul Bak Over a year ago

I don't need an explanation, but OP and later searchers might.

Batuhan Over a year ago

Please mark as solution if this is your answer @user1428019

Serge Over a year ago

@PoulBak I added some description

Collectives™ on Stack Overflow

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

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related