Hi, During insertion when passing value as null it...
# general
v
Hi, During insertion when passing value as null it is taking as default string value "null" but while updating its not reflecting@Mayank Eg: Insert: "xyz": null -------------> "xyz" : "null" Update: "xyz": "abc" to "xyz": null -------------------> No change (Expected: "xyz" : "null")
m
Are you upserting
xyz
from
null
to
abc
? Your description states it is being updated to null, so it is confusing.
v
When I'm trying to update "xyz": "abc" to null it is not updating as "xyz": "null"
m
With partial upsert, nulls are not updated. You will need full upsert for this
v
Can't we make to default value if the updated value is null?
m
That is how partial upsert works. It ignores the nulls. If you want to overwrite nulls, then you are looking for full upsert.