Extracting a subset of attributes with JSONPath

json jsonpath
Spaffo picture Spaffo · Dec 12, 2014 · Viewed 23k times · Source

I have this JSON code:

{
    "A": {
        "AB": [{
            "ABA": "0",
            "ABB": "1",
            "ABC": "2"
        }]
    }
}

I need to use a JSONPath expression that returns that JSON with only ABA and ABC attributes. Something like:

{
    "A": {
        "AB": [{
            "ABA": "0",
            "ABC": "2"
        }]
    }
}

So far I manage to extract either one or all attributes. For example

$.A.AB[*]

or 

$.A.AB[*].ABA

Is there a way to extract only two?

Thanks

Answer

kalle picture kalle · Jan 12, 2015

This will work using the Jayway implementation (Java):

$.A.AB[*]['ABB', 'ABA']

and the result for your input would be:

[
   {
      "ABB" : "1",
      "ABA" : "0"
   }
]

You can Compare different providers here:

http://jsonpath.herokuapp.com/

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