I can't get all properties.

  • retag add tags

Hi, there!

I tried to Integrate RETs with our project to populate db every 12 hrs.

But when I send requests to the api service, it returns only 34 properties. In the admin panel, I can see more properties.

I am using this PHP SDK. https://github.com/troydavisson/PHRETS

I am looking forward to hearing from you soon.

Thanks Paul

Account: 501080

URL: "https://spn-rets.paragonrels.com/rets/fnisrets.aspx/SPN/login?rets-version=rets/1.7.2"

mclainproperties's avatar
asked 2018-12-19 12:46:42 -0500
bwolven's avatar
updated 2018-12-19 13:28:57 -0500
edit flag offensive 0 remove flag close merge delete


Need more information to start.
What is your RETS URL and account name (NO PASSWORDS).

bwolven's avatar bwolven (2018-12-19 13:22:50 -0500) edit

What count are you expecting to receive for query: (LM_char10_48=01292308) ?
I show 29 for the RE_1 class.

bwolven's avatar bwolven (2018-12-19 14:25:07 -0500) edit

please check this one. https://www.dropbox.com/s/v1inl9g6s9q... It shows me more than 33,000 properties.

mclainproperties's avatar mclainproperties (2018-12-19 14:45:45 -0500) edit

There are only 84 records total in the DB that match (LM_char10_48=01292308).
Some are being filtered out by your account profile settings.
Are you sure you are querying the right field?
If I use this query "(L_ListingID=0+)" I get a count of 759,264 on RE_1 class.

bwolven's avatar bwolven (2018-12-19 15:02:43 -0500) edit

If you change your search query to: (L_Status=|1_0,1_2) it will return ACT and BOM 33,232 records.

bwolven's avatar bwolven (2018-12-19 15:12:33 -0500) edit

https://www.dropbox.com/s/vtjqqscxza5... I need to get all the properties in these classes...

mclainproperties's avatar mclainproperties (2018-12-19 15:21:33 -0500) edit

Did you get those properties with PHRETS?

mclainproperties's avatar mclainproperties (2018-12-19 15:22:36 -0500) edit

I got them using your account information and the query (L_Status=|1_0,1_2).

bwolven's avatar bwolven (2018-12-19 15:30:12 -0500) edit

For the RE_1 class, you may need to use the Offset and Limit functionality to get all of the data.
Your profile is currently limited to 2500 records per transaction for Property searches.
So you would set Offset=1, Limit=2500 for first set then Offset-2501, Limit=2500 for second set etc.
Then terminate when no records are returned or no records found status returned or something like that.

bwolven's avatar bwolven (2018-12-19 16:10:49 -0500) edit

Were you able to get this working?

bwolven's avatar bwolven (2019-01-11 09:14:23 -0500) edit
add a comment see more comments