get https://{accountName}.{environment}.com.br/api/dataentities//search
Retrieve documents' information, while choosing which fields will be returned and filtering documents by specific fields.
Below you can see some query examples and learn more about each query parameter.
Query Examples
Simple filter
/dataentities/CL/[email protected]
Complex filter
/dataentities/CL/search?_where=(firstName=Jon OR lastName=Smith) OR (createdIn between 2001-01-01 AND 2016-01-01)
Date Range
/dataentities/CL/search?_where=createdIn between 2001-01-01 AND 2016-01-01
Range numeric fields
/dataentities/CL/search?_where=age between 18 AND 25
Partial filter
/dataentities/CL/search?firstName=*Maria*
Filter for null values
/dataentities/CL/search?_where=firstName is null
Filter for non-null values
/dataentities/CL/search?_where=firstName is not null
Filter for difference
/dataentities/CL/search?_where=firstName<>maria
Filter greater than or less than
/dataentities/CL/search?_where=number>5
/dataentities/CL/search?_where=date<2001-01-01