Ask Your Question

Recommended approach for purging listings that are no longer available

asked 2019-03-26 16:42:59 -0500


I'm looking for some advice on best practices as it relates to purging listings no longer available to us at the server. Typically this occurs when our client's IDX feed only entitles them to specific listing statuses (Active only, Active+Sold only, etc) - when listings switch to a status not available via the client's credentials, from our perspective, they effectively "disappear" from the feed.

This topic has been addressed by other vendors; example from FlexMLS's documentation below (see Step 3):

I would like to know your recommended approach, to ensure we stay compliant with the MLSs while also minimizing impact on the RETS server.

Please let me know if you need any additional information. Many thanks in advance for your assistance!

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-03-26 16:58:48 -0500

This would be similar to what they suggested in that link.
Paragon RETS does support InKeyIndex.

  • Once a day, request the keyfield value from the resource setting Limit=NONE. Make sure your HTTP request timeout is set to a high value because it can take a while sometimes to return the full set.
  • Alternatively, you can use the Offset, Limit functionality to return the data in batches until you pull the full set.
  • Use the list of keyfield values returned to determine which ones are no longer valid for your account.

Note: When you do this make sure to check the error responses to keep from wiping data that is still valid but wasn't included because of an error retrieving the list.
Basically, add some sanity checks to your purging process.

edit flag offensive delete link more


Thank you! This is very helpful. I will reach out if we have any additional questions.

IHRTechServices gravatar imageIHRTechServices ( 2019-03-27 15:04:10 -0500 )edit

Actually - one question - do all of Paragon RETS servers support InKeyIndex? Or does it vary depending on the client? We curate multiple MLSs' feeds data so it would be helpful to know from an efficiency standpoint if all Paragon servers can be treated the same. Thanks!

IHRTechServices gravatar imageIHRTechServices ( 2019-03-27 15:08:49 -0500 )edit

Yes all Paragon RETS servers do support InKeyIndex as I noted above.

bwolven gravatar imagebwolven ( 2019-03-27 15:11:01 -0500 )edit

Cool, just wanted to be absolutely sure. Thank you!

IHRTechServices gravatar imageIHRTechServices ( 2019-03-27 15:36:05 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-26 16:42:59 -0500

Seen: 81 times

Last updated: Mar 26 '19