parse a string object to a JSONObject

Question

I need to parse a string that contains data of JSON file into a JSONObject and iterate over it's content to get it's keys and values for further treatement after. I'am stuck at parsing the content of a file after transforming it to a string. I tried to user parse() , quote() but it seems i'am missing a detail and i'am making a major mistake.

This is a snippet of the json file i treat :

{
    {
    "id":0,
    "name": "project1",
    "couverage": "100",
    "completness": "44.8",
    "consistency": "46",
    }
    
    {
    "id":1,
    "name": "project2",
    "couverage": "100",
    "completness": "44.8",
    "consistency": "46",
    }
    
    {
    "id":2,
    "name": "project3",
    "couverage": "100",
    "completness": "44.8",
    "consistency": "46",
    }
}

and this is the code i developed

public void readfromJsonFile(File jsonFile, long readTimeStamp) {
    logger.info("Read from JSON file:  {}", jsonFile.getName());
    
    try{
            
        //Read File Content
        String content = new String(Files.readAllBytes(jsonFile.toPath()));
        
        JSONParser jsonParser = new JSONParser(content);
        JSONObject obj = (JSONObject) jsonParser.parse();
        JSONArray key = obj.names();
        
        for (int i = 0; i < key.length (); ++i) {
            String keys = key.getString(i);
            System.out.println(keys);
            String value = obj.getString (keys);
            System.out.println(value);
    }catch (Exception e) {
            logger.error("Failed to parse JSON File: {}", jsonFile.getName());
        }
}

Can I show one example with Jackson ? Would you appreciate that ? — Anish B.
– Anish B., Commented Sep 16, 2020 at 15:17
Is this json even correct, I don't see square brackets depicting it's an array or list. I don't see commas between each inner json section to separate elements. And even consistency have a comma in end, that too is wrong. This cannot even be called a json :) — Himanshu Bhardwaj
– Himanshu Bhardwaj, Commented Sep 16, 2020 at 15:34

Anish B. · Accepted Answer · 2020-09-16 15:42:28Z

1

You can use Jackson Databind as well.

Create a POJO class. For example :

public class POJO {

   private int id;
   private String name;
   private String couverage;
   private String completness;
   private String consistency;

   // getters, setters and constructors

}

Modify the JSON in the file.

[
    {
    "id":0,
    "name": "project1",
    "couverage": "100",
    "completness": "44.8",
    "consistency": "46"
    },
    {
    "id":1,
    "name": "project2",
    "couverage": "100",
    "completness": "44.8",
    "consistency": "46"
    },
    {
    "id":2,
    "name": "project3",
    "couverage": "100",
    "completness": "44.8",
    "consistency": "46"
    }
]

Code :

public void readfromJsonFile(File jsonFile, long readTimeStamp) {
    logger.info("Read from JSON file:  {}", jsonFile.getName());
    try {
        ObjectMapper objectMapper = new ObjectMapper();
        POJO[] pojos = objectMapper.readValue(jsonFile, POJO[].class);
        for (int i = 0; i < pojos.length; ++i) {
            System.out.println(pojos[i].getId());
        }
    } catch (Exception e) {
            logger.error("Failed to parse JSON File: {}", jsonFile.getName());
    }
}

answered Sep 16, 2020 at 15:42

Anish B.

17.2k4 gold badges29 silver badges53 bronze badges

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

3 Comments

Anish B. Over a year ago

@NabilZouita Is this helpful ?

Nabil Zouita Over a year ago

I have a model that will read those values (consistency, coverage, ...) can I use the model or I have to create a class with the attributes of the Json file ?

Nabil Zouita Over a year ago

i spent some time testing but this was helpful thank you

Wowo Ot · Accepted Answer · 2020-09-16 15:12:21Z

0

Try it like this

JSONArray array_= new JSONArray(content);
JSONObject obj = (JSONObject) array_.get(0);// or any index

then you can use the Object.

answered Sep 16, 2020 at 15:12

Wowo Ot

1,5791 gold badge16 silver badges25 bronze badges

1 Comment

Nabil Zouita Over a year ago

still the same issue unfortunatly !

Collectives™ on Stack Overflow

parse a string object to a JSONObject

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related