Sorting a JSON Object/String on basis of keys

Question

Straight and simple, following is a sample Json:

{
    "2014-05-27": 292,
    "2014-05-06": 323,
    "2014-05-21": 212,
    "2014-05-22": 238,
    "2014-05-23": 219
}

As clearly visible the keys are the dates and values are some counter. I need to sort this JSON on basis of dates. I am programming in java and using Jackson library if that helps.

What do you mean ? You want to have a JSON string with the lines written in the alpha order of the keys ? — Denys Séguret
– Denys Séguret, Commented Jun 5, 2014 at 15:31
Json doesn't have an order. Parse the JSON, generate your application model objects, and sort those. Also, that is a JSON object, not an array. — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Jun 5, 2014 at 15:31
Yeah so I can convert it to a Map and then sort the Map? Is that what you're suggesting? — Sambhav Sharma
– Sambhav Sharma, Commented Jun 5, 2014 at 15:33

Willem Mulder · Accepted Answer · 2014-06-05 15:37:57Z

3

You could convert that JSON to a Map, then sort that Map, and then convert it back to JSON.

answered Jun 5, 2014 at 15:37

Willem Mulder

14.1k4 gold badges41 silver badges64 bronze badges

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

Comments

Sam Berry · Accepted Answer · 2014-06-05 15:45:44Z

According to the JSON spec:

An object is an unordered set of name/value pairs.

and

An array is an ordered collection of values.

If you wanted to do the sorting in your Java code, you could sort them by date into a list and pass the list back in your response. Jackson will do the work of converting the list into an array and preserving the order. This approach would require you to convert your key:values to objects. The objects that populate your array would look similar to this:

{
    "date": "2014-05-27",
    "value": 292
}

You will retain ordering guarantees by using an array. Using an object you have no guarantees.

Collectives™ on Stack Overflow

Sorting a JSON Object/String on basis of keys

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related