First time here? Check out the FAQ!

Missing some offices , querying using lo1_shortname


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

realtyexecutives's avatar
asked 2019-02-21 10:12:22 -0500, updated 2019-02-21 10:17:05 -0500
edit flag offensive 0 remove flag 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's avatar bwolven (2019-02-21 10:39:53 -0500) 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's avatar realtyexecutives (2019-02-21 10:46:46 -0500) edit

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

bwolven's avatar bwolven (2019-02-21 10:53:46 -0500) edit
add a comment see more comments

1 Answer


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.

bwolven's avatar
answered 2019-02-21 11:42:59 -0500, updated 2019-02-21 13:51:51 -0500
edit flag offensive 0 remove flag delete link


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's avatar realtyexecutives (2019-02-25 12:03:23 -0500) edit

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

bwolven's avatar bwolven (2019-02-25 12:05:58 -0500) 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's avatar realtyexecutives (2019-03-06 13:21:56 -0500) 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's avatar realtyexecutives (2019-03-06 13:23:04 -0500) 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's avatar Sadie (2019-03-06 15:11:45 -0500) edit

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

realtyexecutives's avatar realtyexecutives (2019-03-06 16:28:39 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer