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://sparkapi.com/Reso/OData/Property?$filter=(PropertySubType eq 'b__53696e676c652046616d696c79205265736964656e6365' and (StreetName eq 'Twisted Run' or StreetName eq 'cr 222'))&$top=25&$select=ListingId,ListPrice,StreetNumber,StreetName,City,PropertySubType,InternetAddressDisplayYN
Filter results by a boolean field (true or false). Note, do not treat the value true or false as a string.
https://sparkapi.com/Reso/OData/Property?$filter=InternetAddressDisplayYN eq true and (ListPrice gt 500000 and ListPrice lt 1150000) and (City eq 'Vancleave')&$top=10&$select=ListingId,ListPrice,StreetName,City,PropertySubType,InternetAddressDisplayYN
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://sparkapi.com/Reso/OData/Property?$filter=(ListPrice gt 500000 and ListPrice lt 1150000) and (City eq 'Vancleave')&$top=10&$select=ListingId,ListPrice,StreetName,City,PropertySubType
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,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 &$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,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?$(MemberFirstName eq 'James' or toupper(MemberFirstName) eq 'ADAM')&$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) &$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,ModificationTimestamp,OriginatingSystemName,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 'El Paso') and (PropertyType eq 'Residential')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency
not equal (ne) is used as to counter equal (eq)
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal ne 3&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber
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 'Irving') and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'NTREIS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,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 'NTREIS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,InternetAddressDisplayYN
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 'FMLS')&$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 'FMLS')&$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 'FMLS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,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 'Decatur') and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'FMLS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,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 'FMLS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,InternetAddressDisplayYN
A boolean ‘Not’ must enclose its operands in a parenthesis with not as an operator i.e. not(City eq ‘Elkwood’).
https://sparkapi.com/Reso/OData/Property?$filter=not(BedroomsTotal le 3) and (PropertyType eq 'Residential')&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,BedroomsTotal&$top=10
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 &$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,InternetAddressDisplayYN
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://sparkapi.com/Reso/OData/Member?$filter=(MemberFirstName eq 'James' or toupper(MemberFirstName) eq 'Adam')&$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
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://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 and City eq 'Jupiter' and (PropertyType eq 'Residential')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,BedroomsTotal
Filter results by a boolean field (true or false). Note, do not treat the value true or false as a string.
https://sparkapi.com/Reso/OData/Property?$filter=FireplaceYN eq true&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,FireplaceYN
not equal (ne) is used as to counter equal (eq)
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal ne 33&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber
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=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber
