I can't get all properties.

asked 2018-12-19 12:46:42 -0600

updated 2018-12-19 13:28:57 -0600

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"

edit retag flag offensive close merge delete


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

bwolven gravatar imagebwolven ( 2018-12-19 13:22:50 -0600 )edit

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

bwolven gravatar imagebwolven ( 2018-12-19 14:25:07 -0600 )edit

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

mclainproperties gravatar imagemclainproperties ( 2018-12-19 14:45:45 -0600 )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 gravatar imagebwolven ( 2018-12-19 15:02:43 -0600 )edit

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

bwolven gravatar imagebwolven ( 2018-12-19 15:12:33 -0600 )edit

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

mclainproperties gravatar imagemclainproperties ( 2018-12-19 15:21:33 -0600 )edit

Did you get those properties with PHRETS?

mclainproperties gravatar imagemclainproperties ( 2018-12-19 15:22:36 -0600 )edit

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

bwolven gravatar imagebwolven ( 2018-12-19 15:30:12 -0600 )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 gravatar imagebwolven ( 2018-12-19 16:10:49 -0600 )edit

Were you able to get this working?

bwolven gravatar imagebwolven ( 2019-01-11 09:14:23 -0600 )edit