How to update value in existing documents in container

Question

Is it possible to write a query on the website to update an existing document, or are update queries still only available via SQL API?

I'm attempting to do something along these lines:

Answer 1

Hi, @Aaron Manill Thanks for posting your question in the Microsoft Q&A forum.
It looks like you are using T-SQL. That’s the query language for SQL Server or Azure SQL Database.
Azure Cosmos DB SQL API only supports a dialect of the SQL query language and only for queries, not operations like INSERT or UPDATE.
To perform an operation, you would need to use the REST API or an SDK.
In the browser-based data explorer, you can use the Items pane to manually add or update items.
Please do refer this document here.
Regards
Geetha