Ask Your Question
0

Null (empty) values being pulled

asked 2016-09-28 16:05:47 -0500

updated 2016-10-13 11:20:44 -0500

Hi everyone,

We were pulling information through PHRETS, and one of our clients noticed that several fields were empty for several listings (example provided below). We were directed here and told that it could be an issue on "Black Night's" end. Here is an example of the empty values we are getting vs. the values from another source, WIREX/SAAR:

Values we pulled using PHRETS:http://collabshot.com/show/A7JShO http://collabshot.com/show/6FLuga http://collabshot.com/show/Gq4pYo

And here is a screenshot of the listing from another source:http://collabshot.com/show/yMJlfX

We are looking for the values in the 2nd source, that are not turning up in the 1st.

RETS URL is "http://saam-rets.paragonrels.com/rets/fnisrets.aspx/SAAM/login?rets-version=rets/1.7.2"

Account name is 'rnettleton'

edit retag flag offensive close merge delete

Comments

Anybody? Please help.

feedonomics gravatar imagefeedonomics ( 2016-10-03 18:34:44 -0500 )edit

Are you still having issues with this? Field access can be restricted by user profile. The column will be there, but the data would be empty.

bwolven gravatar imagebwolven ( 2016-10-04 13:51:07 -0500 )edit

Hi, thanks for the response! Yes we are still having issues. Who could open up field access if they were restricted?

feedonomics gravatar imagefeedonomics ( 2016-10-04 17:09:46 -0500 )edit

Can you give me a little more information? What URL are you using in PHRETS and the account name?

bwolven gravatar imagebwolven ( 2016-10-05 11:44:44 -0500 )edit

Hi bwolven, the URL is http://saam-rets.paragonrels.com/rets... and the account name is 'rnettleton'

feedonomics gravatar imagefeedonomics ( 2016-10-13 10:10:37 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2016-10-04 17:29:18 -0500

updated 2016-10-13 11:17:53 -0500

You would need to speak with the MLS to change the availability of the data fields.

Update 2016-10-13 11:20 CST - I checked your account and all the fields are enabled for your profile. But when I look at the search request you are sending. It looks like you are only requesting specific fields for return in the select parameter. Since I'm not exactly sure which data values you are missing I can't be sure whether you are requesting them or not.

Here are the only fields I see being requested since 2016-09-21:

L_ListingID,L_AskingPrice,L_Keyword2,L_Keyword3,L_SquareFeet,L_NumAcres,L_ListingDate,L_ExpirationDate,L_OriginalPrice,L_HowSold,L_ContractDate,L_ClosingDate,L_SoldPrice,L_InputDate,L_PictureCount,L_OffMarketDate,L_listings_associated_doc_count,L_DisplayId,LMD_MP_Latitude,LMD_MP_Longitude,LMD_MP_AddressLine,LMD_MP_PrimaryCity,LMD_MP_SecondaryCity,LMD_MP_Subdivision,LMD_MP_PostalCode,L_DOM,L_CDOM,LM_Char50_1,LM_Char50_4,LM_char5_1,LM_char10_53,VT_VTourURL,LR_remarks66,LR_remarks77,LA1_AgentID,LA1_UserFirstName,LA1_UserLastName,LA1_AddressStreet,LA1_Address2,LA1_City,LA1_State,LA1_Zip,LA1_PhoneNumber1Desc,LA1_PhoneNumber1,LA1_Email,LO1_OrganizationName,LO1_OrgAddressStreet,LO1_OrgAddress2,LO1_OrgCity,LO1_OrgState,LO1_OrgZip,LO1_PhoneNumber1Desc,LO1_PhoneNumber1,LO1_Email,LVC_Agent_Hit_Count,LVC_Client_Hit_Count

edit flag offensive delete link more

Comments

Thanks for checking! Using L_ListingID=51008 as an example, here are some null values: LMD_MP_PostalCode, VT_VTourURL, LMD_MP_Subdivision, L_SoldPrice, LM_Char50_1, L_OffMarketDate, L_HowSold, LMD_MP_SecondaryCity, L_ContractDate, L_ClosingDate, LMD_MP_PrimaryCity, LO1_OrgAddress2, LMD_MP_AddressLi

feedonomics gravatar imagefeedonomics ( 2016-10-19 16:10:51 -0500 )edit

All of the fields you listed except L_OffMarketDate which has a date, are empty for that listing.

bwolven gravatar imagebwolven ( 2016-10-19 16:50:15 -0500 )edit

Thanks bwolven!

feedonomics gravatar imagefeedonomics ( 2016-10-28 09:33:05 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-09-28 16:05:47 -0500

Seen: 144 times

Last updated: Oct 13 '16