Ask Your Question
0

invalid field

asked 2020-08-18 14:02:27 -0500

https://cren-rets.paragonrels.com/ret... 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 &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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-08-18 15:31:07 -0500

Looks like the L_LvtDate field is disabled for your account.

edit flag offensive delete link more

Comments

the issue is we are getting it in the metadata. the way our process works ifs if the column is available in the metadata we try to pull the data for it

SmarterAget gravatar imageSmarterAget ( 2020-08-19 05:32:45 -0500 )edit

Sorry. Looks like there may be an issue with the metadata date not getting updated.
If you can do a pull of the metadata the field should be gone.

bwolven gravatar imagebwolven ( 2020-08-19 06:35:25 -0500 )edit

that resolved it, I see L_LvtDate and L_listing_visibility_type_id have been removed

SmarterAget gravatar imageSmarterAget ( 2020-08-19 07:41:49 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-18 14:02:27 -0500

Seen: 13 times

Last updated: Aug 18