Append a json object to another json object java

Question

I have a two json objects

JSONObject org_query = new JSONObject("{\"query\": {\"bool\": {\"must\": [], \"must_not\": [], \"should\": []}}}");

JSONObject query_form = new JSONObject("{\"match_phrase\": {\"Sales Channel\": \"Online\"}}");

I want to append the second object to first one inside the key must and form a new JSON object.

Required Output:

{"query":{"bool":{"must_not":[],"should":[],"must":[{"match_phrase": {"Sales Channel": "Online"}}]}}}

I tried this,

org_query["query"]["bool"]["must"].append(query_form);

But shows error.

array type expected found org.json.jsonarray java

How to make it

Looks like elasticsearch queries... Why not use their Java sdk? — OneCricketeer
– OneCricketeer, Commented Feb 14, 2020 at 15:18

Jagadesh · Accepted Answer · 2020-02-14 18:12:34Z

1

In this case you can do:

org_query = org_query.put("query", org_query.getJSONObject("query").put("bool", org_query.getJSONObject("query").getJSONObject("bool").append("must", query_form)));

edited Feb 14, 2020 at 18:12

Jagadesh

2,1162 gold badges20 silver badges32 bronze badges

answered Feb 14, 2020 at 15:06

Nuno

1316 bronze badges

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

Comments

narduw · Accepted Answer · 2020-02-14 13:19:38Z

0

Not really sure which API you're using but a quick search on Google yielded this result:

The .append method is for adding values into an array.

Try using .put method. This is for adding values to a property by key.

Reference: https://docs.oracle.com/middleware/maf242/mobile/api-ref/oracle/adfmf/json/JSONObject.html

For more examples, see this other answer: https://stackoverflow.com/a/30006004/7119882

answered Feb 14, 2020 at 13:19

narduw

721 silver badge8 bronze badges

1 Comment

Paul Steven Over a year ago

Thanks... I found that... org_query.getJSONObject("query").getJSONObject("bool").getJSONArray("must").put(query_form);

Anton Straka · Accepted Answer · 2020-02-16 13:25:15Z

0

You can use small json library

JsonValue org_query = JsonParser.parse("{\"query\": {\"bool\": {\"must\": [], \"must_not\": [], \"should\": []}}}");
JsonValue query_form = JsonParser.parse("{\"match_phrase\": {\"Sales Channel\": \"Online\"}}");
JsonValue must = org_query.findFirst(SPM.path("query", "bool", "must"));
must.asArray().add(query_form);
String result = org_query.toCompactString();

edited Feb 16, 2020 at 13:25

answered Feb 16, 2020 at 13:12

Anton Straka

1392 bronze badges

Collectives™ on Stack Overflow

Append a json object to another json object java

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related