JSON format for maintaining array sorting

Question

I need a JSON expert here or someone who knows JSON very well. I have the following JSON structure that I received from an API via http request. The API pre-sorts the data by itemDistance because I specified that in my query. When I receive the data and process it through JSONSerialization, I lose the ordering by itemDistance that the API did. This most likely because it's in dictionary format and it needs to be in an array. I am building an iOS application.

My question is: What exact change(s) need to be made to the structure of the JSON below for order of items by locationDistance to be maintained when I run it through JSONSerialization? I'm struggling with changing the format below so it is in an array. What type of brackets do I need to place and/or remove below and exactly where do they need to be positioned.

}
    "items": {
            "234683": {
                “itemID": "234683",
                “itemCategory": “B",
                "itemDistance": 8
            },
            "467528": {
                “itemID": "467528",
                “itemCategory": “B",
                "itemDistance": "10"

            },
            "417928": {
                “itemID": "417928",
                “itemCategory": “A",
                "itemDistance": "10"

            },

    …


    }
}

By the way, I tried adding square brackets around the list of items in "items" as shown below but that did not help or make a difference.

}
                "items": [{
                        "234683": {
                            “itemID": "234683",
                            “itemCategory": “B",
                            "itemDistance": 8
                        },
                        "467528": {
                            “itemID": "467528",
                            “itemCategory": “B",
                            "itemDistance": "10"

                        },
                        "417928": {
                            “itemID": "417928",
                            “itemCategory": “A",
                            "itemDistance": "10"

                        },

                …


                }]
}

I also did it like this, but this too did not make a difference. The order is still lost when running it through JSONSerialization.

}
        "items": [
                "234683": {
                    “itemID": "234683",
                    “itemCategory": “B",
                    "itemDistance": 8
                },
                "467528": {
                    “itemID": "467528",
                    “itemCategory": “B",
                    "itemDistance": "10"

                },
                "417928": {
                    “itemID": "417928",
                    “itemCategory": “A",
                    "itemDistance": "10"

                },

        …


        ]
}

Your second and third formats should have worked for you. Can you show the code you are using to access the JSON? — Paulw11, May 31 '17 at 23:07
What code would this be? Do you mean the code I'm sending to the server? — user4956810, May 31 '17 at 23:08
The only thing is the API will not change things so I have to manipulate the JSON myself, which I did, but it has to be simple changes like adding and removing brackets at the beginning and end. I can't remove the keys (items ID's) manually so how can I make it work with the keys (item ID's on the outside of each bracket). — user4956810, May 31 '17 at 23:19
If you can't change the API, then it may be simpler to just re-sort the array once you have built it. — Paulw11, May 31 '17 at 23:20

Paulw11 · Accepted Answer · 2017-05-31T23:23:42.873

You need the server to return an array of dictionaries, not a dictionary of dictionaries.

You want:

{
    "items": [{
            "itemID": "234683",
            "itemCategory": "B",
            "itemDistance": 8
        },
        {
            "itemID": "467528",
            "itemCategory": "B",
            "itemDistance": "10"

        },
        {
            "itemID": "417928",
            "itemCategory": "A",
            "itemDistance": "10"

        }
    ]
}

Or, if you can't change the API to remove the unnecessary dictionary, you can wrap each dictionary into another dictionary and then put those dictionaries into an array so that the order is preserved.

{
    "items": [{
            "234683": {
                "itemID": "234683",
                "itemCategory": "B",
                "itemDistance": 8
            }
        },
        {
            "467528": {
                "itemID": "467528",
                "itemCategory": "B",
                "itemDistance": "10"
            }
        }, {
            "417928": {
                "itemID": "417928",
                "itemCategory": "A",
                "itemDistance": "10"

            }
        }
    ]
}

The other option is to iterate over the dictionary keys, extracting each value dictionary into an array and then sort it in your app.

You might also want to find the programmer who created the server code and administer appropriate corrective action;

Lol...that's right! 5 days of stressing over this, trying to fix this JSON string..what a mess! This is very funny. I needed the laugh:) — user4956810, May 31 '17 at 23:29

JSON format for maintaining array sorting

1 Answers1