Ask Your Question

Malformed query???

asked 2021-09-13 10:54:27 -0600


CCAR disabled our account and we were told that the following RETS query was malformed and causing performance issues: rets-version=rets/1.7.2&SearchType=Office&Class=Office&Format=COMPACT-DECODED&Limit=1&Query=(O_OfficeID=305668)&QueryType=DMQL2

This query doesn't return any result as it seems that the office id doesn't exist but we're not sure why this query would cause issues prompting our account to be disabled?

Our account name: AVP-flyhomes

Thanks, Bruno

edit retag flag offensive close merge delete


Hello Bruno!

I'm unable to find an account with the login name of AVP-flyhomes. You are using Coastal Carolinas? Once we know this, we'll be better able to give you an answer.

Thank you,

Sadie gravatar imageSadie ( 2021-09-13 11:44:43 -0600 )edit

Hi Sadie,

We're using Contra Costa Association of REALTORS (CCAR) in California.

Thanks, Bruno

brunob gravatar imagebrunob ( 2021-09-13 15:16:26 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2021-09-13 15:51:37 -0600

Thank you!

So I've taken a look, I don't think it was necessarily that particular request - the issue looks more to be that there is only a single listing/office or agent being requested at once, at one point this issues up to 167 requests in a minute. In order to be not flagged you will need to start issuing requests in batches,using multiple sets of listings that are comma separated at a time. Below is some helpful documentation to optimize your query (Starting ~ page 11):

Hopefully that helps!

Thank you,

edit flag offensive delete link more


Sadie, this is helpful. Can you share the request limit per minute?

brunob gravatar imagebrunob ( 2021-09-13 16:17:57 -0600 )edit

There isn't necessarily a limit - but typically 500-1000 listings in a batch is sufficient for performance. Typically requesting around this amount instead of individual listings - will improve the speed as well.

Sadie gravatar imageSadie ( 2021-09-13 16:24:34 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-09-13 10:54:27 -0600

Seen: 178 times

Last updated: Sep 13 '21