Transforming an array of name-value pairs in a JSON array with individual properties in the containing object

I'm trying to transform a JSON array to become object format.

Example:

{
  "country": "USA",
  "date": "2019-6-30",
  "Speaker": [
    {
      "id": "name",
      "value": "Tiger"
    },
    {
      "id": "age",
      "value": "35"
    },
    {
      "id": "topic",
      "value": ".NET"
    }
  ]
}

I want to convert this to:

{
  "country": "USA",
  "date": "2019-6-30",
  "name": "Tiger",
  "age": 35,
  "topic": ".NET"
}

I tried several ways, but had no luck. It seems I can't get the value of the internal array. Please help.

Solution

You can use Json.Net's LINQ-to-JSON API (JObjects) to transform your JSON:

JObject root = JObject.Parse(json);
JProperty arrayProp = root.Properties()
                          .Where(jp => jp.Value.Type == JTokenType.Array)
                          .FirstOrDefault();
if (arrayProp != null)
{
    foreach (JObject item in arrayProp.Value.Children<JObject>())
    {
        root[(string)item["id"]] = item["value"];
    }
    arrayProp.Remove();
}

json = root.ToString();

This solution does not depend on the array property having any particular name, nor does it care what the item ids are. However, if there are any ids in the array which overlap with an existing property in the root object, the value in the array will replace the one already in the root object. Similarly, if there are any duplicate ids in the array, the last one will "win".

Working demo: https://dotnetfiddle.net/p3WkqN