Ask Your Question
0

Strategic MLS Alliance Missing Listings [closed]

asked 2022-12-06 11:12:46 -0600

updated 2022-12-06 11:18:28 -0600

When pulling non-sold listings we only get around 1000+ listings when the original had over 2000+. Is there a reason the amount is almost halved?

User: SMLSARelianceNetwork URL: https://smlsa.paragonrels.com/OData/$...

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by chglfish
close date 2022-12-06 15:50:40.725370

1 Answer

Sort by ยป oldest newest most voted
0

answered 2022-12-06 11:16:59 -0600

updated 2022-12-06 11:19:03 -0600

There are internal limits to the number of records in a single transaction.
To batch the records you would use $skip and $top to pull all the available records a batch at a time.

edit flag offensive delete link more

Comments

Any hint on why this feed is behaving much differently from other Paragon Web API feeds? Even with a select on ListingKeyNumeric / ModificationTimestamp, it seems we are not pulling all of them.

JF gravatar imageJF ( 2022-12-06 11:21:35 -0600 )edit

Basically, there is no @odata.nextLink, so we need to skip "manually"?

JF gravatar imageJF ( 2022-12-06 11:25:41 -0600 )edit

Correct. We don't currently support nextLink.

bwolven gravatar imagebwolven ( 2022-12-06 11:27:43 -0600 )edit

When using the $Count we get "@odata.count":1021, but the original RETS feed had 2116

chglfish gravatar imagechglfish ( 2022-12-06 11:28:38 -0600 )edit

bwolven can you confirm how many active listings are in the Strategic_17 feed?

JF gravatar imageJF ( 2022-12-06 12:57:12 -0600 )edit

It looks like the StandardStatus doesn't have a value in all Property Types
Try this: $filter=(MlsStatus ne '(20) Sold - Sold')
I show 2073 when I use that filter.

bwolven gravatar imagebwolven ( 2022-12-06 15:07:01 -0600 )edit

I get a 500 error when trying to use that filter

chglfish gravatar imagechglfish ( 2022-12-06 15:17:25 -0600 )edit

Just tried that, getting a 50x. Also tried with 20, '20' and 'Sold', same result.

JF gravatar imageJF ( 2022-12-06 15:18:17 -0600 )edit

Are you sending more than one $filter parameter?

bwolven gravatar imagebwolven ( 2022-12-06 15:21:51 -0600 )edit

I did it with modificationtimestamp and by itself. https://smlsa.paragonrels.com/OData/S... ne '(20) Sold - Sold'). Copied it from here to there.

chglfish gravatar imagechglfish ( 2022-12-06 15:23:52 -0600 )edit

There are two spaces after the (20)
I think the site is stripping extra spaces.

bwolven gravatar imagebwolven ( 2022-12-06 15:29:36 -0600 )edit

Yeah adding the space worked. Question on top & skip. . . when going over the sets of data, does top count from the skip, meaning do both have to increment or just top?

chglfish gravatar imagechglfish ( 2022-12-06 15:39:48 -0600 )edit

This works, thanks. Any chance this different format will be documented anywhere? The usual paragon api feeds are way easier to work with.

JF gravatar imageJF ( 2022-12-06 15:41:45 -0600 )edit

Skip is similar to RETS offset but $skip is zero based.
Top is similar to RETS limit, the number of rows to return.
So you would set your batch size with $top and increment $skip by the batch size.
So:
$skip=0&$top=10
$skip=10&$top=10
$skip=20&$top=10
etc.

bwolven gravatar imagebwolven ( 2022-12-06 15:45:08 -0600 )edit

I think RETS is easier to work with too.
But I'm a little biased since I have worked with RETS it for many years.
But I guess it is the wave of the future whether we like it or not.

bwolven gravatar imagebwolven ( 2022-12-06 15:48:25 -0600 )edit

SMLSA does not match the documentation, so it would be nice if there was some that matched up to it, given it seems to be nonstandard.

chglfish gravatar imagechglfish ( 2022-12-06 15:50:20 -0600 )edit

Question Tools

1 follower

Stats

Asked: 2022-12-06 11:12:46 -0600

Seen: 69 times

Last updated: Dec 06 '22