JSON.NET SelectToken with JSONPath

Question

I am trying to use JSON.NET SelectToken with JSONPath to select for example the value of longname (eee) where types is only ggg.

JSON snippet:

"results" : [
  {
     "components" : [
        {
           "longname" : "aaa",
           "shortname" : "bbb",
           "types" : [ "ccc", "ddd" ]
        },
        {
           "longname" : "eee",
           "shortname" : "fff",
           "types" : [ "ggg" ]
        }
     ]
  }]

I am unable to get the JSONPath syntax correct. I have tried the following which I think is close to the right solution but always returns null:

 o.SelectToken("results[0].components[?(@.types=='[ggg]')].longname")

I have referenced Querying JSON with SelectToken and # JSONPath - XPath for JSON with no joy.

musefan · Accepted Answer · 2017-12-22 16:52:31Z

2

Ok, so I learnt a bit about JSONPath and had a play around (using this), and I am not sure if this is the best solution, but it definitely works:

results[0].components[?(@.types.length==1&&@.types[0]=="ggg")].longname

Unfortunately I cannot seem to find any other information to suggest there is a more simple solution to this.

edited Dec 22, 2017 at 16:52

answered Dec 22, 2017 at 16:43

musefan

48.5k21 gold badges144 silver badges193 bronze badges

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

1 Comment

Barry Kaye Over a year ago

thanks - it appears from here that @.length on arrays isn't supported.

Collectives™ on Stack Overflow

JSON.NET SelectToken with JSONPath

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