Null as a Last Name | Community
Skip to main content
DJ_Erraballi
New Participant
August 15, 2019
Solved

Null as a Last Name

  • August 15, 2019
  • 2 replies
  • 3870 views

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.
Best answer by SanfordWhiteman

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!).

2 replies

BlaneMM
New Participant
October 19, 2021

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

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
October 19, 2021

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!).

BlaneMM
New Participant
October 28, 2021

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!

SanfordWhiteman
New Participant
August 16, 2019

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.