Search Error - (20206) [Illegal number in range for field [L_StatusCatID]] on a new feed
Hello, We are trying to set up a new RETS feed with you for Tehama County Association of Realtors. I can access the Member and Office classes without issues, but when I try to pull any of the Property classes, I get the error:
Search Error - (20206) [Illegal number in range for field [L_StatusCatID]]
I do not use the L_StatusCatID field in my select or query, so I'm not sure why I'm seeing this unless it is a required field in the query, which I have never seen on any Black Knight feeds (we have over 50).
I am using the following information:
version: RETS/1.7.2
login: http://tcaor-rets.paragonrels.com:80/rets/fnisrets.aspx/TCAOR/login
user: TERRADATUMRETS select=LA1_AgentID,LMD_MP_Latitude,LMD_MP_Longitude,LMD_MP_Subdivision,LM_Char10_1,LO1_ShortName,LO1_board_id,LO2_HiddenOrgID,LO2_ShortName,L_Address,L_Address2,L_AddressDirection,L_AddressNumber,L_AddressSearchNumber,L_AddressStreet,L_Area,L_AskingPrice,L_CDOM,L_City,L_Class,L_ClosingDate,L_ContractDate,L_DOM,L_ExpirationDate,L_InputDate,L_ListAgent1,L_ListAgent2,L_ListOffice1,L_ListOffice2,L_ListingDate,L_ListingID,L_NumAcres,L_OriginalPrice,L_SellingAgent1,L_SellingAgent2,L_SellingOffice1,L_SellingOffice2,L_SoldPrice,L_State,L_Status,L_StatusDate,L_Type_,L_UpdateDate,L_Zip,T_list_tax_property_id,T_tax_db_id
format=COMPACT
searchtype=Property
Query=(L_ListingID=0+),(L_UpdateDate=2021-08-07T10:08:46+)
class=RE_1
standardnames=0
limit=2000
querytype=DMQL2
Any suggestions? I also have this same error using BRIGHT Conduit for RETS, and a colleague at Lone Wolf has no issue with her credentials (same query and endpoint as above) but does with ours.
I did also try changing my query to:
Query=(L_ListingID=0+),(L_StatusCatID=1,2,3,4,5,6),(L_UpdateDate=2021-08-07T10:08:46+)
And I get the same error. I was hoping putting it in there with numeric values would get around the issue.
Many thanks,
Dan Stegman
Comments
Hey Dan! It looks like the filter for your profile was not in the valid format. I've reached out to the MLS' point of contact, i'll post here once it's resolved.
Thank you,