Ask Your Question

Revision history [back]

invalid field

https://cren-rets.paragonrels.com/rets/fnisrets.aspx/CREN/login?rets-version=rets/1.7.2 user: SmartCRENIDX

getting the following error on a get data call

Sent  냬ass=CI_3&Count=1&Format=COMPACT-DECODED&Query=(L_UpdateDate%3d2020-08-12T18:16:20%2b00:00-NOW),(L_StatusCatID%3d|1,3)&QueryType=DMQL2&SearchType=Property&Select=LM_char5_57,LM_char5_23,LM_char5_58,L_NumUnits,LM_Char1_9,LM_char1_56,LM_Char1_10,LM_Char10_16,LFD_AVAILABLEFORAUCTION_81,LFD_AVAILABLEUTILITIES_67,LM_char10_100,L_Address,L_AddressDirection,L_AddressNumber,L_AddressSearchNumber,L_AddressStreet,LM_char10_55,LM_char5_54,LM_char10_31,LM_Dec_1,L_NumAcres,LM_Int4_1,L_Area,L_AskingPrice,LM_Int4_5,LM_Char10_17,L_Keyword7,VT_ExtVTourURL3,VT_ExtVTourURL5,LM_char10_50,LFD_COOLING_61,LFD_CURRENTPROPERTYUSE_55,LM_Dec_9,LM_Char1_13,LM_Char1_12,LM_char5_56,L_City,L_Class,LM_Char1_17,LM_char10_47,LM_char1_24,LM_Char25_20,LFD_DISCLOSURES_230,LFD_DOCUMENTSONFILE_74,LFD_DOMESTICWATER_68,LM_Char25_21,LR_remarks66,L_LastDocUpdate,LM_Dec_2,LFD_EXISTINGUTILITIES_66,LM_Char1_19,LM_DateTime_2,LM_char10_37,LFD_FENCE_60,LM_char5_42,LFD_FLOORING_65,LFD_FOUNDATION_56,LM_Int4_4,L_FirstPhotoAddDt,L_Keyword4,LM_Char1_11,LM_char50_7,LM_char1_31,LMD_MP_AddressLine,LMD_MP_Latitude,LMD_MP_Longitude,LMD_MP_MatchCode,LMD_MP_MatchedMethod,LMD_MP_PostalCode,LMD_MP_PrimaryCity,LMD_MP_Quality,LMD_MP_SecondaryCity,LMD_MP_Subdivision,LMD_MP_UpdateDate,LMD_MP_ZoomLevel,LM_DateTime_3,LM_Dec_18,LM_Dec_7,LFD_HEATINGFUELSOURCE_58,LFD_HEATINGSYSTEM_59,LM_Char10_18,L_IdxInclude,LFD_INCLUSIONS_76,LM_char50_30,LM_char1_30,LM_char30_7,L_Keyword5,LM_char10_102,LA1_UserFirstName,LA1_UserLastName,LA1_AgentLicenseID,LA1_PhoneNumber1CountryCodeId,LA1_PhoneNumber1Ext,LA1_PhoneNumber1,LA2_UserFirstName,LA2_UserLastName,LA2_PhoneNumber1CountryCodeId,LA2_PhoneNumber1Ext,LA2_PhoneNumber1,LA2_PhoneNumber5Ext,LA2_PhoneNumber5,LFD_LANDLORDPAYS_71,LFD_LIGHTING_62,LO1_Char50_1,LO1_BranchOfOrgID,LO1_ShortName,LO1_HiddenOrgID,LO1_OrganizationName,LO1_PhoneNumber1CountryCodeId,LO1_PhoneNumber1Ext,LO1_PhoneNumber1,LO1_HiddenOtyID,LO2_Char50_1,LO2_BranchOfOrgID,LO2_ShortName,LO2_HiddenOrgID,LO2_OrganizationName,LO2_PhoneNumber1CountryCodeId,LO2_PhoneNumber1Ext,LO2_PhoneNumber1,LO2_HiddenOtyID,LFD_LOTSIZEACERAGE_63,L_LvtDate,L_Keyword9,LM_Dec_29,L_ListingTeamId,L_ListAgent1,L_ListAgent2,L_ListingDate,L_ListOffice1,L_ListOffice2,L_listing_visibility_type_id,L_Keyword10,LM_Char25_7,LM_Char25_6,LM_int4_26,L_DisplayId,LM_int4_24,LM_Char10_5,LM_Char10_6,LM_char10_51,LM_char10_52,LM_Dec_13,LM_Char1_16,VT_VTourURL,VT_ExtVTourURL2,VT_ExtVTourURL4,LM_Char10_11,LM_Char10_12,LM_Char50_3,LFD_OWNERASSNINCLUSIONS_73,LM_char10_101,L_ListingsOffMarketStatusDate,LM_int4_29,LM_char1_21,LFD_PARKING_72,LFD_POSSIBLEPROPERTYUSE_226,LFD_PROPERTYDESCRIPTION_193,LM_Dec_10,LM_Int1_10,L_PictureCount,L_Last_Photo_updt,LM_Char25_17,LM_Char1_1,LR_remarks44,LM_Char1_14,LM_char10_36,LFD_ROOF_64,L_Keyword6,L_Keyword2,LM_char5_53,SA1_AgentLicenseID,LFD_SECURITY_75,LFD_SEWER_69,SO1_Char50_1,SO2_Char50_1,LFD_STREETDESCRIPTIONACCESS_77,L_SaleRent,L_SystemPrice,L_SellingTeamId,LM_char5_59,L_SellingAgent1,L_SellingOffice1,L_SellingOffice2,LM_DateTime_4,LM_Char1_15,LM_Char10_13,LM_char10_56,L_State,L_Status,L_StatusCatID,L_StatusID,L_StreetDesignationId,LM_Char25_1,L_ListingID,LFD_TENANTPAYS_70,LFD_TERMS_80,LM_Char1_6,LM_Char50_2,LM_char5_22,LM_Int1_9,LM_Int1_8,LM_Int1_7,LM_Dec_12,LM_char5_15,LM_char10_69,L_Type_,L_Keyword8,L_Address2,L_UpdateDate,LM_int4_25,LV_vow_avm,LV_vow_address,LV_vow_comment,LV_vow_include,LM_int4_40,LM_Char10_3,LM_char5_55,LFD_WATERFRONT_185,LM_int4_30,LM_Char1_4,LM_Char1_3,LM_Char1_5,LM_Int2_6,LM_Int4_6,LFD_ZONING_57,L_Zip,LM_char30_9&StandardNames=0 <<< Received ,HTTP/1.1 200 OK Cache-Control: private Content-Type: text/xml; charset=utf-8 Expires: Mon, 01 Jan 0001 00:00:00 GMT X-AspNetMvc-Version: 5.2 RETS-Server: RETS-Paragon/1.0 RETS-Version: RETS/1.7.2 X-Server: A100-02 Date: Tue, 18 Aug 2020 13:51:35 GMT Content-Length: 250

<rets replycode="20202" replytext="Invalid Select. Field [L_LvtDate] does not exist in Class [CI_3]." &gt;="" <rets-status="" replycode="20202" replytext="Invalid Select. Field [L_LvtDate] does not exist in Class [CI_3]."/> </rets> * Connection #0 to host cren-rets.paragonrels.com left intact