I am using Data flow activity from azure Data factory pipeline to insert some data in to the cosmos db, and stuck with an issue with having null values for a column in the Json, as the output is currently ignoring properties in the Json which has null values. Can we not store the null value in to json column, as I don't want to replace that with either empty or another value, as this will have more implications to further down the application.
Here is my preview of Data set
complete data flow
What do I need to do in order to retain the columns in the JSON which has null values