Ask Your Question
0

ActiveAgent -- Missing close parenthesis on subquery (RETS Connector)

asked 2022-08-17 13:06:40 -0500

We are using RETS Connector software to pull from the "ActiveAgent" resource and are getting an error about missing close parenthesis on subquery.

Request:

RETS URL: https://ccar-rets.paragonrels.com/ret... Username: 20629

Search query: (U_user_is_active=|1),(U_State=~WV,WY) Request: SearchType=ActiveAgent&Class=ActiveAgent&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(U_user_is_active=|1),(U_State=~WV,WY)&Offset=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_PhoneNumber1Ext,AO_PhoneNumber1,AO_OrgState,AO_HiddenOtyID,AO_WebPage,AO_OrgZip,AO_PhoneNumber1Desc,U_BoardDuesPaidThrough,U_CorpPACContribYTD,U_InputDate,U_AgentTypeChangeDate,U_DateAssignedToOrg,U_DateKeyAssigned,U_StateAgentIsMemberOfDate,U_Dist,U_DuesPaidToBoard,U_Hash,U_LastTrig,U_Char255_1,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,U_UpdateAgent,U_UpdateDate,UP_AgentPhone,U_UserCode,U_Photos RETS Status code = 20206: Missing close parenthesis on subquery.

Also tried without the State restriction and got the same error. Search query: (U_user_is_active=|1) Request: SearchType=ActiveAgent&Class=ActiveAgent&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(U_user_is_active=|1)&Offset=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_PhoneNumber1Ext,AO_PhoneNumber1,AO_OrgState,AO_HiddenOtyID,AO_WebPage,AO_OrgZip,AO_PhoneNumber1Desc,U_BoardDuesPaidThrough,U_CorpPACContribYTD,U_InputDate,U_AgentTypeChangeDate,U_DateAssignedToOrg,U_DateKeyAssigned,U_StateAgentIsMemberOfDate,U_Dist,U_DuesPaidToBoard,U_Hash,U_LastTrig,U_Char255_1,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,U_UpdateAgent,U_UpdateDate,UP_AgentPhone,U_UserCode,U_Photos

Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2022-08-17 16:02:41 -0500

This should be fixed now. Please verify that it is working.

edit flag offensive delete link more

Comments

This is fixed. Thank you.

user_123456 gravatar imageuser_123456 ( 2022-08-17 16:45:36 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2022-08-17 13:06:40 -0500

Seen: 31 times

Last updated: Aug 17