JSONObject to Document

Question

Hi there i am new with mongodb and i want to convert JSONObject to Document and then store it to mongodb. Here is what i have coded.I get a service api in json.

CloseableHttpResponse response = httpClient.execute(get); HttpEntity entity = response.getEntity(); JSONObject Rat = new JSONObject(EntityUtils.toString(entity));

then i want to save this Rat to a mongodb as a document and then insert it to mongodb or to mysql so that i can display it later. I thought something like

Document doc = new Document(....); coll.insertOne(doc); /*where coll is MongoCollection<Document> coll = db.getCollection("rates"); */

but how to do the convertion from JSONObject to Document?

I also want to get some values from the Rat . I have already done this. But still thinking how to save JSONObject to mogno only. — user1577708
– user1577708, Commented Jan 26, 2016 at 21:04

metame · Accepted Answer · 2016-01-26 21:15:16Z

The MongoDB Java Driver provides the Document.parse(String json) method to get a Document instance from a JSON string. You will need to parse your JSON object back to a String like this:

Document doc = Document.parse( Rat.toString() );

And here's the docs for working with JSON in the MongoDB Java Driver.

metame · Accepted Answer · 2017-07-03 06:11:24Z

Just to help you. You can also do:

JSONObject rat = exRat.getJSONObject("fieldfromJson");String newrat = rat.toString();

Then you have to parse the field you want, and you have a string.

Collectives™ on Stack Overflow

JSONObject to Document

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related