Cullman feed metadata does not have lookup field values

edit

You can use something like this to pull the lookups: https://smlsa.paragonrels.com/OData/SMLSA/Strategic_17/Lookup?$top=50000&$filter=(LookupName%20eq%20%27StandardStatus%27)

In the metadata the lookup name is in the Annotation:
<property name="StandardStatus" type="Edm.String" nullable="true" maxlength="25">
<annotation term="RESO.OData.Metadata.LookupName" string="StandardStatus"/>
</property>

Ok, so we are able to get lookup values now. Question, some fields are listed as lookup in the metadata, such as BuyerOfficeAOR in the resource Property, but when queried for it, we get a 200 and empty list returned. Are these lookups that Cullman doesnt use?

Next, we queried for StandardStatus = Active and got our results, but some fields return with a [], such as Sewer. Sewer is a lookup field and has lookup values, but when you try any lookup value it returns a 500 error. Ex: https://smlsa.paragonrels.com/OData/SMLSA/Strategic_17/Property?$filter=(Sewer+eq+'Septic Tank')&$top=5&$count=true

Also, are there any docs to reference? We were only given 3 urls and 1 example queries for login.

Thank you

Since the type is Collection you would need to use a Lambda expression like this:

<property name="Sewer" type="Collection(Edm.String)" nullable="true">
<annotation term="RESO.OData.Metadata.LookupName" string="Sewer"/>
</property>

https://smlsa.paragonrels.com/OData/SMLSA/Strategic_17/Property?$filter=Sewer/any(s:s eq 'Septic Tank')

still having issues querying... figure out how to do more than 1 field such as in the documentation here https://github.com/RESOStandards/tran...

We need to search by more than 1 status and get a 500 trying to build logical and/or. Example

        query_dict = {'url': "https://smlsa.paragonrels.com/OData/SMLSA/Strategic_17/Property?$filter=(PropertyType+eq+'Residential')+and+(StandardStatus+eq+'Active'+or+StandardStatus+eq+'Provisional')&$top=200&$count=true"}

I can do (PropertyType+eq+'Residential')+and+(StandardStatus+eq+'Active'), but no mater how i format multiple StandardStatus I get a 500.

I need to be able to do residential and (active or coming soon or sold etc etc). Can you help with this?

Hi Andy,

A quick follow up from the other day. I was able to verify the syntax from above works just fine for me using Postman. Though, please be aware the Cullman data feed from SMLSA does not include the Incomplete status. If you'd like to start getting those listings, please reach out to the MLS.

https://smlsa.paragonrels.com/OData/smlsa/Strategic_17/Property?$count=true&$filter=PropertyType eq 'Residential' and (StandardStatus eq 'Active' or StandardStatus eq 'Incomplete')&$top=1&$select=ListingId,StandardStatus

"@odata.count": 574,