All names in the $filter option are case sensitive and must match the names of elements provided by the metadata resource. Values are also case sensitive.
https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=BedroomsTotal lt 5 and (City eq 'Boston') and (PropertyType has PropertyEnums.PropertyType'Residential')&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,BedroomsTotal
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-prod.corelogic.com/trestle/odata/Member?$filter=(MemberFirstName eq 'James' or toupper(MemberFirstName) eq 'ADAM') and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=20
Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions.
https://api-prod.corelogic.com/trestle/odata/Property?$filter=BedroomsTotal eq 3 or (BedroomsTotal eq 4 and InternetAddressDisplayYN eq true) and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency
All names in the $filter option are case sensitive and must match the names of elements provided by the metadata resource. Values are also case sensitive.
https://api-prod.corelogic.com/trestle/odata/Property?$filter=BedroomsTotal eq 3 and (City eq 'Miami') and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency
Filter results by a boolean field (true or false). Note, do not treat the value true or false as a string.
https://api-prod.corelogic.com/trestle/odata/Property?$filter=InternetAddressDisplayYN eq true and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency,InternetAddressDisplayYN
not equal (ne) is used as to counter equal (eq)
https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=BedroomsTotal ne 33&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent
Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions.
https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=BedroomsTotal lt 5 or (BedroomsTotal eq 4 and IDXParticipationYN eq true)&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent
A boolean ‘Not’ must enclose its operands in a parenthesis with not as an operator i.e. not(City eq ‘Elkwood’).
https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=not(BedroomsTotal le 3) and (City eq 'Boston')&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,BedroomsTotal&$top=10
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/mlspin/Member?$filter=(MemberFirstName eq 'James' or toupper(MemberFirstName) eq 'Adam')&$top=20
Filter results by a boolean field (true or false). Note, do not treat the value true or false as a string.
https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=IDXParticipationYN eq true&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,IDXParticipationYN
not equal (ne) is used as to counter equal (eq)
https://api-prod.corelogic.com/trestle/odata/Property?$filter=BedroomsTotal ne 3 and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency
not equal (ne) is used as to counter equal (eq)
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=BedroomsTotal ne -1&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate
Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions.
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=BedroomsTotal lt 15 or (BedroomsTotal eq 4 and InternetConsumerCommentYN eq true)&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate
A boolean ‘Not’ must enclose its operands in a parenthesis with not as an operator i.e. not(City eq ‘Elkwood’).
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=not(BedroomsTotal le 3) and (PropertyType eq 'Residential')&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,BedroomsTotal&$top=10
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
Filter results by a boolean field (true or false). Note, do not treat the value true or false as a string.
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=InternetConsumerCommentYN eq true&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,InternetConsumerCommentYN
All names in the $filter option are case sensitive and must match the names of elements provided by the metadata resource. Values are also case sensitive.
https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=BedroomsTotal lt 15 and (City eq 'Houston') and (PropertyType eq 'Residential')&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,BedroomsTotal
A boolean ‘Not’ must enclose its operands in a parenthesis with not as an operator i.e. not(City eq ‘Elkwood’).
https://api-prod.corelogic.com/trestle/odata/Property?$filter=not(BedroomsTotal le 3) and (PropertyType eq 'Residential')&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,BedroomsTotal&$top=11
not equal (ne) is used as to counter equal (eq)
https://api-prod.corelogic.com/trestle/odata/Property?$filter=BedroomsTotal ne 3 and (OriginatingSystemName eq 'NTREIS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency
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-prod.corelogic.com/trestle/odata/Member?$filter=(MemberFirstName eq 'James' or toupper(MemberFirstName) eq 'ADAM') and (OriginatingSystemName eq 'NTREIS')&$top=20
Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions.
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 or (BedroomsTotal eq 4 and FireplaceYN eq true)&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,City
not equal (ne) is used as to counter equal (eq)
https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=10&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType&$filter=(BedroomsTotal ne 2) and (BedroomsTotal le 5 and BedroomsTotal ne 1) and (PropertyType eq 'Residential')
Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions.
https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=10&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType&$filter=(BedroomsTotal gt 3 and BedroomsTotal lt 5) and (PropertyType eq 'Residential')
A boolean ‘Not’ must enclose its operands in a parenthesis with not as an operator i.e. not(City eq ‘Elkwood’).
https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=10&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,InternetAddressDisplayYN&$filter=not(InternetAddressDisplayYN eq true)
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/abor_ref/Member?$top=5&$filter=MemberStatus eq 'Active' and (MemberFirstName eq 'James' or MemberFirstName eq 'Adam')
