Forum Discussion
Derived json with null property value
I am constructing a json object, and I want all properties to exist, even if the source value was null. Is this possible, or am I simply going about it incorrectly? Here is my data mapping expre...
We get this behavior in the Copy Activity, at least when the source is SQL and the sink is JSON.
Fundamentally, I want something similar to the INCLUDE_NULL_VALUES option for SQL referenced https://docs.microsoft.com/en-us/sql/relational-databases/json/include-null-values-in-json-include-null-values-option?view=sql-server-ver15.