Pull properties

import json
import urllib.request

url = "https://YOUR_HOST"
db = "YOUR_DB"
uid = 2
password = "YOUR_API_KEY"

fields = [
    "id",
    "record_name",
    "name",
    "reference",
    "street",
    "street_number",
    "zip",
    "city",
    "estate_asking_price",
    "estate_rental_price",
    "is_sale_transaction",
    "is_rent_transaction",
    "real_estate_type",
    "responsible_realtor_id",
    "website_published",
    "is_live_on_immoweb",
    "is_live_on_immoscoop",
    "whise_estate_id",
    "advertisement_title",
]

payload = {
    "jsonrpc": "2.0",
    "method": "call",
    "params": {
        "service": "object",
        "method": "execute_kw",
        "args": [
            db,
            uid,
            password,
            "real_estate.real_estate",
            "search_read",
            [[["active", "=", True], ["website_published", "=", True]]],
            {"fields": fields, "limit": 50},
        ],
    },
    "id": 2,
}

req = urllib.request.Request(
    f"{url}/jsonrpc",
    data=json.dumps(payload).encode(),
    headers={"Content-Type": "application/json"},
)
records = json.load(urllib.request.urlopen(req))["result"]

records = models.execute_kw(
    db, uid, password,
    "real_estate.real_estate",
    "search_read",
    [[["active", "=", True]]],
    {"fields": ["id", "record_name", "estate_asking_price", "city"], "limit": 50},
)

fields_get = models.execute_kw(
    db, uid, password,
    "real_estate.real_estate",
    "fields_get",
    [],
    {"attributes": ["string", "help", "type", "relation", "selection"]},
)