Ask Your Question

Mapping the listing and open house tables

asked 2018-12-18 10:54:45 -0600

Wuri gravatar image

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.

edit retag flag offensive close merge delete


What account are you using for MAXEBRDI?

bwolven gravatar imagebwolven ( 2018-12-18 11:01:55 -0600 )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 gravatar imageWuri ( 2018-12-18 11:03:43 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2018-12-18 11:46:57 -0600

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.

edit flag offensive delete link more


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 gravatar imageWuri ( 2018-12-18 11:51:25 -0600 )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 gravatar imagebwolven ( 2018-12-18 13:43:00 -0600 )edit

It worked. Thank you for your help.

Wuri gravatar imageWuri ( 2018-12-18 14:56:12 -0600 )edit

Glad to hear you are working now.

bwolven gravatar imagebwolven ( 2018-12-18 15:00:25 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-18 10:54:45 -0600

Seen: 31 times

Last updated: Dec 18 '18