Ask Your Question

Requesting listing by date/time

asked 2019-09-20 10:32:45 -0600


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!!

edit retag flag offensive close merge delete


Any update on this one?

daniel.williams gravatar imagedaniel.williams ( 2019-09-23 08:42:29 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2019-09-23 15:41:18 -0600

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:

edit flag offensive delete link more


LoginName - fcRETS

murtu gravatar imagemurtu ( 2019-09-24 00:43:10 -0600 )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 gravatar imagedaniel.williams ( 2019-09-24 09:15:11 -0600 )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 gravatar imageSadie ( 2019-09-24 11:24:23 -0600 )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 gravatar imagedaniel.williams ( 2019-09-25 09:28:55 -0600 )edit

You are very welcome!

Sadie gravatar imageSadie ( 2019-09-25 09:45:04 -0600 )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 gravatar imagedaniel.williams ( 2019-10-09 08:04:08 -0600 )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 gravatar imagebwolven ( 2019-10-09 09:35:05 -0600 )edit

bwolven, how can we get this modified?

daniel.williams gravatar imagedaniel.williams ( 2019-10-09 10:36:17 -0600 )edit

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

bwolven gravatar imagebwolven ( 2019-10-09 10:47:14 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-20 10:32:45 -0600

Seen: 469 times

Last updated: Sep 24 '19