Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to do recursive descent of json using json.net?

I am trying to parse a json file using json.net. The file looks like this

{X:
   {
      Title:"foo",
      xxxx:xxxx
   }
}
{Y:
   {ZZ:
        {Title: "bar",...}
    }
}

I am trying to recurse down this structure processing all objects with a Title attribute. But I am confused about JToken, JProperty, JContainer, JValue, JObject. Reading the source code has not left me much wiser and none of the samples help. I want something along the lines of

WalkNode(node, Action<Node> action)
{
    foreach(var child in node.Children)
    {
        Action(child);
        WalkNode(child);
    }
}

Parse()
{
   WalkNode(root, n=>
    {
        if(n["Title"] != null)
        {
           ...
        }
    });
}
like image 460
pm100 Avatar asked Apr 24 '13 00:04

pm100


4 Answers

The code below should be pretty close to what you are looking for. I made the assumption that there is an outer array, and that arrays can appear anywhere in the hierarchy. (If this is not true, you can simplify the WalkNode method code a bit, but it should work either way.)

using System;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace JsonRecursiveDescent
{
    class Program
    {
        static void Main(string[] args)
        {
            string json =
            @"[
                {
                    ""X"":
                    {
                        ""Title"":""foo"",
                        ""xxxx"":""xxxx""
                    }
                },
                {
                    ""Y"":
                    {
                        ""ZZ"":
                        {
                            ""Title"":""bar"",
                            ""xxxx"":""xxxx""
                        }
                    }
                }
            ]";

            JToken node = JToken.Parse(json);

            WalkNode(node, n =>
            {
                JToken token = n["Title"];
                if (token != null && token.Type == JTokenType.String)
                {
                    string title = token.Value<string>();
                    Console.WriteLine(title);
                }
            });
        }

        static void WalkNode(JToken node, Action<JObject> action)
        {
            if (node.Type == JTokenType.Object)
            {
                action((JObject)node);

                foreach (JProperty child in node.Children<JProperty>())
                {
                    WalkNode(child.Value, action);
                }
            }
            else if (node.Type == JTokenType.Array)
            {
                foreach (JToken child in node.Children())
                {
                    WalkNode(child, action);
                }
            }
        }

    }
}
like image 104
Brian Rogers Avatar answered Nov 03 '22 06:11

Brian Rogers


Also needed to do something of the sorts. Would like to propose my solution. It has the advantage of:

  • not being recursive
  • no callbacks
  • not assuming any internal structure (arrays)
  • decouples tree traversal from the action needed to be executed

    IEnumerable<JToken> AllTokens(JObject obj) {
        var toSearch = new Stack<JToken>(obj.Children());
        while (toSearch.Count > 0) {
            var inspected = toSearch.Pop();
            yield return inspected;
            foreach (var child in inspected) {
                toSearch.Push(child);
            }
        }
    }
    

    Then you can use linq to filter and perform action:

    var tokens = AllTokens(jsonObj);
    var titles = tokens.Where(t => t.Type == JTokenType.Property && ((JProperty)t).Name == "Title");
    
like image 37
TheRisingEdge Avatar answered Nov 03 '22 08:11

TheRisingEdge


I thought I'd include my minor tweaks to @BrianRogers WalkNode method, made it slightly more versatile:

private static void WalkNode(JToken node,
                                Action<JObject> objectAction = null,
                                Action<JProperty> propertyAction = null)
{
    if (node.Type == JTokenType.Object)
    {
        if (objectAction != null) objectAction((JObject) node);

        foreach (JProperty child in node.Children<JProperty>())
        {
            if (propertyAction != null) propertyAction(child);
            WalkNode(child.Value, objectAction, propertyAction);
        }
    }
    else if (node.Type == JTokenType.Array)
    {
        foreach (JToken child in node.Children())
        {
            WalkNode(child, objectAction, propertyAction);
        }
    }
}

Then OP could do something like:

WalkNode(json, null, prop =>
{
     if (prop.Name == "Title" && prop.Value.Type == JTokenType.String)
     {
         string title = prop.Value<string>();
         Console.WriteLine(title);
     }
});
like image 7
Thymine Avatar answered Nov 03 '22 08:11

Thymine


You could also do it with JSONPath: node.SelectTokens("$..*");

Used like this:

var jObjectsWithTitle = node
    .SelectTokens("$..*")
    .OfType<JObject>()
    .Where(x => x.Property("Title") != null);

Or just:

var jObjectsWithTitle = node.SelectTokens("$..[?(@.Title)]");
like image 7
asgerhallas Avatar answered Nov 03 '22 08:11

asgerhallas