A1 | Get metadata
Retrieve metadata for a specific service in OData EDMX/xml format.
https://sparkapi.com/Reso/OData/$metadata
Top ▴
https://sparkapi.com/Reso/OData/$metadata
Top ▴
https://sparkapi.com/Reso/OData/Property('20171214160010072899000000')
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=ListingKey eq '20171214160010072899000000'&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=FireplaceYN eq true&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,FireplaceYN
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 and City eq 'Jupiter' and (PropertyType eq 'Residential')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,BedroomsTotal
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 or (BedroomsTotal eq 4 and FireplaceYN eq true)&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Member?$filter=(MemberFirstName eq 'James' or toupper(MemberFirstName) eq 'Adam')&$top=20
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal ne 3&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=not(BedroomsTotal le 3) and (PropertyType eq 'Residential')&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,BedroomsTotal&$top=10
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=City eq 'Jupiter' and (PropertyType eq 'Residential') and PhotosCount gt 1&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,PhotosCount&$expand=Media
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 and City eq 'Jupiter' and (PropertyType eq 'Residential')&$orderby=ListPrice desc&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Member?$top=10&$select=MemberLastName,MemberFirstName,MemberLoginId&$filter=toupper(MemberFirstName) eq 'JOHN'
Top ▴
https://sparkapi.com/Reso/OData/Member?$skip=10&$top=10&$orderby=MemberLastName&$select=MemberLastName,MemberFirstName,MemberLoginId
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal eq 3&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=(PropertyType eq 'Residential') and PropertyType has PropertyEnums.PropertyType'Residential'&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,PropertyType
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=(PropertyType eq 'Residential') and (ConstructionMaterials has PropertyEnums.ConstructionMaterials'Brick') or (ConstructionMaterials has PropertyEnums.ConstructionMaterials'Concrete')&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber,ConstructionMaterials
Top ▴
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
Top ▴
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
Top ▴
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
Top ▴
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
Top ▴
https://sparkapi.com/Reso/OData/Member?$filter=startswith(MemberFirstName, 'Joh')&$select=MemberFirstName,MemberLastName,MemberStatus,ModificationTimestamp&$top=20
Top ▴
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
Top ▴
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
Top ▴
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
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=geo.distance(Location, geography'POINT(-80.352884 26.723936)') le 10&$top=4
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=(PropertyType eq 'Residential') and City eq 'Loxahatchee' and geo.intersects(Location,geography'POLYGON((-80.361589 26.724994, -80.361670 26.739507, -80.352591 26.738970, -80.361589 26.724994))')&$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,Location,PublicRemarks,StreetName,StreetNumber
FBS: Sometimes need to provide another parameter in the filter to avoid timeout
Top ▴