CosmosDB: How can I return a query as a list of strings only?

Viewed 44

Ex, suppose I have:

[
    {
      "obj1": {
        "$t": 2,
        "$v": "valueA"
      },
      "obj2": {
        "$t": 2,
        "$v": "valueB"
      }
]

If I do something like SELECT Resources.obj2["$v"], it returns something like

   [
        {
          "$v": "valueB"
        }
   ]

How do I get it to return JUST the string value as an array? like:

   {
        
      "valueB"
        
   }

Thank you!

1 Answers

You would need to use

SELECT value Resources.obj2["$v"]
FROM c
Related