Question 109502 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Get a Json Element from a changing array

ok so I have the following json response that contains an array of details.

{
 "top":{
   "middle":[
     {
         "name": "name1".
         "values":[
            {
                "value": 123
            }
         ]
     },
     {
         "name": "name2".
         "values":[
            {
                "value": 456
            }
         ]
     }
   ]
  }
}

I can get the data using:

JObject data = JObject.Parse(JSONDATA);
var Name1 = (string)data["top"]["middle"][0]["name"];
var Value1 = (float)data["top"]["middle"][0]["values"][0]["value"];

However, the order in which the items appear in the array are random.
so I cant use the [0] and [1] to specify the first or second item.

i know i could still use this method and then work out if the name1 or name 2 was a match meaning i would know which value goes with each name. but it seems very long winded and i know there must be an easier way.

i have tried a few things like,

JToken mydata = data.SelectToken("$.top.middle[?(@.name == 'name1')]");

and i tried to get the index of the array based on the name value.

but i just cant get it right. any help would be greatly appreciated.

Tags:

2

Answers


  1. 0

    To get the value corresponding to a specific name, you can loop through the array and check each object’s name property until you find the one you’re looking for. Here’s an example implementation:

    JObject data = JObject.Parse(JSONDATA);
string nameToFind = "name1";
float value = -1;

JArray middleArray = (JArray)data["top"]["middle"];
foreach (JObject obj in middleArray)
{
    string name = (string)obj["name"];
    if (name == nameToFind)
    {
        value = (float)obj["values"][0]["value"];
        break;
    }
}

if (value != -1)
{
    Console.WriteLine($"The value for {nameToFind} is {value}");
}
else
{
    Console.WriteLine($"No object with name {nameToFind} was found.");
}

    This implementation uses a loop to iterate through each object in the middle array and checks if the name property matches the one we’re looking for. If it does, it retrieves the value property and breaks out of the loop. If it doesn’t find a matching object, it outputs a message indicating that no object was found.

    Note that this implementation assumes that there is only one object with the specified name in the middle array. If there could be multiple objects with the same name, you may need to modify the implementation to handle that scenario.

    Login or Signup to reply.
  2. 0

    I would rather to use Linq

        var jObj = JObject.Parse(json);

    int value = GetValueByName("name1", jObj) // 123

public int GetValueByName(string name, JObject jObj)
{
   return jObj["top"]["middle"]
         .Where(x => (string)x["name"] == name)
         .Select(x => (int)x["values"][0]["value"])
         .FirstOrDefault();
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search