First time here? Check out the FAQ!

How To Reconcile Statuses That Don't Get Returned

  • retag add tags

Rets URL: Account Name: 968654

Wondering how best to reconcile properties that are in statuses that aren't returned through incremental pulls. I have the following scenario:

  • Property accidentally listed as active by realtor
  • Our site pulled the property and it is showing on the site
  • Realtor corrects the mistake and sets the property to status "no-show"
  • We pull and don't get the status update because the "no-show" status is not returned by the rets feed ( even though we request that status )
  • Property now is orphaned on the site with the incorrect status when it shouldn't be there at all.

Not sure the best strategy to handle this. Thank you.

ChrisC's avatar
asked 2020-07-29 22:01:31 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


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.

bwolven's avatar
answered 2020-07-30 09:01:22 -0500
edit flag offensive 0 remove flag delete link


Thank you for the response. We were doing this at one point exactly as you described. Our account was locked because the query was too much for their system? Doesn't sound like there is really any other strategy to do it though?

ChrisC's avatar ChrisC (2020-07-30 21:20:05 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer