First time here? Check out the FAQ!

RETS Status Code = 20202: Invalid Select

Good Morning,

I have been getting this error for the last 3 days. Nothing has been changed in a few months now. Is this something that needs to be addressed on your end or do I have a deprecated field that we're trying to use and needs to be removed? Log below:

Server: User name: SANTAROSA Incremental pull since 12/11/2017 11:59:50 PM Local time: 12/14/2017 9:57:20 AM Server time: Thu, 14 Dec 2017 15:57:20 GMT Last modification time found: 12/13/2017 11:59:41 PM

Running step "PAR_Pull_ListDate"

Data file: E:\Field Tasks\MLS\PAR\ByListDate\Documents\MLS_PAR_Pull_ListDate.csv Search query: (L_ListingDate=2017-12-11T23:59:50+),(L_Area=|4),(L_Status=|1_0,1_1,1_2,1_4,2_0,3_0) 0 records downloaded Error detected: server failed the request Request: SearchType=Property&Class=RE_1&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(L_ListingDate=2017-12-11T23:59:50%2B),(L_Area=|4),(L_Status=|1_0,1_1,1_2,1_4,2_0,3_0)&Select=L_ListingID,LM_char30_4,L_DisplayId,L_AddressNumber,L_AddressStreet,L_City,L_State,L_Zip,L_Area,LM_char10_51,L_ListingDate,L_AskingPrice,LM_Int4_3,L_NumAcres,LM_char30_3,LFD_LOTLOCATION_22,LM_Int2_11,LFD_POOL_20,LM_Int2_8,LM_Int1_1,LM_Int1_2,LM_Int1_3,LM_Int1_4,LFD_COOLING_7,LFD_ENERGY_11,LFD_EXTERIOR_19,LFD_FLOORS_2,LFD_HEATING_8,LFD_INTERIOR_1,LFD_KITCHENFEATURES_3,LFD_MASTERBATH_6,LFD_MASTERBEDROOM_5,LFD_MISCEQUIPMENT_12,LFD_PARKING_21,LFD_ROOF_17,LFD_SIDING_18,LFD_STYLE_16,L_Address2,LFD_WATERFEATURE_25,LFD_WATERSEWER_26,LFD_WATERFRONT_23,LFD_WATERVIEW_24 RETS Status code = 20202: Invalid Select. Field [LM_Int1_4] does not exist in Class [RE_1].

Last URL Requested:

srcpaIT's avatar
asked 2017-12-14 10:26:23 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


Looks like field: LM_Int1_4 (# rooms) was disabled in Paragon at the request of the MLS on 12/06/2017. So it is no longer in the RETS feed. You will need to remove it from your search query's Select statement.

bwolven's avatar
answered 2017-12-14 14:21:03 -0500
edit flag offensive 0 remove flag delete link


add a comment see more comments

Your Answer

Login/Signup to Answer