Functions

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,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency

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 'NTREIS')&$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

G24 | 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/har/Member?$filter=startswith(MemberFirstName, 'Joh')&$select=MemberFirstName,MemberLastName,MemberStatus,ModificationTimestamp&$top=20

G25 | 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/har/Properties?$filter=endswith(StreetName, 'M')&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,StreetName&$top=10

G26 | 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/har/Properties?$filter=contains(toupper(StreetName),'MAIN')&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate

G27 | 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/har/Properties?$filter=toupper(StreetName) eq 'MAIN'&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,StreetName

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://api.bridgedataoutput.com/api/v2/OData/mlspin/Member?$filter=startswith(MemberFirstName, 'Joh')&$select=MemberFirstName,MemberLastName,MemberStatus,ModificationTimestamp&$top=20

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://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=endswith(StreetName, 'R')&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,StreetName&$top=10

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/mlspin/Properties?$filter=contains(toupper(StreetName),'MAIN')&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent

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/mlspin/Properties?$filter=toupper(StreetName) eq 'FRONT STREET'&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,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,OriginatingSystemSubName,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,OriginatingSystemSubName,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

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

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 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,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 'Brickell Ave-Miami')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency

G22 | Filter on a string that starts with

Filter on a string field value that starts with a certain value. This is case sensitive http://resoapi.wfrmls.com/reso/odata/Members?$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 http://resoapi.wfrmls.com/reso/odata/Properties?$filter=endswith(StreetName, 'M')&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,StreetName&$top=10

G24 | Filter a string that contains

Filter on a string field value that contains a certain value. This is case sensitive http://resoapi.wfrmls.com/reso/odata/Properties?$filter=contains(toupper(StreetName),'MAIN')&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks

G25 | Filter by comparing upper case

Convert a string to upper case (toupper). Lower case would use the function tolower(). http://resoapi.wfrmls.com/reso/odata/Properties?$filter=toupper(StreetName) eq 'MAIN'&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,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,City,StreetName&$top=4

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