First time here? Check out the FAQ!

Ask Your Question

0

Accessing Open House on THAAR

thaar
retag add tags

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!

daniel.williams

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

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

Sort by

0

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.

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

edit flag offensive 0 remove flag delete link

Comments

One other thing is that OH_StartDateTime is in UTC.

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

Thank you again!

daniel.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 (2019-09-09 11:28:20 -0500) edit

add a comment see more comments

Your Answer

Login/Signup to Answer

here is how