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 ▴
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 ▴
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 ▴
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 ▴