First time here? Check out the FAQ!
0

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

dstegman's avatar
dstegman
asked 2021-09-15 08:14:33 -0500, updated 2021-09-15 08:26:50 -0500
edit flag offensive 0 remove flag close merge delete

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,

Sadie's avatar Sadie (2021-09-15 09:27:07 -0500) edit
add a comment see more comments

1 Answer

0

This should be resolved now!

Sadie's avatar
Sadie
answered 2021-09-15 09:50:15 -0500
edit flag offensive 0 remove flag delete link

Comments

Sadie, Thank you for your prompt attention. Glad it was an easy fix. Dan

dstegman's avatar dstegman (2021-09-15 09:53:22 -0500) edit

You're welcome! And me too!

Sadie's avatar Sadie (2021-09-15 11:07:16 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer