Select Page

Dates

F22 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. https://api-prod.corelogic.com/trestle/odata/Property?$filter=year(ModificationTimestamp) gt 2017 and month(ModificationTimestamp) gt 1 and day(ModificationTimestamp) lt 31 and hour(ModificationTimestamp) gt 1 and minute(ModificationTimestamp) gt 3 and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency,ModificationTimestamp

F22 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. https://api-prod.corelogic.com/trestle/odata/Property?$filter=year(ModificationTimestamp) gt 2017 and month(ModificationTimestamp) gt 1 and day(ModificationTimestamp) lt 31 and hour(ModificationTimestamp) gt 1 and minute(ModificationTimestamp) gt 3 and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'NTREIS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,ModificationTimestamp

F20 | Filter on a Date

Filtering on a date requires date fields to be defined as dates (Type=”Edm.Date”) in the metadata https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=ListingContractDate gt 2016-12-31 and (PropertyType eq 'Residential')&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,ListingContractDate

F21 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=year(ModificationTimestamp) eq 2018 and month(ModificationTimestamp) gt 5 and day(ModificationTimestamp) lt 31 and hour(ModificationTimestamp) gt 1 and minute(ModificationTimestamp) gt 3 and (PropertyType eq 'Residential')&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,ModificationTimestamp

F22 | Filter on a fractional second

filtering on fractions of a second requires the use of the function fractionalseconds() https://api.bridgedataoutput.com/api/v2/OData/har/Property?$top=4&$filter=ListingContractDate gt 2017-01-01 and month(ListingContractDate) gt 5 and fractionalseconds(ModificationTimestamp) lt 33 and PropertyType eq 'Residential'&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,PublicRemarks

F23 | Filter on a date value of now

The function now() will return the now time in UTC https://api.bridgedataoutput.com/api/v2/OData/har/Properties?$filter=ModificationTimestamp le now() and (PropertyType eq 'Residential')&$top=10&$select=ListingKey,BedroomsTotal,StreetName,StreetNumber,City,PropertyType,ModificationTimestamp,ListAgent,CloseDate,ModificationTimestamp

F19 | Filter on a Date

Filtering on a date requires date fields to be defined as dates (Type=”Edm.Date”) in the metadata https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=ListingContractDate lt 2016-12-31 and (PropertyType has PropertyEnums.PropertyType'Residential')&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,ListingContractDate

F20 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=year(ModificationTimestamp) eq 2018 and month(ModificationTimestamp) gt 5 and day(ModificationTimestamp) lt 31 and hour(ModificationTimestamp) gt 1 and minute(ModificationTimestamp) gt 3 and (PropertyType has PropertyEnums.PropertyType'Residential')&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,ModificationTimestamp

F21 | Filter on a fractional second

filtering on fractions of a second requires the use of the function fractionalseconds() https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=ListingContractDate lt 2016-12-31 and fractionalseconds(ModificationTimestamp) lt 30 and (PropertyType has PropertyEnums.PropertyType'Residential')&$top=10&$select=ListingKey,ListingContractDate,BedroomsTotal,StreetName,OnMarketDate,PropertyType,ModificationTimestamp,ListAgent,ListingContractDate,ModificationTimestamp

F22 | Filter on a date value of now

The function now() will return the now time in UTC https://api.bridgedataoutput.com/api/v2/OData/mlspin/Properties?$filter=ModificationTimestamp le now()&$top=10

F19 | Filter on a Date

Filtering on a date requires date fields to be defined as dates (Type=”Edm.Date”) in the metadata https://api-prod.corelogic.com/trestle/odata/Property?$filter=ListingContractDate lt 2017-12-31 and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency,ListingContractDate

F20 | Filter on a date value of now

The function now() will return the now time in UTC https://api-prod.corelogic.com/trestle/odata/Property?$filter=ModificationTimestamp le now() and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency,ModificationTimestamp&$top=5

F21 | Filter on a fractional second

filtering on fractions of a second requires the use of the function fractionalseconds() https://api-prod.corelogic.com/trestle/odata/Property?$filter=ListingContractDate lt 2017-12-31 and fractionalseconds(ModificationTimestamp) lt 0033 and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'SEFMIAMI' and OriginatingSystemSubName eq 'SEFMIAMI_MIAMI')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,OriginatingSystemSubName,Appliances,ListingContractDate,AssociationFeeFrequency,ListingContractDate,ModificationTimestamp

F21 | Filter on a fractional second

filtering on fractions of a second requires the use of the function fractionalseconds() https://api-prod.corelogic.com/trestle/odata/Property?$filter=ListingContractDate lt 2017-12-31 and fractionalseconds(ModificationTimestamp) lt 0033 and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'NTREIS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,ListingContractDate,ModificationTimestamp

F18 | Filter on a Date

Filtering on a date requires date fields to be defined as dates (Type=”Edm.Date”) in the metadata http://resoapi.wfrmls.com/reso/odata/Properties?$filter=ListingContractDate lt 2017-12-31 and (PropertyType has Odata.Models.PropertyType'Residential')&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,ListingContractDate

F19 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. http://resoapi.wfrmls.com/reso/odata/Properties?$filter=year(ModificationTimestamp) eq 2018 and month(ModificationTimestamp) gt 5 and day(ModificationTimestamp) lt 31 and hour(ModificationTimestamp) gt 1 and minute(ModificationTimestamp) gt 3 and (PropertyType has Odata.Models.PropertyType'Residential')&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,ModificationTimestamp

F20 | Filter on a fractional second

filtering on fractions of a second requires the use of the function fractionalseconds() http://resoapi.wfrmls.com/reso/odata/Properties?$filter=ListingContractDate lt 2017-12-31 and fractionalseconds(ModificationTimestamp) lt 0033 and (PropertyType has Odata.Models.PropertyType'Residential')&$top=10&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,ListingContractDate,ModificationTimestamp

F21 | Filter on a date value of now

The function now() will return the now time in UTC http://resoapi.wfrmls.com/reso/odata/Properties?$filter=ModificationTimestamp le now() and (PropertyType has Odata.Models.PropertyType'Residential')&$select=ListingKeyNumeric,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,PublicRemarks,ModificationTimestamp&$top=10

F17 | Filter on a Date

Filtering on a date requires date fields to be defined as dates (Type=”Edm.Date”) in the metadata https://sparkapi.com/Reso/OData/Property?$filter=ListingContractDate lt 2016-12-31 and (PropertyType eq 'Residential')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,City,ListingContractDate

F18 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. https://sparkapi.com/Reso/OData/Property?$filter=year(ModificationTimestamp) eq 2018 and month(ModificationTimestamp) gt 5 and day(ModificationTimestamp) lt 31 and hour(ModificationTimestamp) gt 1 and minute(ModificationTimestamp) gt 3 and (PropertyType eq 'Residential')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,City,ModificationTimestamp

F19 | Filter on a fractional second

filtering on fractions of a second requires the use of the function fractionalseconds() https://sparkapi.com/Reso/OData/Property?$filter=ListingContractDate lt 2016-12-31 and fractionalseconds(ModificationTimestamp) lt 0033 and (PropertyType eq 'Residential')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,City,ListingContractDate,ModificationTimestamp

F20 | Filter on a date value of now

The function now() will return the now time in UTC https://sparkapi.com/Reso/OData/Property?$filter=ModificationTimestamp le now() and (PropertyType eq 'Residential')&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,City,ModificationTimestamp&$top=4

F20 | Filter on a Date

Filtering on a date requires date fields to be defined as dates (Type=”Edm.Date”) in the metadata https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$filter=ListingContractDate lt 2016-12-31 and (PropertyType eq 'Residential')&$top=10&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType

F21 | Filter on a fractional second

filtering on fractions of a second requires the use of the function fractionalseconds() https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,PublicRemarks&$filter=year(ListingContractDate) eq 2017 and month(ListingContractDate) eq 5 and day(ListingContractDate) eq 31 and hour(ModificationTimestamp) gt 13 and minute(ModificationTimestamp) gt 3 and fractionalseconds(ModificationTimestamp) lt 33 and PropertyType eq 'Residential'

F22 | Filter on a date value of now

The function now() will return the now time in UTC https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=4&$filter=ModificationTimestamp le now() and PropertyType eq 'Residential'&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City
Subscribe To Our Blog!

Subscribe To Our Blog!

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!