Ask Your Question
0

Accessing Open House on THAAR

asked 2019-09-09 10:42:22 -0500

Hello,

We're trying to access the open house feed from THAAR and according to RetsMD.com, it's an available resource. However, I don't think I'm accessing the info right. Here are the queries I tried:

1) {"SearchType":"OpenHouse","Class":"RE_1","QueryType":"DMQL2","Query":"(OH_StartDateTime=2018-08-01T00:00:00+),(OH_StartDateTime=2019-09-09T00:00:00-)","Limit":"100","Offset":0,"Format":"COMPACT-DECODED","StandardNames":"0"}

2) {"SearchType":"OpenHouse","Class":"RE_1","QueryType":"DMQL2","Query":"(L_UpdateDate =2018-08-01T00:00:00+),(L_UpdateDate =2019-09-09T00:00:00-)","Limit":"100","Offset":0,"Format":"COMPACT-DECODED","StandardNames":"0"}

Can you let me know how I'm doing the query wrong? Thank you!

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-09-09 10:49:49 -0500

You could use a range search like this:
(OH_StartDateTime=2018-08-01T00:00:00-2019-09-09T00:00:00)
Also please make sure to URL escape the query so the + doesn't get changed to space in your original.

edit flag offensive delete link more

Comments

One other thing is that OH_StartDateTime is in UTC.

bwolven gravatar imagebwolven ( 2019-09-09 10:53:45 -0500 )edit

Thank you again!

daniel.williams gravatar imagedaniel.williams ( 2019-09-09 11:24:45 -0500 )edit

Using query (OH_StartDateTime=2018-08-01T00:00:00-2019-09-09T00:00:00) with your account I show 150 RE_1 Open House records being returned.

bwolven gravatar imagebwolven ( 2019-09-09 11:28:20 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-09 10:42:22 -0500

Seen: 21 times

Last updated: Sep 09