How to pull specific data from json file?

Question

C++ / C#

Hello, I have this json file:

{
  "relationships_followers": [
    {
      "title": "",
      "media_list_data": [
        
      ],
      "string_list_data": [
        {
          "href": "https://www.instagram.com/20rozok02",
          "value": "20rozok02",
          "timestamp": 1607203051
        }
      ]
    },
    {
      "title": "",
      "media_list_data": [
        
      ],
      "string_list_data": [
        {
          "href": "https://www.instagram.com/ildar.yusupov.1990",
          "value": "ildar.yusupov.1990",
          "timestamp": 1606909478
        }
      ]
    },
    {
      "title": "",
      "media_list_data": [
        
      ],
      "string_list_data": [
        {
          "href": "https://www.instagram.com/aitmahan.ernur",
          "value": "aitmahan.ernur",
          "timestamp": 1589734471
        }
      ]
    },
    {
      "title": "",
      "media_list_data": [
        
      ],
      "string_list_data": [
        {
          "href": "https://www.instagram.com/blyagafarov",
          "value": "blyagafarov",
          "timestamp": 1586728175
        }
      ]
    }
  ]
}

How can I extract all the values ​​of the value variable from the json file?

Answer 1

One way (Linq2Json), using the Json.Net library , which edward_freedom wrote about in the comments.

var jsonPath = "data.json";
using StreamReader reader = File.OpenText(jsonPath);
var jToken = JToken.ReadFrom(new JsonTextReader(reader));
            
var values =
    jToken["relationships_followers"].Select(j =>
            j["string_list_data"][0]["value"].ToObject<string>())
    .ToArray();