Ask Your Question

Revision history [back]

The way I normally suggest you do this is that once or twice a day:
* Run a query without a date filter like (L_ListingID=0+) or a status filter if you only show certain status values.
* Set field selection to return the L_ListingID and/or other fields flagged in the metadata with InKeyIndex=1.
* Set Limit=NONE
* Use the list returned to reconcile the data you have stored.

The goal is to only do this as frequently as absolutely necessary to meet your business requirements.
For some RETS feeds this list can be quite large depending on the user account configuration.

Note: Make sure to check your query's error return and handle properly to keep from inadvertently removing listings if a transaction fails for some reason. For example a RETS Refresh disables RETS while it is running so you could temporarily lose access.