Ask Your Question

Strategic MLS RESO API Error

asked 2021-08-30 21:11:09 -0500

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:

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2021-08-31 11:17:26 -0500

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

edit flag offensive delete link more



bwolven gravatar imagebwolven ( 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 gravatar imagejheald ( 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 gravatar imagebwolven ( 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 gravatar imagejheald ( 2021-09-07 10:23:11 -0500 )edit

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

bwolven gravatar imagebwolven ( 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 gravatar imagejheald ( 2021-09-09 16:55:06 -0500 )edit

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

bwolven gravatar imagebwolven ( 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 gravatar imagelorama ( 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 gravatar imagejheald ( 2021-09-10 08:20:08 -0500 )edit
Login/Signup to Answer

Question Tools



Asked: 2021-08-30 21:11:09 -0500

Seen: 295 times

Last updated: Aug 31 '21