RETS Support Article

The following steps illustrate how the sync algorithm works:

1. The RETS client sends a request to the RETS server using LastModifiedDateTime >= SomeDate SomeTime in the Query argument and selects four or less columns, such as ListingRid, LastModifiedDateTime, PictureModifiedDateTime, and PictureCount.

Here is an example of this type of search:

The RETS server will return an unlimited number of records to the RETS client that have changed since the LastModifiedDateTime value that was provided.

2. The RETS client builds a DB table locally and compares this search result data to what it already has in its own database. The RETS Client can now determine when changes were made to any of the search result records from Step 1 and can subsequently update its own records from the RETS server for those ListingRid values.

3. The RETS client sends a request to the RETS server using a delimited list of ListingRid values in the Query argument and omits the Select argument. The response will contain a complete data set for those records that were requested. If necessary, the RETS client sends additional search requests to the RETS Server, batching through the ListingRid values, until it has all the records.

Here is an example of this type of search:

4. The RETS client now has all the changed records and is fully synchronized with the RETS server.

If you would like a further explanation as to why Rapattoni suggests this method or how the sync algorithm works, please feel free to contact Rapattoni RETS Support. We will be happy to assist you.