Issue with Residential media data
Hi , we have rets feed with Bayou Board of Realtors Loginurl: http://bbr-rets.paragonrels.com/rets/... 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|//cdnparap60.paragonrels.com/ParagonImages/Property/P6/BBR/127718/0/0/0/587f03956bd627cde4d1e7c407c3fc59/1/59d5d39b32267189520cf52a3c8ef92f/127718.JPG|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" ><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|//cdnparap60.paragonrels.com/ParagonImages/Property/P6/BBR/127718/0/0/0/587f03956bd627cde4d1e7c407c3fc59/1/59d5d39b32267189520cf52a3c8ef92f/127718.JPG|2018-01-19T03:21:18.9|2018-01-19T03:21:18.9|Active
Comments
So you are returning compact data, but the number of tabs isn't correct?
yes!! this is the one thats giving trouble , its in one row **<rets replycode="0" replytext="Operation Successful" ><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|//cdnparap60.paragonrels.com/ParagonImages/Property/P6/BBR/127718/0/0/0/587f03956bd62
When I pull media for 127718 I only get 25 records returned not the 58 you show?
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
We found the issue with this and should have a fix today or tomorrow.
We have a fix for this issue and it should be deployed 10/16/18.