Accessing Open House Data
The open house class (tt_openhouse) is a very small data set in the Property resource. Because there are only a couple hundred records at any time, it is acceptable to download all of the records with one query.
Request:
GET /contact/rets/search?SearchType=Property&Class=tt_openhouse&Count=1&Format=COMPACT-DECODED&Limit=99999999&StandardNames=0 HTTP/1.1
Host: rets18.utahrealestate.com
Cookie: JSESSIONID=5D68F9F33819EAF6551F32C21B99DE29; RETS-Session-ID=52d95bb6a6a233164528902fbc0dc712159b370d4b9; JSESSIONID=5D68F9F33819EAF6551F32C21B99DE29
Accept: */*
RETS-Version: RETS/1.8
User-Agent: User-Agent
HTTP/1.1 200 OK
Server: Apache-Coyote/1.1
Set-Cookie: JSESSIONID=5D68F9F33819EAF6551F32C21B99DE29; Path=/contact
MIME-Version: 1.0
Cache-Control: private
RETS-Version: RETS/1.8
Content-Type: text/xml
Date: Wed, 18 Jan 2017 21:17:13 GMT
Transfer-Encoding: chunked
Proxy-Connection: Keep-alive
<RETS ReplyCode="0" ReplyText="Operation Successful">
<COUNT Records="149" />
<DELIMITER value="09" />
<COLUMNS> id listno lastmod startdt enddt </COLUMNS>
<DATA> 183205 1419070 2016-11-17T19:52:41 2017-02-18T16:00:00 2017-02-18T19:00:00 </DATA>
<DATA> 184389 1422826 2016-12-27T16:01:07 2017-01-31T11:00:00 2017-01-31T14:00:00 </DATA>
<DATA> 184506 1405059 2016-12-31T11:40:48 2017-01-20T14:00:00 2017-01-20T18:00:00 </DATA>
<DATA> 184507 1405059 2016-12-31T11:41:16 2017-01-21T11:00:00 2017-01-21T17:00:00 </DATA>
<DATA> 184508 1405059 2016-12-31T11:41:49 2017-01-23T14:00:00 2017-01-23T18:00:00 </DATA>
<DATA> 184509 1405059 2016-12-31T11:42:21 2017-01-27T14:00:00 2017-01-27T18:00:00 </DATA>
<DATA> 184510 1405059 2016-12-31T11:42:51 2017-01-28T12:00:00 2017-01-28T18:00:00 </DATA>
<DATA> 184511 1405059 2016-12-31T11:43:16 2017-01-30T14:00:00 2017-01-30T18:00:00 </DATA>
<DATA> 184518 1405037 2016-12-31T11:46:59 2017-01-20T14:00:00 2017-01-20T18:00:00 </DATA>
<DATA> 184519 1405037 2016-12-31T11:47:27 2017-01-21T11:00:00 2017-01-21T17:00:00 </DATA>
<DATA> 184520 1405037 2016-12-31T11:48:02 2017-01-27T14:00:00 2017-01-27T18:00:00 </DATA>
...
</RETS>
Keeping records in sync
To keep the open house records in sync it is best to download a new list each day and replace any records previously downloaded.