C# Extract json array of objects using with Newtonsoft.Json

Question

How can i grab all tokens in a List<String> ?
Here is the json string :

{
    "error": null,
    "jsonrpc": "2.0",
    "id": 0,
    "result": {
        "paginator": null,
        "cat_count": {},
        "last_post_date": 386623075949839,
        "post_list": [
            {
                "hc": false,
                "p2": 4,
                "token": "LnARJZCmt"
            },
            {
                "hc": false,
                "p2": 4,
                "token": "BuD2oIs3N"
            },
            {
                "p2": 4,
                "token": "89NaBsAha",
                "hc": false,
            }
        ],
        "error": 0
    }
}

I am using Newtonsoft.Json
Here is what i tried :

    var obj = JObject.Parse(json);
    string next_search_val = (string)obj["result"]["last_post_date"];
    var tokens = obj["result"]["post_list"]["token"]; > Fix this line for me > I have error here

L.B · Accepted Answer · 2017-08-28 22:30:58Z

5

I would use

var tokens = JObject.Parse(json)
                .SelectTokens("$..token")
                .Select(x => (string)x)
                .ToList();

EDIT

Same thing without JsonPath

var tokens = JObject.Parse(json)
                .Descendants()
                .OfType<JProperty>()
                .Where(x => x.Name == "token")
                .Select(x => x.Value)
                .ToList();

EDIT 2

Closest thing to your attempt

var tokens = JObject.Parse(json)["result"]["post_list"]
                .Select(x => (string)x["token"])
                .ToList();

edited Aug 28, 2017 at 22:30

answered Aug 28, 2017 at 22:11

L.B

116k20 gold badges189 silver badges229 bronze badges

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

3 Comments

SilverLight Over a year ago

$.. > What is that mean?

L.B Over a year ago

@MoonLight Querying JSON with JSONPath

SilverLight Over a year ago

Appreciate it & Thanks.

Collectives™ on Stack Overflow

C# Extract json array of objects using with Newtonsoft.Json

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related