Logic

C7 | Filter on Boolean field

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/abor_ref/Property?$filter=InternetAddressDisplayYN eq true and (City eq 'Austin') and (PropertyType eq 'Residential')&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,InternetAddressDisplayYN

C6 | Filter on multiple field values

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/abor_ref/Property?$filter=(BedroomsTotal gt 3 and BedroomsTotal lt 5) and (City eq 'Austin') and (PropertyType eq 'Residential')&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType

C9 | Filter using ‘not’ in an expression

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,City,BedroomsTotal&$top=10

C8 | Filter using not equal

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,City

C7 | Filter on string fields

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

C8 | Filter on same field

Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions. https://api-prod.corelogic.com/trestle/odata/Property?$filter=(City eq 'Irving') and (PropertyType eq 'Residential') and BedroomsTotal eq 3 or (BedroomsTotal eq 4 and InternetAddressDisplayYN eq true)&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency

C5 | Filter on multiple field values

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 'Holland' and (PropertyType eq 'Residential')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,City,BedroomsTotal

C4 | Filter on Boolean field

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,City,FireplaceYN

C10 | Filter using not equal

not equal (ne) is used as to counter equal (eq) http://resoapi.wfrmls.com/reso/odata/Properties?$filter=BedroomsTotal ne 33&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks

C9 | Filter on same field

Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions. http://resoapi.wfrmls.com/reso/odata/Properties?$filter=BedroomsTotal lt 5 or (BedroomsTotal eq 4 and CoolingYN eq true)&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks

C8 | Filter on string fields

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... http://resoapi.wfrmls.com/reso/odata/Members?$filter=(MemberFirstName eq 'James' or toupper(MemberFirstName) eq 'Adam')&$top=20

C7 | Filter on Boolean field

Filter results by a boolean field (true or false). Note, do not treat the value true or false as a string. http://resoapi.wfrmls.com/reso/odata/Properties?$filter=CoolingYN eq true&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,CoolingYN

C6 | Filter on multiple field values

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. http://resoapi.wfrmls.com/reso/odata/Properties?$filter=BedroomsTotal lt 5 and (City has Odata.Models.City'Provo') and (PropertyType has Odata.Models.PropertyType'Residential')&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,BedroomsTotal

C11 | Filter using ‘not’ in an expression

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,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency,BedroomsTotal&$top=11

C7 | Filter using ‘not’ in an expression

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,City,StreetName,StreetNumber,BedroomsTotal&$top=10

C6 | Filter on multiple field values

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 'Tucson' and (PropertyType eq 'Residential')&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,BedroomsTotal

C12 | Filter using not equal

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')

C11 | Filter on same field

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')

C10 | Filter using ‘not’ in an expression

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)

C9 | Filter on string fields

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')

C8 | Filter on Boolean field

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/abor_ref/Property?$filter=InternetAddressDisplayYN eq true and (City eq 'Austin') and (PropertyType eq 'Residential')&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,InternetAddressDisplayYN

C7 | Filter on multiple field values

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/abor_ref/Property?$filter=(BedroomsTotal gt 3 and BedroomsTotal lt 5) and (City eq 'Austin') and (PropertyType eq 'Residential')&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType

C9 | Filter using not equal

not equal (ne) is used as to counter equal (eq) https://sparkapi.com/Reso/OData/Property?$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks&$filter=BedroomsTotal ne 1 and PropertyType eq 'b__53696e676c652046616d696c79'

C8 | Filter on same field

Use parenthesis and logical ‘and’ or ‘or’ to group filter expressions. https://sparkapi.com/Reso/OData/Property?$top=11&$select=ListingKey,BedroomsTotal,BathroomsTotalInteger ,ListingContractDate,ModificationTimestamp,StandardStatus,PropertySubType,Location,PublicRemarks&$filter=(BathroomsTotalInteger gt 2) and (BedroomsTotal le 5 and BedroomsTotal ge 2) and PropertySubType eq 'b__53696e676c652046616d696c79205265736964656e6365'

C7 | Filter on Boolean field

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=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,FireplaceYN