Parse JSON inside JSON attribute using JSONPath

Question

I have a JSON list where one of the attributes of each element happens to be a JSON itself. It comes from a poor design upfront, but here it is.

I want to query the distinct attributes inside the JSON string contained in the elements.

Here is an example, just one item. I hand-wrote the code, but believe me that is valid JSON in production by the way it's generated

[{
  "extraData": "{\"foo\":\"bar\"}"
}]

I would like to query for something like $.*.extraData.foo, but obviously such syntax does not work. I am using IntelliJ IDEA Jsonpath evaluator.

The syntax should be something like parse($.*.extraData).*.foo

This article suggests me that no such operator is available to parse a JSON inside a JSON

It has to be JSONPath only for data analysis purposes. In Java, I use Jackson to parse the extraData object as a JsonNode, but my goal is to explore the large data set, and perhaps obtain some distinct values I want to use for enumeration purposes.

gregsdennis · Accepted Answer · 2021-11-25 21:36:21Z

1

To JSON Path, the embedded JSON is just a string. The best you could do with a single operation is use a RegEx in the expression selector, but getting RegEx to identify JSON is really tricky, and that's if your implementation even supports RegEx.

I think the best option would be to use two paths:

The first path gets the embedded JSON. $.*.extraData
Parse that value
The second part gets the data you need. $.foo

This requires some extra code, but I think it's your only realistic option.

answered Nov 25, 2021 at 21:36

gregsdennis

8,5206 gold badges43 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Parse JSON inside JSON attribute using JSONPath

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related