Fix Smart List queries that start with apostrophes

0 Likes

Fix Smart List queries that start with apostrophes

There are some good use cases for needing to query records that start with apostrophes: for example, a common list upload error that can occur involves improperly-formatted CSV files, resulting in records with email addresses like 'example@hotmail.com' instead of example@hotmail.com.

 

Currently, the Marketo platform doesn't properly return results for these queries because the character is improperly escaped. If you do a search for "Email Address: begins with ' ", you will return all non-empty email addresses. Attempting to use common SQL escape patterns (\', '') does not fix the problem. If this behavior could be fixed so the search correctly looks for apostrophes, it would be appreciated.

 

(I am aware there are other ways to retrieve this data and have done so; I just wanted to note this specific bug.)