Can't get Cosmos DB document in DESC order

Question

I have an API query to a Core (SQL) Cosmos DB collection that doesn't work, and I don't know why. I want to get the newest document in the collection by _ts., the JSON body is ...

{
"query": "SELECT * FROM MyData d ORDER BY d._ts DESC",
"parameters": []
}

Relevant Headers ...

x-ms-version:2018-12-31
x-ms-documentdb-isquery:true
Content-Type:application/query+json
x-ms-documentdb-query-enablecrosspartition:true
x-ms-max-item-count:1

It gets a single document as expected, but it is the first document as if I specified ASC instead of DESC.

I must be overlooking something very silly. please, someone embarrass me with an obvious fix.

Thanks,
Phil

Answer

Hi @Phil , thanks for reverting back with more information.

This looks like problem with 'Get' request. You need to change it to 'POST while using queries'

With 'POST' request, I was able to return the latest document as shown in below screenshot:

When I changed it to 'GET', I was getting the first record which is wrong:

Please let us know if you are able to get the proper response after making this change. We can discuss further if you still face the same issue.

Share via

Can't get Cosmos DB document in DESC order

1 answer

Your answer