Selecting specific object with Json.NET (SelectToken)

Question

I'm new to Json.NET and try out using the SelectToken function.

My test JSON:

{
  "Root": {
    "aNode": {
      "bNode": {
        "cNode": {
          "id": "myID1"
        }
      },
      "cNode": {
        "id": "myID2"
      },
      "dNode": {
        "cNode": [
          {
            "id": "myID3"
          },
          {
            "id": "myID4"
          }
        ]
      }
    },
    "cNode": {
      "id": "myID5"
    }
  }
}

Now, I'm trying to use the following code for getting specific objects:

JObject obj = JsonConvert.DeserializeObject<JObject>(jsonTxt);

//Not found
var myID1 = obj.SelectToken("..cNode[?(@.id=='myID1')]");

//Not found
var myID2 = obj.SelectToken("..cNode[?(@.id=='myID2')]");

//Found
var myID3 = obj.SelectToken("..cNode[?(@.id=='myID3')]");

//Found
var myID4 = obj.SelectToken("..cNode[?(@.id=='myID4')]");

//Not found
var myID5 = obj.SelectToken("..cNode[?(@.id=='myID5')]");

Why do I get these (for me) strange results?

I think I should get in every case the cNode object with the specific ID, and not only myID3 and myID4. What's wrong here?

EZI · Accepted Answer · 2015-01-18 20:20:33Z

3

I am not sure what you really want to achieve but you can use Linq to get cNodes

var nodes = obj.Descendants()
                .OfType<JProperty>()
                .Where(p => p.Name == "id")
                .Select(p=>p.Parent)
                .ToList();

answered Jan 18, 2015 at 20:20

EZI

15.4k2 gold badges29 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maas Over a year ago

I want to get the cNode with a specific "id". Let's say "myID1". (p => p.Name == "id" && p.Value == "myID1") Thanks for the answer, but I would like to know the correct JPath.

Collectives™ on Stack Overflow

Selecting specific object with Json.NET (SelectToken)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related