C# Retrieve JSON Object by Containing Value

Question

I've come across a bit of a problem. I want to convert a steam game name to its corresponding steam app id via the steamapi. I'm trying to figure out how to get the entirety of a object from a value it contains (

{"applist":{"apps":[{"appid":230410,"name":"Warframe"}, {"appid":25300,"name":"Call of Duty"}, {"appid":292410,"name":"Team Fortress 2"}]}}

for example. the name here is Warframe. but I want to grab the entirety of this object just by the "name" value. I've been looking for an answer for awhile. any help would be appreciated

I tried deserializing the response to a class. but this seemed to be useless since all objects contain the same value name just with different titles

What is "entirety"? can you show the example what you want to retrive? I can see only one object, what else are going to find? — Serge
– Serge, Commented Nov 9, 2022 at 19:10
Have a look at Array.Find(), List.Find() and Enumerable.First() for examples of how to single value in a collection based on one of its properties — Andrew Williamson
– Andrew Williamson, Commented Nov 9, 2022 at 19:10
@Serge i hotlinked the json value to "steamapi" its a jumble of json containing every game on the steam store containing its name and appid — willcodes
– willcodes, Commented Nov 9, 2022 at 19:12
@willcodes I'm at work, and that link is blocked by my company's firewall. It's a good idea to include the link, but it's also good to include a bit more information directly in your post in case people can't access the link. In this case, I would include the parent object/array. You don't have to include all the child items, just two or three is enough to demonstrate — Andrew Williamson
– Andrew Williamson, Commented Nov 9, 2022 at 19:16

Serge · Accepted Answer · 2022-11-09 19:23:02Z

1

you can try this code

var result=JObject.Parse(json)["applist"]["apps"].Where(a=> (string)a["name"]=="Warframe").FirstOrDefault();

//if you need id

var appid = (int) result["appid"];

//or in one line

int appid = (int) JObject.Parse(json)["applist"]["apps"]
.FirstOrDefault(a=> (string)a["name"]=="Warframe")?["appid"];

edited Nov 9, 2022 at 19:23

answered Nov 9, 2022 at 19:18

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

5 Comments

Andrew Williamson Over a year ago

FirstOrDefault can take the predicate directly, no need to add Where inbetween

Serge Over a year ago

@AndrewWilliamson I always like to separate flys from burgers.

willcodes Over a year ago

@Serge I'm getting a System.ArgumentNullException when a game's name has a ":" in the name

Serge Over a year ago

@willcodes pls show the example where do you have an error

willcodes Over a year ago

@Serge sorry for the delay! I fixed it, it was a issue with the full json response not being pulled not the code itself.

Collectives™ on Stack Overflow

C# Retrieve JSON Object by Containing Value

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related