First time here? Check out the FAQ!

Requesting listing by date/time


First, thank you for your help! This resource has been amazing. We're having a bit of trouble pulling in listings by date/time from THAAR.

Before, the vendor was using: Query:decodeURIComponent('(L_UpdateDate=2019-08-15T00%3A00%3A00%2B),(L_UpdateDate=2019-08-28T00%3A00%3A00-)'), and get 0 results.

The vendor changed it to this: { SearchType: 'Property', Class: 'RE_1', QueryType: 'DMQL2', Query: '(L_UpdateDate=2019-09-15T22:28:00-2019-09-19T09:48:00)', Limit: '100', Offset: 0, Format: 'COMPACT-DECODED', StandardNames: '0' }

but is only getting one result - 418 S Odd S Kingman, IN 47952. I looked at the other boards and there's definitely been more listings in that time frame. Are we still doing the date/time wrong? Is there official documentation that we should be referring to instead?

Thank you!!

daniel.williams's avatar
asked 2019-09-20 10:32:45 -0500
edit flag offensive 0 remove flag close merge delete


Any update on this one?

daniel.williams's avatar daniel.williams (2019-09-23 08:42:29 -0500) edit
add a comment see more comments

1 Answer


Apologies for the delayed response Daniel!

That looks correct on your second query, may I ask the LoginName (no password) the vendor is using? It sounds like maybe we need to take a look at the profile itself.

Side note, we have a great document for querying guidelines too:

Sadie's avatar
answered 2019-09-23 15:41:18 -0500
edit flag offensive 0 remove flag delete link


LoginName - fcRETS

murtu's avatar murtu (2019-09-24 00:43:10 -0500) edit

@Sadie, thank you for the response. I'm confirming that Murtu is our project manager and this is the correct login name.

daniel.williams's avatar daniel.williams (2019-09-24 09:15:11 -0500) edit

Thank you!

It looks like 1 is he correct number of listings for the account and RETS Profile associated to it. It appears to be filtered for Active and Pending, with the list office of F.C. Tucker Preferred. There is only one listing that has had an update between 9/15 and 9/19. If you'd like inquire about modifying this filter, you'll need to reach out to the MLS for more information.

Sadie's avatar Sadie (2019-09-24 11:24:23 -0500) edit

Thanks for the information. I've reached out to the THAAR board to find out if they are restricting our pulls to only F.C. Tucker Preferred.

daniel.williams's avatar daniel.williams (2019-09-25 09:28:55 -0500) edit

You are very welcome!

Sadie's avatar Sadie (2019-09-25 09:45:04 -0500) edit

Sadie, we're set on pulling in all listings now. In order to pull in pending or sold listings, is the query below correct?

{ SearchType: 'Property', Class: 'ResidentialProperty', Query: '(L_StatusCatID=2)', QueryType: 'DMQL2', Limit: 100, Format: 'COMPACT-DECODED', Offset: 0 }

{ SearchType: 'Property', Class: 'ResidentialProperty', Query: '(L_StatusCatID=3)', QueryType: 'DMQL2', Limit: 100, Format: 'COMPACT-DECODED', Offset: 0 }

daniel.williams's avatar daniel.williams (2019-10-09 08:04:08 -0500) edit

The queries you listed above look correct.
Are you still using the fcRETS login?
If so, the profile currently assigned to your account only allows access to Active: (L_StatusCatID=1).
So the searches will work but not return any records.
But it does return 546 active listings.

bwolven's avatar bwolven (2019-10-09 09:35:05 -0500) edit

bwolven, how can we get this modified?

daniel.williams's avatar daniel.williams (2019-10-09 10:36:17 -0500) edit

Sorry, but you would need to reach out to THAAR again.
The board controls who has access to what data in RETS.

bwolven's avatar bwolven (2019-10-09 10:47:14 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer