Reading JSON Object Value in C# code

Question

Folks, I am trying to access a json value from Azure ML rest service but i get a null value all the time, i tried different options but it did not work. Can u please provide ideas.

Json String

{
    "Results": {
        "output1": {
            "type": "table",
            "value": {
                "ColumnNames": ["Sentiment",
                "Score"],
                "ColumnTypes": ["String",
                "Double"],
                "Values": [["negative",
                "0.20"],
                **["negative",
                "0.03"]**]
            }
        }
    }
}

Trying to fetch the value between **

Tried the below.

using Newtonsoft.Json.Linq;
JObject o = JObject.Parse(sentimentvalue);
string valv = (string)o.SelectToken("Results[0].output1[0].Values[0]");

You can deserialize with the following function... Newtonsoft.Json.JsonConvert.DeserializeObject — AntDC, Sep 05 '16 at 09:41
JObject.Parse(json)["Results"]["output1"]["value"]["Values"] — Amit Kumar Ghosh, Sep 05 '16 at 09:45
This worked for me: `string valv = (string)o.SelectToken("Results.output1.value.Values[0]");` — Bryan Woodford, Sep 05 '16 at 09:48

stefankmitph · Accepted Answer · 2016-09-05T10:19:10.060

2

Your JSON path in the SelectToken seems to be wrong. Try this:

string valv = (string)o.SelectToken("$.Results.output1.value.Values[0][1]");

edited Sep 05 '16 at 10:19

answered Sep 05 '16 at 09:38

stefankmitph

3,236
2
18
22

Thanks but how do i specifically access the below values. Now my consoleout looks like this ["negative","0.03"] – Sudheej Sep 05 '16 at 09:56
I think i found it.. string valv = (string)o.SelectToken("$.Results.output1.value.Values[0][1]").ToString(); – Sudheej Sep 05 '16 at 09:58
@xtechkid thanks mate! – stefankmitph Sep 05 '16 at 10:19

Reading JSON Object Value in C# code

1 Answers1