How can i sort my JSON object based on Key?

Question

I am creating a JSON object in which i am adding a key and a value which is an array. The value for both key and value comes from a TreeSet which has data in sorted form. However, when I insert data in my json object, it is stored randomly without any order. This is my json object currently:

{
    "SPAIN":["SPAIN","this"],
    "TAIWAN":["TAIWAN","this"],
    "NORWAY":["NORWAY","this"],
    "LATIN_AMERICA":["LATIN_AMERICA","this"]
}

and my code is:

 Iterator<String> it= MyTreeSet.iterator();

        while (it.hasNext()) {
            String country = it.next();
            System.out.println("----country"+country);
            JSONArray jsonArray = new JSONArray();
            jsonArray.put(country);
            jsonArray.put("this);

            jsonObj.put(country, jsonArray);
        }

Is there any way I can store the data into my json object inside the while loop itself?

A standard JSON object is a set of unordered key/value pairs. It cannot be "sorted". — Hot Licks
– Hot Licks, Commented Oct 21, 2013 at 11:36
BTW, your illustration does not match your code. Your illustration contains only objects, no arrays. — Hot Licks
– Hot Licks, Commented Oct 21, 2013 at 11:37

Christian · Accepted Answer · 2015-08-27 09:45:34Z

Even if this post is quite old, I thought it is worth posting an alternative without GSON:

First store your keys in an ArrayList, then sort it and loop through the ArrayList of keys:

Iterator<String> it= MyTreeSet.iterator();
ArrayList<String>keys = new ArrayList();

while (it.hasNext()) {
    keys.add(it.next());
}
Collections.sort(keys);
for (int i = 0; i < keys.size(); i++) {
    String country = keys.get(i);
    System.out.println("----country"+country);
    JSONArray jsonArray = new JSONArray();
    jsonArray.put(country);
    jsonArray.put("this");

    jsonObj.put(country, jsonArray);
}

user748316 · Accepted Answer · 2013-10-21 12:04:57Z

It works with Google Gson API. Try it out.

    try{

        TreeSet<String> MyTreeSet = new TreeSet<String>();
        MyTreeSet.add("SPAIN");
        MyTreeSet.add("TAIWNA");
        MyTreeSet.add("INDIA");
        MyTreeSet.add("JAPAN");

        System.out.println(MyTreeSet);
        Iterator<String> it= MyTreeSet.iterator();
        JsonObject gsonObj = new JsonObject();
        JSONObject jsonObj = new JSONObject();
        while (it.hasNext()) {
            String country = it.next();
            System.out.println("----country"+country);
            JSONArray jsonArray = new JSONArray();
            jsonArray.put(country);
            jsonArray.put("this");

            jsonObj.put(country, jsonArray);

            JsonArray gsonArray = new JsonArray();

            gsonArray.add(new JsonPrimitive("country"));
            gsonArray.add(new JsonPrimitive("this"));
            gsonObj.add(country, gsonArray);
        }
        System.out.println(gsonObj.toString());
        System.out.println(jsonObj.toString());




    } catch (JSONException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

Thanks alot buddy. It worked really well and got what I expected... :)

deepSleep · Accepted Answer · 2013-10-21 12:48:19Z

0

Below are what the doc says from http://www.json.org/java/index.html.

"A JSONObject is an unordered collection of name/value pairs."

"A JSONArray is an ordered sequence of values. "

In order to get an sorted Json Object, you can use Gson which is already provided a good answer by @user748316.

answered Oct 21, 2013 at 12:48

deepSleep

451 bronze badge

1 Comment

Mohd Naved Over a year ago

This answer does not give any useful information regarding to question.

Collectives™ on Stack Overflow

How can i sort my JSON object based on Key?

3 Answers 3

Comments

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Linked

Related