'Cosmos DB "Partial Update"/Patch, cant set new property value to null

I'm trying out the Cosmos DB SDK's new Patch/Partial Update-functionality (for .NET)

When adding a new property I use

 var patchOperations = new List<PatchOperation>(){
       PatchOperation.Add<string>("/FavoriteColor", **null**)
 };


 await container.PatchItemAsync<T>(
                          id: myId,
                          partitionKey: new PartitionKey(myPk),
                          patchOperations: patchOperations);

The problem is, that it throws at the PatchOperation-Add() if I set second parameter to null (with message "Value cannot be null"). I can set any non-null string and it works well. I just wonder if this isn't supported yet or if I missed something.

asp.net-core azure-cosmosdb

Solution 1:^[1]

Thanks to github user rvdvelden (source), this work around appears to work perfectly:

private JToken NullValue { get { return new JProperty("nullValue", null).Value; } }

Used in this way:

operations.Add(PatchOperation.Set("\customer", value ?? NullValue));

Solution 2:^[2]

Remove is one alternative if the intent is to remove field/property.

Solution 3:^[3]

This is not supported with Patch yet,

However, if you want to remove the entire property you need to use Remove Operation

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Josh Mc
Solution 2	Kiran Kolli
Solution 3	Sajeetharan

'Cosmos DB "Partial Update"/Patch, cant set new property value to null

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]

Solution 3:^[3]