How can I maintain custom order of properties in Azure Cosmos DB instead of alphabetical order?

Hi Harshit Gupta,

Greetings!

Cosmos DB does indeed sort properties alphabetically by default, which can be problematic for certain applications. Unfortunately, there isn't a direct way to prevent this behavior.

Here are a few approaches you can consider preserving the order of properties:

1. Using Arrays

Instead of storing properties as key-value pairs directly within the document, you can store them as an array of objects. Each object in the array can have a key and value property. This way, the order of elements in the array is preserved.

Example:

 {
     "properties": [
         {"Key": "value1"},
         {"Inside": "value2"}
     ]
 }

2. Custom Serialization

You can serialize your document into a string format that preserves the order of properties before storing it in Cosmos DB. When retrieving the document, you can deserialize it back into the original format.

Example:

 {
     "data": "{\"Key\":\"value1\",\"Inside\":\"value2\"}"
 }

I hope this information helps. Please do let us know if you have any further queries.

Hi Harshit Gupta,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.