Getting Nested query result from Cosmos DB with property named "Value"

3 votes

1 answer

2723 views

                          I have Cosmos Db collection, I am trying to query the "Key" "Value" pair from.
Working query:

    SELECT ed
    From c
    JOIN ed IN c.ExtendedData
    Where ed.Key = "MembershipTypeId"

And got result:

    [
        {
            "ed": {
                "Key": "MembershipTypeId",
                "Value": "224"
            }
        }
    ]

I need to filter by "Key" and "Value", but "Value" appears to be a reserved keyword
Not working query:

    SELECT ed
    From c
    JOIN ed IN c.ExtendedData
    Where ed.Value = "224"

Got HTTP 400 with message: Syntax error, incorrect syntax near 'Value'


                        

Asked by Kseniya Goloshchapova (61 rep)

Oct 3, 2019, 10:58 AM
Last activity: Jun 3, 2020, 08:03 PM

Getting Nested query result from Cosmos DB with property named "Value"

Related Questions