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/mlspin/Properties?$filter=ListingContractDate lt 2016-12-31 and fractionalseconds(ModificationTimestamp) lt 30 and (PropertyType has PropertyEnums.PropertyType'Residential')&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,ListingContractDate,ModificationTimestamp
HAR: Cannot apply any filters on ModificationTimestamp (incompatible types)
Top ▴
filtering on fractions of a second requires the use of the function fractionalseconds()
https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,PublicRemarks&$filter=year(ListingContractDate) eq 2017 and month(ListingContractDate) eq 5 and day(ListingContractDate) eq 31 and hour(ModificationTimestamp) gt 13 and minute(ModificationTimestamp) gt 3 and fractionalseconds(ModificationTimestamp) lt 33 and PropertyType eq 'Residential'
HAR: This function may not work with ModificationTimestamp (incompatible types)
Top ▴
The function now() will return the now time in UTC
https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=ModificationTimestamp le now()&$top=10
HAR: Cannot apply any filters on ModificationTimestamp (incompatible types)
Top ▴
filtering on fractions of a second requires the use of the function fractionalseconds()
https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=4&$filter=year(ListingContractDate) eq 2017 and month(ListingContractDate) eq 5 and day(ListingContractDate) eq 31 and hour(ModificationTimestamp) gt 13 and minute(ModificationTimestamp) gt 3 and fractionalseconds(ModificationTimestamp) lt 33 and PropertyType eq 'Residential'&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,ListingContractDate,ModificationTimestamp
HAR: This function may not work with ModificationTimestamp (incompatible types)
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/mlspin/Member?$filter=startswith(MemberFirstName, 'Joh')&$select=MemberFirstName,MemberLastName,MemberStatus,ModificationTimestamp&$top=20
FBS does not recognize startswith(). Getting ‘Resource not found.’ error
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/mlspin/Properties?$filter=geo.distance(Coordinates, POINT(-71.106631 42.388223)) le 3&$top=10
MLSPIN: Geo searches are not working
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/mlspin/Properties?$filter=(PropertyType has PropertyEnums.PropertyType'Residential') and geo.intersects(Coordinates,POLYGON((-71.106631 42.388223,-71.132453 42.388694,-71.140783 42.412775,-71.106858 42.412863)))&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent
MLSPIN: Geosearches are not working
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 ▴