Getting values from array in Cosmos Db

Question

My document that I save in Cosmos DB looks like this:

{
   "id": "abc123",
   "myProperty": [
      "1905844b-6ca9-4967-ba40-a736b685ca62",
      "b03cc85c-ef0b-4f48-9c31-800de089190a"
   ]
}

As you can see, in the myProperty property, I have an array of GUID values and I want to read them as an array/list of GUID values but I'm having trouble formulating the correct SELECT statement.

The output I'm looking for is:

[
   "1905844b-6ca9-4967-ba40-a736b685ca62",
   "b03cc85c-ef0b-4f48-9c31-800de089190a"
]

The closest I could get is this `SELECT statement:

SELECT VALUE c.myProperty FROM c WHERE c.id = "abc123"

But this doesn't give me exactly what I want either. This gives me an array within an array i.e.

[
   [
      "1905844b-6ca9-4967-ba40-a736b685ca62",
      "b03cc85c-ef0b-4f48-9c31-800de089190a"
   ]
]

What should my SELECT statement look like to get what I want?

4c74356b41 4c74356b41 · Accepted Answer · 2019-06-30T18:52:36

I dont think you can ever get anything else, because cosmos db will always return an array in response to a query because potentially there can be 0-infinity results. so you will always get a top level array that will wrap all your results (even if you have only one)

Getting values from array in Cosmos Db

1 Answers