Skip to main content
DJ_Erraballi
Level 2
Aug 15, 2019 11:23 PM UTC
Solved

Null as a Last Name

Noticed that if you enter "Null" as a last name, you register that a last name was entered but store the actual value as a Null type. Like the name : "John Null", cannot be saved in Marketo. I am trying to figure out how that would be possible and whether there is something exploitable here. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
User Group Leader
Oct 19, 2021 9:07 PM UTC

Yikes, that means the last name now has that character and won’t match expected conditions.

The problem is there isn’t a way to both have a character (byte or series of bytes)... yet not have it... at the same time.

What you can do is temporarily set the value to something like “\“Null\““ (the escaped quotes are on purpose), then run the people through a webhook that sets the value to the true string “Null“ (it is an allowed value when the API sends it, so it’s not that Marketo doesn’t allow it as a last name, just that it’s hard to get it in there!).

4 replies

SanfordWhiteman
User Group Leader
User Group Leader
Aug 16, 2019 12:46 AM UTC

Marketo reserves the four-letter string "NULL", case-insensitive, as if it were the unquoted keyword NULL. This is known behavior.

"Exploitable", not really, just frustrating under clear circumstances.

Note all form-encoded values are character streams, so given Marketo form logic *something* had to be reserved as the "emptifier" value.

Translate
BlaneMM
Level 2
Oct 19, 2021 1:42 PM UTC

The workaround that I found was to add an empty character to the end of the last name.
https://emptycharacter.com/

Translate
SanfordWhiteman
User Group Leader
SanfordWhitemanUser Group LeaderAccepted solution
User Group Leader
Oct 19, 2021 9:07 PM UTC

Yikes, that means the last name now has that character and won’t match expected conditions.

The problem is there isn’t a way to both have a character (byte or series of bytes)... yet not have it... at the same time.

What you can do is temporarily set the value to something like “\“Null\““ (the escaped quotes are on purpose), then run the people through a webhook that sets the value to the true string “Null“ (it is an allowed value when the API sends it, so it’s not that Marketo doesn’t allow it as a last name, just that it’s hard to get it in there!).

Translate
BlaneMM
Level 2
Oct 28, 2021 2:05 PM UTC

Good point.  I like your solution and I can use Flowboost 😉 to write the correct name into the field. (After I figure out how to make the API call via Flowboost.)
Thanks!

Translate