Get keys in JSON

json jsonpath
Stefan picture Stefan · Sep 28, 2017 · Viewed 9.8k times · Source

I get the following JSON result from an external system:

{
  "key1": "val1",
  "key2": "val2",
  "key3": "val3"
}

Now I want to display all keys and all values by using JSONPath. So I am looking for something to get key1, key2 and key3 as a result. Additionally I would like to use the index of a property, e. g. $....[2].key to get "key3" etc. Is there a way to do something like this?

Answer

Viktor picture Viktor · Sep 12, 2018

I found that the tilda ~ symbol is able to retrieve the keys of the values it's called upon. So for your example a query like this:

$.*~

Returns this:

[
  "key1",
  "key2",
  "key3"
]

Another example, if we had a JSON document like this:

  {
  "key1": "val1",
  "key2": "val2",
  "key3": {
      "key31":"val31",
      "key32":"val32"
  }
}

A query like this:

$.key3.*~

Would return this:

[
  "key31",
  "key32"
]

It's important to note that these examples work on JSONPath.com and some other simulators/online tools, but on some they don't. It might come from the fact that I found out about the tilda(~) operator in the JSONPath plus documentation and not the official one.

Related questions

How to filter by string in JSONPath?

I have a JSON response from the Facebook API that looks like this: { "data": [ { "name": "Barack Obama", "category": "Politician", "id": "6815841748" }, { "name": "Barack Obama's Dead Fly", "category": "Public figure", "id": "92943557739" }] } I want to apply JSONPath to it to only return results …

Read More
Basic use of JSONPath in Java

I have JSON as a string and a JSONPath as a string. I'd like to query the JSON with the JSON path, getting the resulting JSON as a string. I gather that Jayway's json-path is the standard. The online API, …

Read More
Getting a single value from a JSON object using JSONPath

I have the following JSON and I need to get the plain name value using JSONPath: { "single" : { "id" : 1, "name" : "Item name" } } Expression that I used is $.single.name but I always get an array: [ "Item name" ] instead of a string …

Read More