Functions

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

G24 | Filter a string that contains

Filter on a string field value that contains a certain value. This is case sensitive https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Member?$top=5&$filter=contains(toupper(MemberFirstName),'JOHN')

G25 | Filter by comparing upper case

Convert a string to upper case (toupper). Lower case would use the function tolower(). https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=11&$select=ListingKey,BedroomsTotal,BathroomsTotalInteger ,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,PublicRemarks&$filter=toupper(StreetName) eq 'INDUSTRIAL'

G26 | 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.bridgedataoutput.com/api/v2/OData/abor_ref/Member?$top=5&$filter=endswith(toupper(MemberLastName),'SON')

G27 | 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.bridgedataoutput.com/api/v2/OData/abor_ref/Member?$top=5&$filter=startswith(toupper(MemberLastName),'JOHNS')&$select=MemberFullName,MemberStatus

G24 | Filter on a string that ends with

Filter on a string field value that ends with a certain value. This is case sensitive https://sparkapi.com/Reso/OData/Property?$filter=endswith(StreetName, 'M')&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,StreetName&$top=10

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,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,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(AboveGradeFinishedArea, 'Edm.String') eq '1500'&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,AboveGradeFinishedArea

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 'Napa-Rolla')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency

G21 | 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=(City eq 'Vancleave') and contains(StreetName, 'Highway')&$top=10&$select=ListingId,ListingKey,ListPrice,StreetNumber,StreetName,BathroomsTotalInteger,BedroomsTotal,PropertyType

G22 | Filter on a string that ends with

Filter on a string field value that ends with a certain value. This is case sensitive https://sparkapi.com/Reso/OData/Property?$filter=(City eq 'Vancleave') and endswith(StreetName, 'Marina')&$top=10&$select=ListingId,ListingKey,ListPrice,StreetNumber,StreetName,BathroomsTotalInteger,BedroomsTotal,PropertyType,ListingContractDate

G23 | Filter on a string that starts with

Filter on a string field value that starts with a certain value. This is case sensitive https://sparkapi.com/Reso/OData/Property?$filter=(City eq 'Vancleave') and startswith(StreetName, 'Highway')&$top=10&$select=ListingId,ListingKey,ListPrice,StreetNumber,StreetName,BathroomsTotalInteger,BedroomsTotal,PropertyType

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?$top=11&$select=ListingKey,BedroomsTotal,BathroomsTotalInteger ,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks&$filter=(BathroomsTotalInteger gt 2) and (BedroomsTotal le 5 and BedroomsTotal ge 2) and PropertyType eq 'b__53696e676c652046616d696c79' and contains(toupper(PublicRemarks), 'POTS')

G25 | Filter a string that contains

Filter on a string field value that contains a certain value. This is case sensitive https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Member?$top=5&$filter=contains(toupper(MemberFirstName),'JOHN')

G26 | Filter by comparing upper case

Convert a string to upper case (toupper). Lower case would use the function tolower(). https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=11&$select=ListingKey,BedroomsTotal,BathroomsTotalInteger ,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,PublicRemarks&$filter=toupper(StreetName) eq 'INDUSTRIAL'

G27 | 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.bridgedataoutput.com/api/v2/OData/abor_ref/Member?$top=5&$filter=endswith(toupper(MemberLastName),'SON')

G28 | 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.bridgedataoutput.com/api/v2/OData/abor_ref/Member?$top=5&$filter=startswith(toupper(MemberLastName),'JOHNS')&$select=MemberFullName,MemberStatus

G23 | Filter on a string that starts with

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

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,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,StreetName&$top=5

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

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

G21 | Filter on a string that starts with

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

G22 | Filter on a string that ends with

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