Ask Your Question

Unauthorized Query Table

asked 2020-03-04 10:53:08 -0600

I am able to access the account via the RETS client, but receive this error when running a query against any table.

Unauthorized Query. You are not authorized to access class [Office] in resource [Office]

username: LatterBlum

Please let me know what I am doing wrong.

Thank you and kind regards: David Gumpper Acting CTO Latter & Blum

edit retag flag offensive close merge delete


Can you supply the RETS URL you are using and the account name (NO PASSWORDS).

bwolven gravatar imagebwolven ( 2020-03-04 10:55:30 -0600 )edit
dgumpper-lb gravatar imagedgumpper-lb ( 2020-03-04 10:57:43 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2020-03-04 11:11:49 -0600

updated 2020-03-04 11:13:22 -0600

Looks like your account limits access to the ActiveAgent and ActiveOffice resources.
It doesn't allow access to the Agent or Office resource.

edit flag offensive delete link more


Thanks. I will have to check with Jo at the Bayou Board of Realtors.

dgumpper-lb gravatar imagedgumpper-lb ( 2020-03-04 11:33:27 -0600 )edit

Hi: Jo did make some changes to give us access. We are now seeing the following error when we query a table.

Error detected: server failed the request Request: SearchType=Office&Class=Office&Format=COMPACT&QueryType=DMQL2&Query=(O_OfficeID=0%2B)&Select=O_OfficeID,O_OrganizationName RETS Status code = 20200: Unknown Query Field [L_ListOffice1]

I don't know why the Unknown Query Field error. The query is against the Office resource and not the Property resource.

Thank you and Kind regards: David

dgumpper-lb gravatar imagedgumpper-lb ( 2020-03-05 13:18:13 -0600 )edit

This should be fixed now. Please verify that both Agent and Office searches are working.

bwolven gravatar imagebwolven ( 2020-03-05 13:46:12 -0600 )edit

Is it working for you now?

bwolven gravatar imagebwolven ( 2020-03-05 15:29:33 -0600 )edit

Yes, I was successful in pulling the three offices for Latter & Blum. Thank you very much!

dgumpper-lb gravatar imagedgumpper-lb ( 2020-03-05 16:37:20 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-03-04 10:53:08 -0600

Seen: 15,988 times

Last updated: Mar 04 '20