First time here? Check out the FAQ!

Strategic MLS RESO API Error

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:

lorama's avatar
asked 2021-08-30 21:11:09 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


Looks like the issue was resolved. We are able to download data again. Thank you

lorama's avatar
answered 2021-08-31 11:17:26 -0500
edit flag offensive 0 remove flag delete link



bwolven's avatar bwolven (2021-08-31 11:19:03 -0500) edit

Hi Bruce, once this was fixed, It appears Residential listings no longer have an MlsStatus. Can this be resolved?

jheald's avatar jheald (2021-09-03 09:03:51 -0500) edit

I am told that this is being worked on and should be completed sometime this afternoon.

bwolven's avatar bwolven (2021-09-03 09:44:52 -0500) edit

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.

jheald's avatar jheald (2021-09-07 10:23:11 -0500) edit

It looks like they are still working on issues with the Status field issue.

bwolven's avatar bwolven (2021-09-07 15:05:36 -0500) edit

Hi Bruce, any luck with these bugs? We're going on 6+ days without being able to pull updates.

jheald's avatar jheald (2021-09-09 16:55:06 -0500) edit

A fix was deployed for this today. Can you verify it is working now?

bwolven's avatar bwolven (2021-09-09 18:35:17 -0500) edit

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?

lorama's avatar lorama (2021-09-10 08:03:33 -0500) edit

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.

jheald's avatar jheald (2021-09-10 08:20:08 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer