Access nested JSON data with Newtonsoft Linq

Question

How can I access the value of url in the JSON string below?

JSON

{
    "id": "7453",
    "picture": {
        "data": {
            "is_silhouette": false,
            "url": "https:\/\/scontent.xx.fbcdn.net\/v\/t1.0-1\/p50x50\/gf6474hfff.jpg?oh=fy&oe=trtr"
        }
    }
}

Dim o As Newtonsoft.Json.Linq.JObject = Newtonsoft.Json.Linq.JObject.Parse(json)

I can access id like so:

o("id").ToString()

So I would expect the following would work for the url property, but I get an error:

Object reference not set to an instance of an object

o("picture.data.url").ToString()

o("picture")("data")("url") - it wont parse the string obj reference for you. its usually easier to work with when deserialized — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented May 2, 2017 at 15:26
it is also easier to see the hierarchy if you paste it into something like jsonlint.com — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented May 2, 2017 at 15:32

djangojazz · Accepted Answer · 2017-05-02 15:30:18Z

1

You could do it one at a time.

Dim pic = o("picture")("data")("url")

I also found out that you can also do another method in Newtonsoft.Json:

Dim pic = o.SelectToken("picture.data.url")

answered May 2, 2017 at 15:30

djangojazz

13.2k10 gold badges64 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

Access nested JSON data with Newtonsoft Linq

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