Skip to content


How do I write a NULL value into CRM whole number field as a NULL value?

steve asked 7 years ago
how do you import record into CRM where the mapped attribute that’s an Int (Whole Number Field) may or may not contain data.
I need to bring in all my records whether the whole number field is present or not.
Patrick Roth Staff answered 7 years ago
Currently SC doesn’t give us the ability to insert NULLS into CRM or any other destination. 
The only workaround is to put in a value into the field (like 0) and then a CRM Workflow that would take that value and switch 0 to NULL.

If you would like to submit an answer or comment, please sign in to the eOne portal.