Accessing property from Json Array

Question

I have following array:

{
   "customizedData":[
      {
         "key":"SubscriptionId",
         "value":"xxxxxxxxxxxxxxxx"
      },
      {
         "key":"OfferId",
         "value":"xxxxxxxxxxxxxx"
      },
      {
         "key":"SubscriptionName",
         "value":"DYNAMICS 365 BUSINESS CENTRAL TEAM MEMBER"
      },
      {
         "key":"Quantity",
         "value":"6"
      },
      {
         "key":"Status",
         "value":"Suspended"
      },
      {
         "key":"PartnerOnRecord",
         "value":"None"
      }
   ]
}

How do I access key the elements:

"key": "SubscriptionName",
"value": "DYNAMICS 365 BUSINESS CENTRAL TEAM MEMBER"

At the moment I use: (string)t["customizedData"][2]["value"]

Are there any better ways?

What library do you use to work with json? Is it Json.NET? Add tag please. — Alexander Petrov
– Alexander Petrov, Commented Dec 15, 2020 at 12:49
Is deserializing to a strong type like public partial class KeyValueThing { [J("customizedData")] public List<CustomizedDatum> CustomizedData { get; set; } } public partial class CustomizedDatum { [J("key")] public string Key { get; set; } [J("value")] public string Value { get; set; } } and simply filtering like KeyValueThing.CustomizedData.FirstOrDefault(x=> x.Key=="MyKey") viable? — xdtTransform
– xdtTransform, Commented Dec 15, 2020 at 15:01

Selim Yildiz · Accepted Answer · 2020-12-16 08:14:30Z

1

Assuming you are using Json.net and you don't want to create strong type for it so you can use SelectToken with JSONPath:

t.SelectToken("$.customizedData[?(@.key == 'SubscriptionName')].value").ToString();

edited Dec 16, 2020 at 8:14

answered Dec 16, 2020 at 8:07

Selim Yildiz

5,3906 gold badges22 silver badges34 bronze badges

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

Comments

Alenros · Accepted Answer · 2020-12-18 08:02:33Z

1

If you are using the Newtonsoft.Json nuget this could be done with a helper function. first use var jo = JObject.Parse(jsonContent); to parse, and pass that to the helper function GetValueFromJson(jo, "SubscriptionName", "customizedData"), using this helper function:

    private string GetValueFromJson(JObject jo, string key, string rootKey)
    {
        var value = jo[rootKey].Children()
                                        .Where(i => i["key"].ToString() == key)
                                        .Select(i => i["value"].ToString())
                                        .FirstOrDefault();
        return value;
    }

edited Dec 18, 2020 at 8:02

answered Dec 16, 2020 at 13:04

Alenros

1,00512 silver badges25 bronze badges

1 Comment

Brian Rogers Over a year ago

This isn't bad, but I think it would be better to pass in the JObject as the first parameter. Otherwise if you want to use the method multiple times on the same JSON for different keys you end up re-parsing the JSON each time. Better to parse once and then extract, extract, extract.

Collectives™ on Stack Overflow

Accessing property from Json Array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related