Get Records with a query condition of like not returning all available results.

1

When I send a API JSON request of the following:

 

{“app”:“7”,“query”:“Text_EmailAddress like " sshadler “”,“fields”:[”$id",“Text_EmailAddress”,“Text_LastName”,“Text_FirstName”]} 

 

I get the following respond from the API, two successful finds:

 

{“records”:[{“Text_EmailAddress”:{“type”:“SINGLE_LINE_TEXT”,“value”:“sshadler@yahoo.com”},“Text_FirstName”:{“type”:“SINGLE_LINE_TEXT”,“value”:“Scott”},“Text_LastName”:{“type”:“SINGLE_LINE_TEXT”,“value”:“Shadler”},"$id":{“type”:"__ID__",“value”:“30”}},{“Text_EmailAddress”:{“type”:“SINGLE_LINE_TEXT”,“value”:“sshadler@rplaw.com”},“Text_FirstName”:{“type”:“SINGLE_LINE_TEXT”,“value”:“Scott”},“Text_LastName”:{“type”:“SINGLE_LINE_TEXT”,“value”:“Shadler”},"$id":{“type”:"__ID__",“value”:“21”}}],“totalCount”:null}

 

However, if I just remove one letter at the of the search string qualifier from sshadler to shadle , such as:

 

{“app”:“7”,“query”:“Text_EmailAddress like " sshadle “”,“fields”:[”$id",“Text_EmailAddress”,“Text_LastName”,“Text_FirstName”]}

 

I get no results:

 

{“records”:[],“totalCount”:null}