Stack Overflow
Stack Overflow

Questions tagged [rets]

The Real Estate Transaction Standard (RETS) facilitates data transfer between partners in the real estate industry via XML/webservice calls. It is an improvement over the existing protocol/procedure called IDX (Internet Data exchange) which could mean HTTP webservices, CSV files from FTP, or in some cases via Telnet.

RETS is a standardized and Realtor Association of America backed protocol meant to help consolidate and simplify the process of a multiple listing service organization providing access to their respective real estate date. Part of this standardization process was the creation of a standard naming convention and schema for data, which is still in progress.

References and useful links

  • The RETS standard website

  • RETS online documentation website

  • The libRETS API library, a developer resource, is available. LibRETS is a C++ library with SWIG native bindings for .NET, Java, Perl, PHP 5, Python, and Ruby.

  • Rapattoni was one of the first MLS service providers to provide RETS support and fortunately they have extensive support documentation that can be applicable to other RETS servers.

  • Tutorial from Flex MLS on DMQL, the query language of RETS.

  • PHRETS open source PHP library for using RETS. PHRETS provides PHP developers a way to integrate RETS functionality directly within new or existing code. A standard class of functions is made available to developers to connect and interact with a server much like they would with other APIs.

136 questions
2
votes
1 answer

ddf standard xml format returns no records

I am using the code below to query the CREA DDF/RETS to retrieve listings in the XML format. When I specify the Standard-XML format, I get no records with no errors. If I do not specify the format, PHRETS defaults to Compact-Decoded format and…
spiderling
  • 139
  • 1
  • 2
  • 11
2
votes
1 answer

Can't get results from SearchQuery() in phrets

I can't seem to get the SearchQuery() function in phrets to return anything. I know my Resouce and Class. I also know the sysid of the field name I'm using in the query. Here is my code 

        

            

                
                 
                
                 
                
            

            

                
                    


    
    
        
    
    

        Doug Steinberg
        
    
            
  • 1,122
    • 
            
            
  • 14
    • 
            
  • 32
    •
2
votes
2 answers

PHP: Processing thousands of entries, script dies after certain amount

I'm calling an MLS service that responds with 4000+ records ... and I need to process each and every one of them, as well as insert all of the meta data per listing. I'm able to get to about 135 (* 150 meta records) and then the script apparently…
dcolumbus
  • 9,596
  • 26
  • 100
  • 165
2
votes
3 answers

How to configure Rets server in local wordpress

I am trying to connect to MLS Rets server in my local wordpress but can't connect. I also don't know how to use Rets Server and get data from there? Also need some real estate sample data for testing purpose. Does Anybody have any idea. How can I do…
Indian
  • 645
  • 7
  • 22
2
votes
5 answers

RETS or not RETS

We want to build a MLS application. We want to use a real MLS service as data source. What will be a better solution: using RETS directly or use a 3rd party data service to pull MLS data for us then query them for data? PS: If we want to use RETS…
Eks Wi
  • 23
  • 3
2
votes
3 answers

RETS and how to design our database table as it has lots of column and Query performance issues

Recently I'm working with RETS, So I have to download all data and save it to our webserver. I'm ussing MySQL and PHP. I saw on metadata that i has lots of columns. I think it will not wise decision to create 100+ columns in one table. If I do so I…
bdsarwar
  • 129
  • 1
  • 2
  • 9
1
vote
1 answer

Multi-Select Query Through PHRETS RETS System

I've got a system running RETS through the PHRETS system. I have a form, that runs through a query to pull out results, and we're adding in multi-select boxes. So far, my code looks like this for the query:…
Nicole
  • 123
  • 3
  • 16
1
vote
0 answers

Expected a dictionary type buy got instead

Basically, I using RETS to pull some listing from TREB using an MLS number. but I am getting below error while trying to iterate through the generator. Error: dmql_query = search_helper.filter_to_dmql(filter_dict=search_filter) File…
pefile
  • 69
  • 6
1
vote
2 answers

Node.js Express API with TypeScript 3 Update a record

I have setup Node.js Express API with TypeScript 3 and it is working fine. I got an issue when I try to update the record. RecordsRouter.ts import { Router } from 'express'; import {RecordComponent} from '../../components'; const router: Router =…
ZiaUllahZia
  • 1,072
  • 2
  • 16
  • 30
1
vote
1 answer

Need a little help figuring out how to append an array inside of a loop

I have a function that downloads photos from a server, using RETS. I want to take the path of the photos and store them in a JSON file for display on a carousel. The array function is inside a foreach loop, and it'll initialize but it'll only store…
rvor
  • 87
  • 1
  • 8
1
vote
2 answers

datetime field record exists but querying shows no record (DMQL)

I am making an api call to a db which requires using dmql to do queries. https://www.flexmls.com/developers/rets/tutorials/dmql-tutorial/ I have been following this tutorial on how to query, everything works fine until I am trying to query a…
Dora
  • 6,776
  • 14
  • 51
  • 99
1
vote
1 answer

How to correctly search (Real Estate Transaction Standard aka RETS) server?

I am trying to interact with a RETS (Real Estate Transaction Standard) server to find all listings where matrix_unique_id field is greater than or equal to 0. After logging in, I tried the following…
Junior
  • 11,602
  • 27
  • 106
  • 212
1
vote
2 answers

SearchQuery() doesn't run (undefined method PHRETS\Session::SearchQuery())

I am trying to extract some basic details from the RETS server using PHRETS but been getting this error [*Uncaught Error: Call to undefined method PHRETS\Session::SearchQuery() in D:\Software\XAMPP\htdocs\PHRETS-master\RetsExtract.php:21 Stack…
AutoMate
  • 71
  • 9
1
vote
3 answers

How to update new value to current field and transfer current value to old field?

I have a MySQL table that updates from an API daily, but now I want to track a specific field that has been updated from the API. I want to update the row with the current field(value) change and keep the old field(value) in another field. Could…
Edward
  • 77
  • 6
1
vote
2 answers

Dumping a RETS Data Feed

So I have a RETS data feed from Paragon I am trying to dump all this data into a CSV using phRETS library. I have tried many different ways to dump data from this RETS feed via dmql or libRETS and none of them are working. Here is my php code using…
hinsonan
  • 53
  • 8
1 2
3
…
9 10