String Function Examples

Contains String

https://h.api.crmls.org/RESO/OData/Property?$filter=contains(ListAgentHomePhone,'626')

{
  "@odata.context": "https://h.api.crmls.org/RESO/OData/$metadata#Property",
  "value": [
    {
      "@odata.etag": "W/\"MjAwMy0wNi0yN1QwOToxNDoyNi0wNzowMA==\"",
      "AccessibilityFeatures": null,
	  .
	  .
	  .
    "ZoningDescription": null
    }
  ],
  "@odata.nextLink": "https://h.api.crmls.org/RESO/OData/Property?$filter=contains(ListAgentHomePhone,'626')&$skip=100"
}



Starts With String

https://h.api.crmls.org/RESO/OData/Property?$filter=startswith(ListAgentHomePhone,'626')

Ends With String

https://h.api.crmls.org/RESO/OData/Property?$filter=endswith(ListAgentHomePhone,'1036')

To Lower Case

https://h.api.crmls.org/RESO/OData/Property?$filter=tolower(ListAgentLastName)+eq+'meyer'

To Upper Case

https://h.api.crmls.org/RESO/OData/Property?$filter=toupper(ListAgentLastName)+eq+'MEYER'