http://stackoverflow.com/questions/40298859/linq-to-json-to-find-nearest-ancestor-than-contains-a-particular-property

CSharp · Console

/Program.cs

using System;
using System.Linq;
using Newtonsoft.Json.Linq;
					
public class Program
{
	public static void Main()
	{
        string json = @"
            {
              ""Data"": {
                ""SPECIAL"": ""QQ01"",
                ""AA"": ""QQ1"",
                ""BB"": ""QQ2"",
                ""Data"": [
                  {
                    ""SPECIAL"": ""QQ02"",
                    ""AA"": ""QQ3"",
                    ""BB"": ""QQ4"",
                    ""CC"": ""QQ5"",
                    ""Data"": [
                      {
                        ""SPECIAL"": ""QQ03"",
                        ""AA"": ""QQ6"",
                        ""CC"": ""QQ7"",
                        ""Data"": [
                          {
                            ""SPECIAL"": ""QQ04"",
                            ""AA"": ""QQ8"",
                            ""CC"": ""QQ9"",
                            ""Data"": [
                              {
                                ""SPECIAL"": ""QQ05"",
                                ""AA"": ""QQa"",
                                ""CC"": ""QQb"",
                                ""Data"": [
                                  {
                                    ""SPECIAL"": ""QQ06"",
                                    ""AA"": ""QQc"",
                                    ""CC"": ""QQd""
                                  }
                                ]
                              },
                              {
                                ""SPECIAL"": ""QQ07"",
                                ""AA"": ""QQe"",
                                ""CC"": ""QQf"",
                                ""DD"": ""QQg"",
                                ""Data"": [
                                  {
                                    ""SPECIAL"": ""QQ08"",
                                    ""AA"": ""QQh"",
                                    ""CC"": ""QQi"",
                                    ""Data"": [
                                      {
                                        ""SPECIAL"": ""QQ09"",
                                        ""AA"": ""QQj"",
                                        ""BB"": ""QQk"",
                                        ""CC"": ""QQl""
                                      }
                                    ]
                                  }
                                ]
                              }
                            ]
                          }
                        ]
                      }
                    ]
                  }
                ]
              }
            }";

		JObject jo = JObject.Parse(json);
		
		var props = jo.Descendants()
			.OfType<JProperty>()
			.Where(p => p.Name == "SPECIAL" && (string)p.Value == "QQ01")
			.Take(1)
			.Select(p => p.Parent)
			.SelectMany(o => o.Children<JProperty>())
			.Where(p => p.Value.Type == JTokenType.String)
			.ToList();
		
		foreach (JProperty prop in props)
		{
			Console.WriteLine(prop.Name + ": " + prop.Value);
		}
	}
}
;