First time here? Check out the FAQ!

Unauthorized Query Table

  • retag add tags

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

dgumpper-lb's avatar
asked 2020-03-04 10:53:08 -0500
edit flag offensive 0 remove flag close merge delete


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

bwolven's avatar bwolven (2020-03-04 10:55:30 -0500) edit

account name: LatterBlum

dgumpper-lb's avatar dgumpper-lb (2020-03-04 10:57:43 -0500) edit
add a comment see more comments

1 Answer


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

bwolven's avatar
answered 2020-03-04 11:11:49 -0500, updated 2020-03-04 11:13:22 -0500
edit flag offensive 0 remove flag delete link


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

dgumpper-lb's avatar dgumpper-lb (2020-03-04 11:33:27 -0500) 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's avatar dgumpper-lb (2020-03-05 13:18:13 -0500) edit

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

bwolven's avatar bwolven (2020-03-05 13:46:12 -0500) edit

Is it working for you now?

bwolven's avatar bwolven (2020-03-05 15:29:33 -0500) edit

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

dgumpper-lb's avatar dgumpper-lb (2020-03-05 16:37:20 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer