Zoho Creator Api V2 - How to phrase muliple "does not equal" criteria in the request
I have a data source where I want to return everything except records containing two specific codes. The field "customer_tlr" is a single line box - not a dropdown or multiple select. I have tried the following :
These only exclude the first value
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=customer_tlr!="ABC"&customer_tlr!="DEF"
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=customer_tlr!="ABC"&&customer_tlr!="DEF"
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=(customer_tlr!="ABC")or(customer_tlr!="DEF")
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=(customer_tlr!="ABC")and(customer_tlr!="DEF")
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=(customer_tlr!="ABC")&&(customer_tlr!="DEF")
These return errors
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=customer_tlr!="ABC"||customer_tlr!="DEF"
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=customer_tlr!={"ABC","DEF"}
app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=customer_tlr!=("ABC","DEF")