Ask Your Question

How To Reconcile Statuses That Don't Get Returned

asked 2020-07-29 22:01:31 -0600

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.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-07-30 09:01:22 -0600

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.

edit flag offensive delete link more


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 gravatar imageChrisC ( 2020-07-30 21:20:05 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-29 22:01:31 -0600

Seen: 160 times

Last updated: Jul 30 '20