We've been experiencing the following error for the past 2 days when try to connect and download data from the Strategic MLS RESO API:
The search failed with the error:\nInvalid column name 'Status'. - BLToolkit.Data.DataException: Invalid column name 'Status'. ---> System.Data.SqlClient.SqlException: Invalid column name 'Status'
Below is an example of an API request returning the error:
Looks like the issue was resolved. We are able to download data again. Thank you
Great.
Hi Bruce, once this was fixed, It appears Residential listings no longer have an MlsStatus. Can this be resolved?
I am told that this is being worked on and should be completed sometime this afternoon.
Hi Bruce, it looks like the original SQL error has been back for a few days now. Please let me know if you are seeing the same thing.
It looks like they are still working on issues with the Status field issue.
Hi Bruce, any luck with these bugs? We're going on 6+ days without being able to pull updates.
A fix was deployed for this today. Can you verify it is working now?
So it looks like we are still experiencing an issue when using a $select list and some MlsStatus values. When an API request is made with the $select list and a MlsStatus of 'Active', it works fine.
However, some listings have a MlsStatus of '_10__Active___Active'. Below is an example of an error when trying to get listings with that MlsStatus and $select=AccessibilityFeatures,ListingId,MlsStatus
Invalid Select. Field [LFD_ACCESSIBILITYFEATURES_5000] does not exist in Class [MU_3], Class [CS_5], Class [CL_6], Class [LL_4].
Is the MlsStatus '_10__Active___Active' no longer valid?
Bruce, looks like we're able to query again. However, when querying by MlsStatus of Active and _10__Active___Active, we got a strange error 'Active' is not a valid status, but when querying by Active alone, it works. Very strange, but we did have a workaround in our system to handle that.
Comments