Functions

G23 | Filter a string that contains

Filter on a string field value that contains a certain value. This is case sensitive https://sparkapi.com/Reso/OData/Property?$filter=contains(toupper(StreetName),'MAIN')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber

G24 | Filter by comparing upper case

Convert a string to upper case (toupper). Lower case would use the function tolower(). https://sparkapi.com/Reso/OData/Property?$filter=City eq 'Jupiter' and (PropertyType eq 'Residential') and toupper(StreetName) eq 'MAIN'&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,StreetName

G23 | Filter on a string that ends with

Filter on a string field value that ends with a certain value. This is case sensitive https://api-prod.corelogic.com/trestle/odata/Property?$filter=endswith(StreetName, 'M')&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,StreetName&$top=5

G24 | Filter by comparing upper case

Convert a string to upper case (toupper). Lower case would use the function tolower(). https://api-prod.corelogic.com/trestle/odata/Property?$filter=toupper(StreetName) eq 'MAIN'&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency

G25 | Filter on a string that starts with

Filter on a string field value that starts with a certain value. This is case sensitive https://api-prod.corelogic.com/trestle/odata/Member/?$filter=startswith(MemberFirstName, 'Joh')&$select=MemberFirstName,MemberLastName,MemberStatus,ModificationTimestamp&$top=20

G26 | Filter a string that contains

Filter on a string field value that contains a certain value. This is case sensitive https://api-prod.corelogic.com/trestle/odata/Property?$filter=contains(StreetName,'Main')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency

G27 | Filter using cast function

The cast function has the following signatures: type cast(type) and type cast(expression,type). The single parameter cast function returns the current instance cast to the type specified. The two parameter cast function returns the object referred to by the expression... https://api-prod.corelogic.com/trestle/odata/Property?$filter=cast(StreetNumberNumeric, 'Edm.String') ne '1500' and (OriginatingSystemName eq 'FMLS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,StreetNumberNumeric

G28 | Flter using concatenation function

The concat function with string parameter values returns a string that appends the second parameter string value to the first. The concat function with collection parameter values returns a collection that appends all items of the second collection to the first. If... https://api-prod.corelogic.com/trestle/odata/Property?$filter=(concat(concat(StreetName, '-'), City) eq 'Cedar-Decatur')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency

G23 | Filter on a string that ends with

Filter on a string field value that ends with a certain value. This is case sensitive https://api-prod.corelogic.com/trestle/odata/Property?$filter=endswith(StreetName, 'M')&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,StreetName&$top=5

G24 | Filter by comparing upper case

Convert a string to upper case (toupper). Lower case would use the function tolower(). https://api-prod.corelogic.com/trestle/odata/Property?$filter=toupper(StreetName) eq 'MAIN'&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency