Iam having a cosmos db collection with documents, now what I want is when I create a new document in that collection (iam using .net document DB API), can I validate some values. E.g
My document has a field Name and I want that only Peter or John should be inserted. Does there exist a mechanism in cosmosdb so that I can do such validations or can I do them only from the application code?
Validating strings in cosmosdb collection
Viewed 904
3 Answers
MongoDb use JSON Schema to validate document on insert and update.
CosmosDb doesn't provide anything similar but,
CosmosDb provides Triggers cosmos-db/stored-procedures-triggers-udfs, azure-cosmosdb-js-server/samples/triggers/
One can use javascript-validator inside the trigger to validate the schema/document before inserting in the container.
I don't have a working example, but I am working on it.
Related