Ask Your Question

Missing some offices , querying using lo1_shortname

asked 2019-02-21 10:12:22 -0600

updated 2019-02-21 10:17:05 -0600


Some of the offices in the property class do not have entries in the office class. For example, I am pulling the following offices from the Residential property class by shortname - AMSR01, RMGP01, ADAM06, RMOB01, RNET01. They do not exist in the office class. I have verified that these offices are active since they have current listings in 2019. What could possibly be the issue with missing some offices but being to able to see others?

RETS URL used to access - RETS account name - REIS

Thanks, Usha

edit retag flag offensive close merge delete


Using your account with this query: (O_ShortName=AMSR01,RMGP01,ADAM06,RMOB01,RNET01)
I was able to pull all 5 of these from the Office resource.

bwolven gravatar imagebwolven ( 2019-02-21 10:39:53 -0600 )edit

That is strange - thanks so much for checking immediately. So, what could the reason? I have checked with the MLS team, and they mentioned that there are no filters on the feed so we should be receiving all the data. We are not adding any filters while pulling data either so I am not sure how we are missing a few offices.

Have you had such an issue occur before? Would appreciate if you could advise on what could be the possible reasons for such a problem. Thanks!

realtyexecutives gravatar imagerealtyexecutives ( 2019-02-21 10:46:46 -0600 )edit

I was also able to pull them from the ActiveOffice resource.

bwolven gravatar imagebwolven ( 2019-02-21 10:53:46 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2019-02-21 11:42:59 -0600

updated 2019-02-21 13:51:51 -0600

Possible Reasons: * Batching normally you can pull a certain amount of records in a single search. Normal limit is 2500. To get all records when this happens you would need to use Offset/Limit functionality and pull using sequential search batches. For example: Offset=1, Limit=2500; Offset=2501, Limit=2500; etc. * Profile filtering on particular resources and class. The MLS may limit the accessable data for certain classes within the profile. * Profile field selections. A field could be disabled in the profile in which case it returns the data as blank and searching the field would fail. * An agent or office can go inactive for a while or something change that effects the filtering such as a short name value. Normally the key field value for a record doesn't change. Such as in this case, O_OfficeID. If you are storing data locally, I would use the keyfield value as the unique identifier. If your profile has access to the Office resource use it instead of ActiveOffice because it should return the office as long as it is still in the system. * There can be other changes such as an office's board selection being changed when the profile has board filtering on it. Sometimes the data returned is limited by office or Main Office. * To work around issues you can normally get a list of all the O_OfficeID values maybe once a day, then compare to your local set to find any that are missing. Then just do incremental checks by O_UpdateDate at a few other times during the day. * Another thing is if your code pulling offices isn't handling errors properly and removes the offices instead of detecting there was an error during the pull and retrying later.

edit flag offensive delete link more


Thank you for this. The limits appear to be the issue. We have taken care of it. I will let you know if it does not resolve itself in the next couple of downloads.

realtyexecutives gravatar imagerealtyexecutives ( 2019-02-25 12:03:23 -0600 )edit

Glad to hear you have found a fix for the issue.

bwolven gravatar imagebwolven ( 2019-02-25 12:05:58 -0600 )edit


The limits issue took care of most of the missing offices. We are now seeing for the offices I mentioned in the query before. We are still missing a few offices. These seem to predominantly buyer offices and all start with the same prefix. I am wondering if there is some pattern here as opposed to just limits. I can provide the entire list (about 232 out of 552 offices). Here are some examples - BAY_B30LP BAY_BCAT BAY_BCOM BAY_BEFLE BAY_BEXR BAY_BHR1 EMC_BSA2 EMC_E3LP EMC_EAJ ZEKW7

realtyexecutives gravatar imagerealtyexecutives ( 2019-03-06 13:21:56 -0600 )edit

Could you also tell me how many offices we should be receiving in the office class. I currently show 1569 records in our download today. Does that match with what you have?

realtyexecutives gravatar imagerealtyexecutives ( 2019-03-06 13:23:04 -0600 )edit

Your current RETS Profile is filtered to the board of 'PARMLS' for Office and ActiveOffice resources. For specific counts and relative information on filtering for 'PARMLS' boards, you will need to contact the MLS directly.

Sadie gravatar imageSadie ( 2019-03-06 15:11:45 -0600 )edit

Thank you , I will check with the MLS contact and get back if I do not find any resolution.

realtyexecutives gravatar imagerealtyexecutives ( 2019-03-06 16:28:39 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-21 10:12:22 -0600

Seen: 547 times

Last updated: Feb 21 '19