How to get How sold data
Hi team,
We are unable to fetch the sold status data from paragonrels.
URL - http://yuma-rets.paragonrels.com/rets...
User Name - genreal
0
2 Answers
- Sort by
oldest newest most voted
0
Hi Rakhesh,
The field in question is called L_HowSold. It was not enabled, but is now. You will need to check the Metadata for the lookup values.
<COLUMNS> L_ListingID L_Status L_HowSold </COLUMNS>
<DATA> 20224232 SOLD FHA </DATA>
My apologies for getting hung up on the word status, and not picking up on what you were trying to communicate in the screenshot. Hopefully, this is the answer you're looking for.
0
Hi Joe,
We are using this (L_StatusCatID=2),(ListingStatus=2) query to fetch the sold data from paragonrels. We are able to fetch all data except the Sold Status. We want to fetch sold data also.
Please help on this.
Comments
ListingStatus is not a valid RETS field. Here are the available fields for a listing's status and what they're used for.
L_Status: Concatenated form of L_StatusCatId and L_StatusID
eg: 2_0
L_StatusCatID: The category ID for the Status Category/Group
1: Active
2: Sold
3: Pending
L_StatusID: The ID for the specific Status in the Status Category/Group
We usually recommend just sticking with L_StatusCatID if you're pulling one specific status group. Also, please check the metadata for the specific statuses available if you use L_Status.
Hi Joe,
We have changed our query as you suggested but we are not able to fetch the Sold Status data.
And in which column we will get the How sold status.
Please suggest us.
Hi Joe,
Thanks for your support.
Now we are able to fetch the How Sold status.
Comments
Hello Rakhesh,
I'm sorry, but we can't reproduce. Using your credentials, and sending the following Query=(L_StatusCatID=2), we were able to pull sold listings. Further more, Query=(L_ListingId=20224232) returned the listing in your screenshot. Can you please verify with these two queries? If not, please include your query for us to review.