I defined a data extension which includes a decimal attribute whose Nullable
field is set to Yes
. While newly created records in this data extension have null values for this attribute it does not appear to be possible to set those decimal attribute back to null. The Contact Builder seems to discard such edits. API calls based on http://code.exacttarget.com/apis-sdks/soap-api/updating-a-data-extension-object-with-a-null-field-value.html which set other attributes to null successfully return an error:
<UpdateResponse xmlns=\"http://exacttarget.com/wsdl/partnerAPI\">
<Results xsi:type=\"DataExtensionUpdateResult\">
<StatusCode>Error</StatusCode>
<StatusMessage>Errors Occurred</StatusMessage>
<OrdinalID>0</OrdinalID>
<ErrorCode>2</ErrorCode>
<Object xsi:type=\"DataExtensionObject\">
<PartnerKey xsi:nil=\"true\" />
<ObjectID xsi:nil=\"true\" />
<CustomerKey>example</CustomerKey>
<Properties>
<Property xsi:type=\"NullAPIProperty\">
<Name>decimal_attr</Name>
</Property>
</Properties>
</Object>
<ErrorMessage/>
<ValueErrors>
<ValueError>
<Name>decimal_attr</Name>
<ErrorCode>70007</ErrorCode>
<ErrorMessage>The value for column [decimal_attr] is not a valid decimal. Parse error InvalidDecimal]</ErrorMessage>
</ValueError>
</ValueErrors>
</Results>
<RequestID>e27dac53-5941-4801-8be8-c2d30cec863a</RequestID>
<OverallStatus>Error</OverallStatus>
</UpdateResponse>
Is there something I am missing? Is there any way to set a decimal attribute to null?