According to Official Marketing cloud site, https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/updating_a_data_extension_object_with_a_null_field_value.html
Its possible to use a property "NullAPIProperty" to update specific fields to null. However it doesnt' seem to be working while the same payload is being sent to SFMC connector. This seems not to be working in all the connector versions of marketing cloud.
Does anyone have a solution for this?
Connector Version : 3.2.8 - The fix is applied, now you should be able to update null values
Below is sample payload to send null values
[{
concreteClassType: 'DataExtensionObject',
name: 'XXXXXXXXX',
properties:
property:[
{
name: 'Id',
value: payload.Id
},
{
name: 'Name',
value: null
},
]
}]