Ask Your Question
0

buffalomls Agent data

asked 2019-07-23 15:24:18 -0500

We are having an issue pulling data from the agent class for buffalomls We receive the following error:

URL : http://buffalomls.rets.paragonrels.co... Username: BHHSBuffaloMLS

  Running task "316"

Server: http://buffalomls.rets.paragonrels.co... User name: BHHSBuffaloMLS Full pull Local time: 7/23/2019 4:21:23 PM Server time: Tue, 23 Jul 2019 20:21:22 GMT

Running step "active agent"

Data file: C:\sa-dwhite\dataprep\RETS\888-OH.txt Search query: (U_user_is_active=|1) 0 records downloaded Error detected: server failed the request Request: SearchType=ActiveAgent&Class=ActiveAgent&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(U_user_is_active=|1)&Select=U_user_is_active,U_ActiveBookCount,U_AddressStreet,U_Address2,U_BirthDate,U_City,U_FreeFormDesig,U_Email,U_UserFirstName,U_AgentID,U_UserLastName,U_AgentLicenseDate,U_AgentLicenseID,U_LoginName,U_MailAddress2,U_MailCity,U_PreferredMailCode,U_MailState,U_MailAddressStreet,U_MailZip,U_UserMI,U_HiddenOrgID,U_PhoneNumber1CountryCodeId,U_PhoneNumber1Desc,U_PhoneNumber1Ext,U_PhoneNumber1,U_PhoneNumber2CountryCodeId,U_PhoneNumber2Desc,U_PhoneNumber2Ext,U_PhoneNumber2,U_PhoneNumber3CountryCodeId,U_PhoneNumber3Desc,U_PhoneNumber3Ext,U_PhoneNumber3,U_PhoneNumber4CountryCodeId,U_PhoneNumber4Desc,U_PhoneNumber4Ext,U_PhoneNumber4,U_PhoneNumber5CountryCodeId,U_PhoneNumber5Desc,U_PhoneNumber5Ext,U_PhoneNumber5,U_UserSalutation,U_State,U_Status,U_Indoctrination,U_HiddenUsCID,U_WebPage,U_Zip,AO_board_id,AO_BranchOfOrgID,AO_OrgAddressStreet,AO_ShortName,AO_OrgAddress2,AO_OrgCity,AO_EMail,AO_OrganizationName,AO_PhoneNumber1CountryCodeId,AO_PhoneNumber1Desc,AO_PhoneNumber1Ext,AO_PhoneNumber1,AO_OrgState,AO_HiddenOtyID,AO_WebPage,AO_OrgZip,U_BoardDuesPaidThrough,U_BoardId,U_CorpPACContribYTD,U_InputDate,U_AgentTypeChangeDate,U_DateAssignedToOrg,U_DateKeyAssigned,U_StateAgentIsMemberOfDate,U_Dist,U_DuesPaidToBoard,U_Hash,U_LastTrig,U_LockBoxKeyDeposit,U_LockBoxKeyNumber,U_PACLastContribCheckNum,U_PACLastContribDate,U_MultyLogin,U_users_nrds_id,U_NumberOfKeysAssigned,U_PersonalPACContrib,U_Photographer,U_PreviousYearPACContrib,U_PreviousKeyNumber,U_SecurityLevel,U_SoldBookCount,U_SpouseFirstName,U_StateAgentIsMemberOf,U_StatusDate,U_IndoctrinationDate,UP_AgentImageFileUpdt,U_UpdateAgent,U_UpdateDate,UP_LogoImageFileUpdt,UP_AgentPhone,U_UserCode,U_Photos RETS Status code = 20200: Unknown Query Field [U_user_is_active]. Step finished at 7/23/2019 4:21:23 PM

Last URL requested: http://buffalomls.rets.paragonrels.co...

  Task "316" failed
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-07-23 17:11:07 -0500

Looks like the MLS has limited your profile to only a few fields and U_user_is_active isn't one of them.
Not that it really matters because you are searching ActiveAgent so it will only return ones that are active.
You can use a generic query like this: (U_AgentID=0+)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-23 15:24:18 -0500

Seen: 24 times

Last updated: Jul 23