Getting keys and values from a list on a JSON String using BasicDBObject

Question

I have a String with a JSON that contains a list. Its something like this:

{
    "counts":[
        {"foo827138": 123124, "bar2918":312312, "something_else321-313":2321321},
        {"foo1231412": 4321, "bar1231515":123, "something_else3012931":7282},
        {"foo1210820": 1234, "bar10293810":3112, "something_else12094":1321}
    ]
}

After parsing it with BasicDBObject.parse():

DBObject doc = BasicDBObject.parse(jsonString);

How can I get the keys and values on counts list?

PS.: doc.get("counts") returns a BasicDBList object. I can only iterate over this with:

for (Object a : doc) {
    // Something
}

Object does not provide a get() method or something like. So I don't know how to get any of my key names and respective values.

when you reference BasicDBObject are you talking about the MongoDB instance of it? can you provide the code where you are calling parse()? — scigs
– scigs, Commented Apr 20, 2018 at 20:26
Yes, it is a MongoDB instance of it. I've edited the question providing the exact scenario. — Augusto Dias
– Augusto Dias, Commented Apr 20, 2018 at 20:50

arxakoulini · Accepted Answer · 2018-04-23 10:57:15Z

1

Document document = Document.parse(jsonString);
List<Document> countsArray = document.get("counts",List.class);
for (Document doc : countsArray){
    doc.keySet(); //keys
    doc.values(); //values
    for (Map.Entry entry : doc.entrySet()){
        // iterate over each pair
    }
}

answered Apr 23, 2018 at 10:57

arxakoulini

7237 silver badges24 bronze badges

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

Comments

Turan · Accepted Answer · 2018-04-20 20:29:07Z

0

Have you tried yourObject.get("keyname")

answered Apr 20, 2018 at 20:29

Turan

3022 silver badges9 bronze badges

1 Comment

Augusto Dias Over a year ago

The keys are randomic

Collectives™ on Stack Overflow

Getting keys and values from a list on a JSON String using BasicDBObject

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related