Ask Your Question
0

Unauthorized Query Table

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

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

Comments

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

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

1 Answer

Sort by ยป oldest newest most voted
0

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

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

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

Comments

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 -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 gravatar imagedgumpper-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 gravatar imagebwolven ( 2020-03-05 13:46:12 -0500 )edit

Is it working for you now?

bwolven gravatar imagebwolven ( 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 gravatar imagedgumpper-lb ( 2020-03-05 16:37:20 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 38 times

Last updated: Mar 04