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
Mayank
06/27/2022, 1:54 PM
Are you upserting
xyz
from
null
to
abc
? Your description states it is being updated to null, so it is confusing.
v
Vuppala Suresh Kumar
06/28/2022, 3:29 AM
When I'm trying to update "xyz": "abc" to null it is not updating as "xyz": "null"
m
Mayank
06/28/2022, 3:46 AM
With partial upsert, nulls are not updated. You will need full upsert for this
v
Vuppala Suresh Kumar
06/28/2022, 5:13 AM
Can't we make to default value if the updated value is null?
m
Mayank
06/28/2022, 11:09 PM
That is how partial upsert works. It ignores the nulls. If you want to overwrite nulls, then you are looking for full upsert.