So there doesn't seem to be an easy way around this, even trying to do the query directly in ArcMap.
What I ended up doing, since I am using this in a backend service anyway was to check if a single quote was in the request, create a substring up the index location of the single quote, do a LIKE request with a wildcard and from the results, find the one that matches the original request.
It would look something like this in .NET.
string m_search = search;
bool hasQuote = search.Contains("'");
if (hasQuote == true)
{
m_search = search.Substring(0, search.IndexOf("'"));
}
// do API request and get response
// string where = "where=FIELDNAME LIKE '" + m_search + "%'";
var features = response["features"];
List<object> list = new List<object>();
for (int i = 0; i < features.Length; i++)
{
var feat = features;
var attr = feat["attributes"];
if (attr["FIELDNAME"] == search)
{
list.Add(attr);
}
}
return list;
It seems to be working ok so far and not's noticeably slower in my current queries.
In case anyone else comes across this problem, that's how I figured it out.
