JSON parsing C# get specific data

Question

Here is the JSON that needed to be proper parsed:

https://docs.acrcloud.com/metadata

i am trying to get the:

title of the song, album name, artists.

I tried like this:

 JObject o = JObject.Parse(result);            
 Console.WriteLine("Name: " + o["metadata"]["music"]);

and it works but i am getting all the data in "music" i just need to extract the specific data.

i don't know how @cubrr check the JSON it is little bit complicated — user3181034
– user3181034, Commented Sep 5, 2015 at 23:20
Well, you've already got "music" from the "metadata". Now repeat the process to get "title" from "music". It looks like the object is inside an array though so o["metadata"]["music"][0] will get you access to the actual object. — cbr
– cbr, Commented Sep 5, 2015 at 23:25

dbc · Accepted Answer · 2015-09-06 04:04:33Z

1

You can use SelectTokens and SelectToken for this purpose. They both support JsonPATH query syntax including wildcards:

        var o = JToken.Parse(result);
        var musicInfo = o.SelectTokens("metadata.music[0]")
            .Select(t => new
            {
                SongTitle = (string)t.SelectToken("title"),
                AlbumName = (string)t.SelectToken("album.name"),
                Artists = t.SelectTokens("artists[*].name").Select(n => (string)n).ToArray()
            })
            .FirstOrDefault();

Then

        Console.WriteLine(JsonConvert.SerializeObject(musicInfo, Formatting.Indented));

Prints

{
  "SongTitle": "Listen (From the Motion Picture \"Dreamgirls\")",
  "AlbumName": "B'Day Deluxe Edition",
  "Artists": [
    "Beyoncé"
  ]
}

which is what you want.

answered Sep 6, 2015 at 4:04

dbc

120k27 gold badges273 silver badges404 bronze badges

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

Collectives™ on Stack Overflow

JSON parsing C# get specific data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related