Query By Status To Obtain List of On-Market Listing In Order to Remove Off-Market Listings. [closed]
As this feed is only providing on-market + sold status listings, we will need to regularly pull down lists of on-market listings in order to clean the off-market listings out of our on-market data. To facilitate this, we must query by status. As this MLS has seen feed to not populate StandardStatus and only consistently populates the MlsStatus field, we must query against MlsStatus.
There are two formats for doing this in RESO API, using a chained OR statement, or using an “IN ()” statement. However, both method fail with a “500 Internal Server Error” being returned.
Version 1: MlsStatus in ()
post_data = {:$filter=>"MlsStatus in ('(10) Active - Active','(11) Active - Active Under Contract','(30) Pending - Pending')", :$select=>"ListingId,ModificationTimestamp,MlsStatus", :$count=>"true", :$top=>1000} URL Request: https://smlsa.paragonrels.com/OData/S...
Version 2: MlsStatus eq <val1> or MlsStatus eq <val2> …
post_data = {:$filter=>"MlsStatus eq '(10) Active - Active' or MlsStatus eq '(11) Active - Active Under Contract' or MlsStatus eq '(30) Pending - Pending')", :$select=>"ListingId,ModificationTimestamp,MlsStatus", :$count=>"true", :$top=>1000} URL Request: https://smlsa.paragonrels.com/OData/S... +Pending%27%29&%24select=ListingId%2CModificationTimestamp%2CMlsStatus&%24top=1000
