Interpreting 'NULL' value behavior in Marketo database field | Community
Skip to main content
V
VidhiKh1
New Participant
June 22, 2023
Solved

Interpreting 'NULL' value behavior in Marketo database field

  • June 22, 2023
  • 1 reply
  • 1108 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

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.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
June 22, 2023

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.

Terms & ConditionsAccessibility statement

Loading footer...