Select Page

Dates

F23 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$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

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

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

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=year(ListingContractDate) eq 2018 and month(ListingContractDate) eq 5 and (City eq 'Vancleave')&$top=10&$select=ListingId,ListingKey,ListPrice,StreetNumber,StreetName,BathroomsTotalInteger,BedroomsTotal,PropertyType,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(ListingContractDate) lt 2018 and month(ListingContractDate) eq 5 and day(ListingContractDate) lt 31 and hour(ModificationTimestamp) gt 13 and minute(ModificationTimestamp) gt 3&$top=10&$select=ListingId,ListingKey,ListPrice,StreetNumber,StreetName,BathroomsTotalInteger,BedroomsTotal,PropertyType,ListingContractDate

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?$top=12&$select=ListingId,ListingKey,ListPrice,StreetNumber,StreetName,BathroomsTotalInteger,BedroomsTotal,PropertyType,ListingContractDate,ModificationTimestamp&$filter=year(ModificationTimestamp) eq 2016 and month(ModificationTimestamp) eq 9 and day(ModificationTimestamp) eq 14 and hour(ModificationTimestamp) gt 6 and minute(ModificationTimestamp) gt 3 and fractionalseconds(ModificationTimestamp) gt 3

F20 | Filter on a date value of now

The function now() will return the now time in UTC https://sparkapi.com/Reso/OData/Property?$top=9&$select=PropertyType,ListingId,ListingKey,ListPrice,StreetNumber,StreetName,BathroomsTotalInteger,BedroomsTotal,PropertyType,ListingContractDate,ModificationTimestamp&$filter=ModificationTimestamp le now()

F21 | 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

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/abor_ref/Property?$top=4&$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'&$select=ListingId,ListingKey,City,ListPrice,StreetNumber,StreetName,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,ListingContractDate,ModificationTimestamp

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/abor_ref/Property?$top=4&$filter=ModificationTimestamp le now() and PropertyType eq 'Residential'&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City

F24 | Filter on time

Filtering on time can use of the hour, minute, second and fractional seconds functions. https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$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

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

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

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

F22 | 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,City,StreetName,StreetNumber,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,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,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,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,ModificationTimestamp&$top=4

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