Requesting listing by date/time

thaar
retag add tags

Hello!

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

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

edit flag offensive 0 remove flag close merge delete

Comments

Any update on this one?

daniel.williams (2019-09-23 08:42:29 -0500) edit

add a comment see more comments

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: http://paragonconnect.paragonrels.com...

Sadie

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

edit flag offensive 0 remove flag delete link

Comments

LoginName - fcRETS

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 (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 (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 (2019-09-25 09:28:55 -0500) edit

You are very welcome!

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 (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 (2019-10-09 09:35:05 -0500) edit

bwolven, how can we get this modified?

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 (2019-10-09 10:47:14 -0500) edit

add a comment see more comments

Requesting listing by date/time

Comments

1 Answer

Comments

Your Answer

Requesting listing by date/time edit

Comments

1 Answer

Comments

Your Answer

Requesting listing by date/time