Can you please have a look on the problems described below for API version 1.1.164.0.
Problem 1
The following request goes wrong:
api/contacts?$filter=contains(tolower(customFields/email2_email), 'tobias')
The error:
Syntax error at position 17 in 'contains(_email), 'tobias') '.
If I leave out the tolower (which I need!), I get an empty list back, which is incorrect. It should return my record because if I do this:
api/contacts?$filter=contains(tolower(fullName), 'tobias groeneveld')
I do get this back:
...
customFields {
...
"email2_email": "tobias@dejongegroeneveldjes.nl",
...
}
...
contains(tolower(fullName), 'tobias groeneveld')
Problem 2:
If I do the same kind of request for a field without an underscore in it, it also doesnt work but the resulting error is different:
api/contacts?$filter=contains(tolower(customFields/tav), 'tobias')
The error:
The 'tolower' function cannot be applied to an enumeration-typed argument. //the customFields/tav field is a normal character field!!
If I now leave out the tolower again, I do get a correct result.
Greetings,
ACT Certified Consultants
TendenZ
the Netherlands