API LIBRARY
Collapse Sidebar Menu
Expand Drawer

Complex Query

As the Custom Properties resource has a json blob, one can write powerful queries to search the json content.
Example

Code Example

curl -X GET \
  'https://api-prod.corelogic.com/trestle/odata/CustomProperty?$filter=StandardStatus eq 'Closed' and CustomFields eq 'PetDeposit=[100 TO 300]' and (CustomFields eq 'Address=junipr~' or CustomFields eq 'Address=dr' )' \
  -H 'Authorization: Bearer [token]' \
  -H 'Postman-Token: [xyz]' \
  -H 'cache-control: no-cache'

Result

[This query will do a ranged query for 'PetDeposit', a fuzzy search and text search on the 'Address' field in the json blob]