Json.NET JSONPath query not returning expected results

by

Json.NET’s JSONPath parser allows the filter (script) expression [?( )] to query for nested properties inside child objects of the candidate array item(s). Thus

var test = json.SelectTokens(@"$.projects[?(@.client.code == 'DEF')].client");

returns, as desired, 

[
  {
    "code": "DEF",
    "name": "Client 2"
  }
]

Working .Net fiddle.

Upon experimentation it seems none of the JSONPath implementations at jsonpath.curiousconcept.com support this syntax, however it works correctly at jsonpath.com which uses https://github.com/ashphy/jsonpath-online-evaluator. The JSONPath proposal simply states that () is a script expression, using the underlying script engine which clearly leaves some room for interpretation as to whether and how this “should” work.

The filters used in the question apparently do not work with Json.NET because, as of version 10.0.3, it only officially supports applying filters to array items and not directly to objects — see Issue #1256: JSONPath scripts not executing correctly for objects for a discussion. (Though sometimes cunning workarounds can be found, for instance in this answer.) Using nested properties inside filters, however, seems to be intended to work (and does work).

More Related Contents:

  1. Cannot deserialize the JSON array (e.g. [1,2,3]) into type ‘ ‘ because type requires JSON object (e.g. {“name”:”value”}) to deserialize correctly
  2. Deserializing JSON to .NET object using Newtonsoft (or LINQ to JSON maybe?)
  3. Detect if deserialized object is missing a field with the JsonConvert class in Json.NET
  4. Json.net serialize/deserialize derived types?
  5. How can I deserialize a child object with dynamic (numeric) key names?
  6. JSON.net: how to deserialize without using the default constructor?
  7. Deserializing JSON when sometimes array and sometimes object
  8. Convert Json String to C# Object List
  9. Cannot deserialize the current JSON object (e.g. {“name”:”value”}) into type ‘System.Collections.Generic.List`1
  10. How to ignore JsonProperty(PropertyName = “someName”) when serializing json?
  11. Json.NET deserialize or serialize json string and map properties to different property names defined at runtime
  12. Deserializing JSON when key values are unknown
  13. Deserializing dates with dd/MM/yyyy format using Json.Net
  14. Deserializing JSON with unknown object names
  15. How to convert datatable to json string using json.net?
  16. How do I convert an escaped JSON string within a JSON object?
  17. JContainer, JObject, JToken and Linq confusion
  18. Replace part of a JSON with other (using a string token)
  19. Cannot deserialize the current JSON array (e.g. [1,2,3])
  20. How to return JSon object
  21. Repeated serialization and deserialization creates duplicate items
  22. How do you Add or Update a JProperty Value in a JObject
  23. Load multiple concatenated JSON objects from stream
  24. Parsing a JSON array using Json.Net
  25. Best ways to split a string with matching curly braces
  26. JSonNet boolean serialization
  27. How do I get formatted and indented JSON in .NET using C#?
  28. How to deserialize a property with a dash (“-”) in its name with NewtonSoft JsonConvert?
  29. Serializing/Deserializing Dictionary of objects with JSON.NET
  30. Generate JSON object with NewtonSoft in a single line

Leave a Comment