Filter a query by matching strings. Note that string comparisons are case sensitive. There are also string functions to aid with string filters but will vary depending on MLS Provider (i.e. toupper(StreetName) eq...
https://api.bridgedataoutput.com/api/v2/OData/har/Member?$filter=toupper(MemberFirstName) eq 'ADAM' or MemberFirstName eq 'James'&$top=20
Zillow does not appear to accept toupper() function
Top ▴
filtering on fractions of a second requires the use of the function fractionalseconds()
https://api.bridgedataoutput.com/api/v2/OData/har/Property?$top=4&$filter=ListingContractDate gt 2017-01-01 and month(ListingContractDate) gt 5 and fractionalseconds(ModificationTimestamp) lt 33 and PropertyType eq 'Residential'&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,PublicRemarks
HAR: Cannot apply any filters on ModificationTimestamp (incompatible types)
Top ▴
The function now() will return the now time in UTC
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=ModificationTimestamp le now() and (PropertyType eq 'Residential')&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,ModificationTimestamp
HAR: Cannot apply any filters on ModificationTimestamp (incompatible types)
Top ▴
Filter on a string field value that starts with a certain value. This is case sensitive
https://api.bridgedataoutput.com/api/v2/OData/har/Member?$filter=startswith(MemberFirstName, 'Joh')&$select=MemberFirstName,MemberLastName,MemberStatus,ModificationTimestamp&$top=20
HAR does not support function startswith()
Top ▴
A geographic search from a point in the Data System. Note that the structure of a geospatial search can vary per MLS.Search. Pay attention to MLS Service metadata name for Type=”Edm.GeographyPoint”.
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=geo.distance(Coordinates, POINT(-95.436157 29.829612)) le 5&$top=10
HAR: geo.distance() does not work
Top ▴
Need a minimum of four points to search by a polygon. The first and last points must be the same and because you’re able to put ‘holes’ into your polygon, you’d need to wrap the coords in another set of parenthesis. Note that the structure of a...
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=(PropertyType eq 'Residential') and geo.intersects(Coordinates,POLYGON((-95.436157 29.829612,-95.472636 29.833111,-95.472467 29.866538,-95.429713 29.870111,-95.436157 29.829612)))&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate
HAR: geo.intersects() does not work
Top ▴