Take the 2-minute tour ×

I have some json here, and I need to use JSONPath (with Pentaho) to parse it out, and give me the key and value. I have used $.. but that just returned the value with no keys, which is pretty much useless. Is there any way to get both the key and value?

        "avatar": "...",
        "name": "j@example.com",
        "email": "...",
        "id": 82
        "avatar": "...",
        "name": "admin@example.com",
        "email": "admin@example.com",
        "id": 81
share|improve this question

1 Answer 1

up vote 1 down vote accepted

Figured it out. Had to create one JSON input with $..* and another for each individual id I needed to parse out.

share|improve this answer

Your Answer


