how to extract field from JSON that return two string withing the same JSON

Question

I have JSON looks like this

{
    "description":
    {
        "html": "A remote code execution vulnerability exists in the way that the scripting engine handles objects in memory in Microsoft Edge. ...",
        "text": "<p>A remote code execution vulnerability exists in the way that the scripting engine handles objects in memory in Microsoft Edge. ...</p>"
    }
}

I extract the field description but it contains both html and text, while I'm only interesting in text field.

while (true)
{
    //Read
    BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(connection.getInputStream(), StandardCharsets.UTF_8));
    String lines = null;
    StringBuilder stringBuilder = new StringBuilder();
    while ((lines = bufferedReader.readLine()) != null)
    {
        stringBuilder.append(lines);
    }
    bufferedReader.close();
    result = stringBuilder.toString();

    JSONParser parser = new JSONParser();
    JSONObject json2 = (JSONObject) parser.parse(result);
    if(methodType == MethodType.Retrieve_Vulnerability_info)
    {
        String scan_vuln_title= json2.get("title").toString();
        String scan_vuln_severityScore = json2.get("severityScore").toString();
        String scan_vuln_publishe_date = json2.get("published").toString();
        String scan_vuln_description = json2.get("description").toString();
        splunkdata.getScan().getList_of_found_Vulnerabilties().get(Vulnerability_id).setSeverityScore(scan_vuln_severityScore);
        splunkdata.getScan().getList_of_found_Vulnerabilties().get(Vulnerability_id).setVulnerability_title(scan_vuln_title);
        splunkdata.getScan().getList_of_found_Vulnerabilties().get(Vulnerability_id).setPublished_date(scan_vuln_publishe_date);
        splunkdata.getScan().getList_of_found_Vulnerabilties().get(Vulnerability_id).setDescription(scan_vuln_description);
        System.out.print("\n Rapid7 : Successful GET, vulnerabilities info of : "+ scan_vuln_title + " were retrieved" );
    }

Is there a way how to extract text content only?

Well, since it is nested json something like json2.get("description").get("text") should do the trick (assuming json2 repesents a map, JsonObject etc.) - you might need to add some parsing and some null checks but I'll leave that for you. — Thomas
– Thomas, Commented Jun 21, 2019 at 12:41
What is the type of json2? There are many different JSON parsers/libraries which provide different API so answer will depend on what you are using. — Pshemo
– Pshemo, Commented Jun 21, 2019 at 12:43
I'm using SimpleJSON library, I have added the full code, I don't have the mond get("text") — user11338912
– user11338912, Commented Jun 21, 2019 at 12:48
Aside from main question: it seems that your text and html are flipped, since text contains <p>...</p> structure while html contains only "rendered" data. — Pshemo
– Pshemo, Commented Jun 21, 2019 at 12:51
this is returned from the Server side - I think they are flipped as well — user11338912
– user11338912, Commented Jun 21, 2019 at 12:56

Nikhil Anand · Accepted Answer · 2019-06-21 13:04:06Z

1

Instead of extracting to a String, extract the description as a JSON object.
so what your code would look like is this,

JSONObject json3 = json2.getJSONObject("description")

then,

String html = json3.get("html")
String text = json3.get("text")

Also, a quick reminder, I'm using org.json

Edit1: Since you are using simple.json

JSONObject json2 = (JSONObject) object.get("description");
String html = (String) json2.get("html");
String text = (String) json2.get("text");

edited Jun 21, 2019 at 13:04

answered Jun 21, 2019 at 12:50

Nikhil Anand

466 bronze badges

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

1 Comment

user11338912 Over a year ago

JSONObject json2 = (JSONObject) object.get("description"); , object is not known.

sitakant · Accepted Answer · 2019-06-21 12:54:14Z

0

The best way is to use JsonPath click here to know more with working example.

answered Jun 21, 2019 at 12:54

sitakant

1,9082 gold badges20 silver badges39 bronze badges

1 Comment

user11338912 Over a year ago

I don't want to use another library!

Collectives™ on Stack Overflow

how to extract field from JSON that return two string withing the same JSON

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related