Ask Your Question

Issue with Residential media data

asked 2018-10-12 10:46:00 -0600

updated 2018-10-12 11:27:58 -0600

Hi , we have rets feed with Bayou Board of Realtors Loginurl: Username: Constellation Can you please check listingid=127718 when we pull that data its throwing us an error, one of the row which is marked in red below has more columns than expected

L_ListingID|L_StatusCatID|L_StatusID|L_UpdateDate|L_DisplayId|MED_listing_media_id|MED_listing_media_type_id|MED_sequence|MED_media_url|MED_create_dt|MED_update_dt|L_Status 127718|Active|0|2018-10-12T11:49:46.2|127718|273398|1|0|//|2018-01-19T03:21:18.9|2018-01-19T03:21:18.9|Active

Normally this is the how row should look but below is the one thats having isue

**<rets replycode="0" replytext="Operation Successful" &gt;<count="" records="58"/><delimiter value="09"/><columns>|L_ListingID|L_StatusCatID|L_StatusID|L_UpdateDate|L_DisplayId|MED_listing_media_id|MED_listing_media_type_id|MED_sequence|MED_media_url|MED_create_dt|MED_update_dt|L_Status|</columns>127718|Active|0|2018-10-12T11:49:46.2|127718|273398|1|0|//|2018-01-19T03:21:18.9|2018-01-19T03:21:18.9|Active

edit retag flag offensive close merge delete


So you are returning compact data, but the number of tabs isn't correct?

bwolven gravatar imagebwolven ( 2018-10-12 11:20:17 -0600 )edit

yes!! this is the one thats giving trouble , its in one row **<rets replycode="0" replytext="Operation Successful" &gt;<count="" records="58"/><delimiter value="09"/><columns>|L_ListingID|L_StatusCatID|L_StatusID|L_UpdateDate|L_DisplayId|MED_listing_media_id|MED_listing_media_type_id|MED_sequence|MED_media_url|MED_create_dt|MED_update_dt|L_Status|</columns>127718|Active|0|2018-10-12T11:49:46.2|127718|273398|1|0|//

brokersolutions gravatar imagebrokersolutions ( 2018-10-12 11:23:05 -0600 )edit

When I pull media for 127718 I only get 25 records returned not the 58 you show?

bwolven gravatar imagebwolven ( 2018-10-12 11:30:09 -0600 )edit

I'm not seeing anything wrong with the 25 media records for this listing?
I've even counted the tabs with 12 fields in select there are 13 tabs per row * 26 rows = 338 which is exactly what is returned.
Query: (ListingID=127718) from Media, class RE_1
Select: L_ListingID,L_StatusCatID,L_StatusID,L_UpdateDate,L_DisplayId,MED_listing_media_id,MED_listing_media_type_id,MED_sequence,MED_media_url,MED_create_dt,MED_update_dt,L_Status

bwolven gravatar imagebwolven ( 2018-10-12 15:18:23 -0600 )edit

We found the issue with this and should have a fix today or tomorrow.

bwolven gravatar imagebwolven ( 2018-10-15 09:55:08 -0600 )edit

We have a fix for this issue and it should be deployed 10/16/18.

bwolven gravatar imagebwolven ( 2018-10-15 16:43:05 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2018-10-16 10:08:45 -0600

2018-10-16 09:30 CST - The issues with the Media should be fixed now. Can you verify that is its working?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-12 10:46:00 -0600

Seen: 343 times

Last updated: Oct 16 '18