First time here? Check out the FAQ!

Mapping the listing and open house tables

  • retag add tags

This is for

We have difficulties to map the listing id between the OpenHouse and listings. The Listings tables provide L_ListingID & L_DisplayID fields and both have the same values. Below is the sample data from Listings: <columns> L_ListingID L_DisplayId </columns> <data> 40806752 40806752 </data> <data> 40818305 40818305 </data> <data> 40818478 40818478 </data> <data> 40818550 40818550 </data> <data> 40818926 40818926 </data>

The OpenHouse table provide L_DisplayID & L_ListingID fields. Both have different values, but none of them are matching with the L_ListingID/L_DisplayID in Listings tables. Below is the sample data from OpenHouse: <columns> L_DisplayId L_ListingID </columns> <data> ML81694196 52139101 </data> <data> ML81694062 52138971 </data> <data> ML81694062 52138971 </data> <data> ML81694438 52139722 </data> <data> ML81692128 52137218 </data> <data> ML81694438 52139722 </data> <data> ML81691730 52136840 </data> <data> ML81693724 52138645 </data> <data> ML81694831 52139684 </data> <data> ML81694831 52139684 </data>

Please advise which field should we use in both Listings and OpenHouse tables for mapping purpose.

Wuri's avatar
asked 2018-12-18 10:54:45 -0500
edit flag offensive 0 remove flag close merge delete


What account are you using for MAXEBRDI?

bwolven's avatar bwolven (2018-12-18 11:01:55 -0500) edit

UserID = trend

We just got approval from the MLS director to have access to Open House data. I sent this question to him and he suggested me to post it in here.

Wuri's avatar Wuri (2018-12-18 11:03:43 -0500) edit
add a comment see more comments

1 Answer


I would use the L_ListingID field to link Property and OpenHouse information.
Due to the way filtering is configured for your account, you may be able to access OpenHouse information on properties your account profile doesn't allow access to through the Property resource.

bwolven's avatar
answered 2018-12-18 11:46:57 -0500
edit flag offensive 0 remove flag delete link


1). The values between L_ListingID in Property and OpenHouse are not matching for all properties. Are you sure we can use L_ListingID?

2). Why is both L_ListingID and L_DisplayID in Property show the same value for the same property? Should it be different, perhaps one of them can be mapped for OpenHouse?

Wuri's avatar Wuri (2018-12-18 11:51:25 -0500) edit

For now if you add this to your existing OpenHouse Query: "~(L_DisplayID=ML*) " to filter out properties you can't access it should help.
The L_DisplayID is a character field and allows the MLS to add a board prefix to listings from that board if desired.
Not all use this option.

bwolven's avatar bwolven (2018-12-18 13:43:00 -0500) edit

It worked. Thank you for your help.

Wuri's avatar Wuri (2018-12-18 14:56:12 -0500) edit

Glad to hear you are working now.

bwolven's avatar bwolven (2018-12-18 15:00:25 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer