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/DataSystem
Top ▴
https://sparkapi.com/Reso/OData/DataSystem
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=ListingKey eq '20170531014449627088000000'&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Property('20170531014449627088000000')
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 or (BedroomsTotal eq 4 and FireplaceYN eq true)&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal ne 33&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 and City eq 'Tucson' and (PropertyType eq 'Residential')&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,BedroomsTotal
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=FireplaceYN eq true&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,FireplaceYN
Top ▴
https://sparkapi.com/Reso/OData/Member?$filter=MemberFirstName eq 'James'&$top=20
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=not(BedroomsTotal le 3) and (PropertyType eq 'Residential')&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,BedroomsTotal&$top=10
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=City eq 'Tucson' and (PropertyType eq 'Residential') and PhotosCount gt 1&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,PhotosCount&$expand=Media
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=BedroomsTotal lt 5 and City eq 'Tucson' and (PropertyType eq 'Residential')&$orderby=ListPrice desc&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,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=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,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,City,StreetName,StreetNumber,PropertyType
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=(PropertyType eq 'Residential') and (AccessibilityFeatures has PropertyEnums.AccessibilityFeatures'Ramps') or (AccessibilityFeatures has PropertyEnums.AccessibilityFeatures'b__4261746820477261622042617273')&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,AccessibilityFeatures
Top ▴
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
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=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,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=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,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,City,StreetName,StreetNumber,ModificationTimestamp&$top=10
Top ▴
https://sparkapi.com/Reso/OData/Member?$filter=startswith(MemberFirstName, 'Joh')&$select=MemberFirstName,MemberLastName,MemberStatus,ModificationTimestamp&$top=20
ARMLS: startswith function results are not consistent
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=endswith(StreetName, 'M')&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber,StreetName&$top=10
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=contains(toupper(StreetName),'MAIN')&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber
Top ▴
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
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=geo.distance(Location, geography'POINT(-111.700401 33.215137)') le 10&$top=10
Top ▴
https://sparkapi.com/Reso/OData/Property?$filter=(PropertyType eq 'Residential') and geo.intersects(Location,geography'POLYGON((-111.700401 33.215137, -111.700274 33.204770, -111.634575 33.205181, -111.635765 33.219113, -111.700401 33.215137))')&$top=10&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,StreetName,StreetNumber
Top ▴