JAVA Json automatic parsing for specific value [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 7 years ago.

Improve this question

Note: This is org.json.simple

In the below examples, I always want the "weWantThis" value. For example, we have the Json:

Example1.

{
    "Header1": {
        "Basex": "ws",
        "Random": {
            "Something": "information"
        },
        "age": 22,
        "Type": "Apa",
        "correlation": "x",
        "weWantThis": "somethingHere"
    }
}

example 2.

{
    "Header1": {
        "useful": "yes",
        "code": 200,
        "creation": {
            "isValid": "yes",
            "date": 25,
            "items": [
                "pc"
            ],
            "weWantThis": "somethingHere"
        }
    }
}

So as you can see, the format of the Jsons is completely different, and could be even more different. The goal is to retrieve the value of "weWantThis", AUTOMATICALLY. i.e. all the other headers etc.. are unknown, other than "weWantThis" of course. If it is not even there, simply return null. So basically an automatic parsing needs to be done until "weWantThis" is found. No clue how to do this. Any help is appreciated. Thank you!

Recursive traversal of every node in the tree until you hit the property with the name "weWantThis" — bhspencer
– bhspencer, Commented Mar 6, 2018 at 19:14

Sashi · Accepted Answer · 2018-03-06 20:34:05Z

0

You can use the JSONPath library. It has support for wildcards and support for retrieving values of arbitrary keys by navigating through the json structure.

JSONPath

You can even try out your specific example here -

Try out JSONPath

Enter your desired JSON and then try this path -

$..weWantThis

Here is a concrete implementation -

import com.jayway.jsonpath.Configuration;
import com.jayway.jsonpath.JsonPath;
import com.jayway.jsonpath.Option;
import com.jayway.jsonpath.PathNotFoundException;

Object document = Configuration.defaultConfiguration().addOptions(Option.SUPPRESS_EXCEPTIONS).jsonProvider()
            .parse(<jsonString>);
String value = JsonPath.read(document, "$..weWantThis");

edited Mar 6, 2018 at 20:34

answered Mar 6, 2018 at 20:04

Sashi

2,47521 silver badges15 bronze badges

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

10 Comments

user6671584 Over a year ago

Yes i've heard of that before. Very interesting.. never approached it because I never really understood it/didn't work. Any tips on how to implement that?

Sashi Over a year ago

Added a concrete implementation

user6671584 Over a year ago

i get "java.lang.ClassCastException: net.minidev.json.JSONArray cannot be cast to java.base/java.lang.String" for some reason

Sashi Over a year ago

Not sure. Are you using JSONPath or some other library.

user6671584 Over a year ago

Yes, JSONPath . is This correct though: I have a JSONObject called jsonResponse.. Can I then do String jsonResponseString = jsonResponse.toString(); then do Object document = Configuration.defaultConfiguration().addOptions(Option.SUPPRESS_EXCEPTIONS).jsonProvider() .parse(jsonResponseString );

|

Archit Khosla · Accepted Answer · 2018-03-06 19:31:14Z

0

You would first need to load this string into an JSONObject

Something like:

JSONObject ob = new JSONObject(string_content)

Now you need to go through each key,value pairs. The value can be either a simple object (Boolean, String, int etc) or a JSONArray or JSONObject. In both the later cases you can recursively call the same function you just wrote on the value only. In the case of JSONArray you will have to iterate over each item in the array and call this function recursively.

You keep on doing this until you find key is "weWantThis"

To find all keys in a given JSONObject you could use the whats suggested here: https://stackoverflow.com/a/20419508/2649309

https://www.codevoila.com/post/65/java-json-tutorial-and-example-json-java-orgjson#toc_5

How to parse JSON in Java

answered Mar 6, 2018 at 19:31

Archit Khosla

999 bronze badges

1 Comment

bhspencer Over a year ago

I'll give you the upvote if you write the recursive function :)

Thom · Accepted Answer · 2018-03-06 19:55:13Z

0

From the JSON string, simply do indexOf("\"weWantThis\": ") and then parse out the next value. Why run it through a JSON parser when you're only looking for a literal without structure?

answered Mar 6, 2018 at 19:55

Thom

15.3k34 gold badges117 silver badges201 bronze badges

2 Comments

Archit Khosla Over a year ago

This approach is probably more efficient than mine but will work until "weWantThis" exists only as a key. If this instance is present in a value field then, you will just have to be mindful about it and handle it gracefully.

Thom Over a year ago

@ArchitKhosla That's why I included the colon. Should only appear with the keys unless someone also has a colon in the values, which seems unlikely, but yes, you'd need to know the data to be certain.

Collectives™ on Stack Overflow

JAVA Json automatic parsing for specific value [closed]

3 Answers 3

10 Comments

1 Comment

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

10 Comments

1 Comment

2 Comments

Linked

Related