Interpreting 'NULL' value behavior in Marketo database field

[Vidhi]

Hey everyone,

I have a quick question regarding 'NULL', 'Null' & 'null'. If we have a String data type field called 'Mobile Number' in our Marketo database.

And we are expecting a sync of that data from the CRM system. Can we ask them to push NULL in the Marketo field from CRM in case of empty values in the database for the users who used to have a mobile number value? 

Will that allow us to see blank or empty in the 'Mobile Number' field if the user has deleted the 'Mobile number' or will that appear as NULL in the Mobile Number Field on the next data load? 

Kind Regards,

Vidhi

[SanfordWhiteman · Accepted solution]

No, the 4-letter string NULL is not relevant outside of forms and the Marketo UI. If you have a custom integration, they should pass the literal JSON value null or an empty string.