List Deals

List Deal records.

Filtering & lookups

Any field listed below can be filtered on directly for an exact match (e.g. ?status=active), or suffixed with __<lookup> to use a Django-style lookup appropriate to that field's type (e.g. ?created__gte=2024-01-01). Only lookups valid for a given field's type are accepted; see that field's own description for the ones it supports.

| Lookup | Meaning | | --- | --- | | startswith / istartswith | Value starts with the given string (istartswith case-insensitive). | | endswith / iendswith | Value ends with the given string (iendswith case-insensitive). | | in | Value is one of a comma-separated list, e.g. ?id__in=1,2,3. | | gt / gte | Greater than / greater than or equal to. | | lt / lte | Less than / less than or equal to. | | range | Value falls between two comma-separated bounds, e.g. ?price__range=100,200. | | isnull | Field is/isn't null. Pass true or false. | | date | Matches the date part of a datetime field, e.g. ?created__date=2024-01-01. | | year / iso_year | Matches the (ISO) year of a date/datetime field. | | quarter | Matches the quarter (1-4) of a date/datetime field. | | month | Matches the month (1-12) of a date/datetime field. | | week / week_day | Matches the ISO week number, or day of the week (1=Sunday...7=Saturday). | | day | Matches the day of the month (1-31). | | time | Matches the time part of a datetime field. | | hour / minute / second | Matches that component of a time/datetime field. | | contained_by | Array/JSON field is fully contained within the given comma-separated values. | | overlap | Array field shares at least one element with the given comma-separated values. | | len | Matches the number of elements in an array field. | | has_key | JSON field contains the given top-level key. | | has_keys | JSON field contains all of the given comma-separated top-level keys. | | has_any_keys | JSON field contains at least one of the given comma-separated top-level keys. |

Combinator suffixes can be appended instead of (or in addition to) a lookup to control how a filter combines with the others on the request:

| Combinator | Meaning | | --- | --- | | or | Match this filter optionally — OR'd with the other filters instead of required. | | not | Exclude records matching this filter. | | ornot | Exclude records matching this filter, optionally (OR'd with other exclusions). | | and | Explicitly require this filter alongside the others (the default behaviour). |

HTTP Request

GET/listings/api/v1/deals/

Example Response

{
  "count": 0,
  "next": "http://www.example.com",
  "previous": "http://www.example.com",
  "results": [
    {
      "id": 0,
      "tags": [],
      "deal": "string",
      "site": 0,
      "suspensive_conditions": [],
      "other_conditions": [],
      "selling_agents": "string",
      "commission": null,
      "model_type": "string",
      "meta": {},
      "deal_ref": "string",
      "sale_price": "0.00",
      "agent": 0,
      "created": "2026-09-08T14:40:55.410Z",
      "modified": "2026-09-08T14:40:55.410Z",
      "deleted": "2026-09-08T14:40:55.410Z",
      "uuid": "770bba28-9f80-4d40-9c51-6e022364af91",
      "source_ref": "string",
      "deal_name": "string",
      "user": -2147483648,
      "branch": -2147483648,
      "offer": -2147483648,
      "business_type": "string",
      "status": "string",
      "transfer_attorney_instruction_type": "string",
      "transfer_attorney": -2147483648,
      "transfer_attorney_contacts": [],
      "transfer_instruction_status": "string",
      "bond_attorney_instruction_type": "string",
      "bond_attorney": -2147483648,
      "bond_attorney_contacts": [],
      "sellers": [],
      "seller_notes": "string",
      "seller_type": "string",
      "buyers": [],
      "buyer_notes": "string",
      "buyer_type": "string",
      "model_id": 0,
      "lightstone_id": -2147483648,
      "lightstone_data": null,
      "property_type": "string",
      "location": -2147483648,
      "farm_name": "string",
      "unit_number": "string",
      "street_number": "string",
      "street_name": "string",
      "complex_name": "string",
      "floor_number": "string",
      "building_name": "string",
      "erf_number": "string",
      "share_block_number": "string",
      "sectional_scheme_name": "string",
      "section_number": "string",
      "section_plan_number": "string",
      "mandate_type": "string",
      "sale_status": "string",
      "sale_date": "string",
      "expected_transfer_date": "string",
      "cash_amount": "0.00",
      "deposit_required": false,
      "deposit_amount": "0.00",
      "deposit_due_date": "string",
      "assisted_sale": false,
      "sale_bank": "string",
      "gas_compliance_required": "string",
      "beetle_compliance_required": "string",
      "electrical_compliance_required": "string",
      "plumbing_compliance_required": "string",
      "seller_documents": [],
      "buyer_documents": [],
      "sale_agreement_documents": [],
      "offer_made_date": "string",
      "offer_made_notes": "string",
      "sale_agreement_date": "string",
      "sale_agreement_notes": "string",
      "sale_agreement_undertaking_letter": false,
      "sale_agreement_undertaking_letter_date": "string",
      "sale_agreement_undertaking_letter_notes": "string",
      "instruction_sent_date": "string",
      "instruction_sent_notes": "string",
      "buyer_signed_date": "string",
      "buyer_signed_notes": "string",
      "seller_signed_date": "string",
      "seller_signed_notes": "string",
      "deposit_received_date": "string",
      "deposit_received_notes": "string",
      "conditions_met_date": "string",
      "conditions_met_notes": "string",
      "final_date": "string",
      "lodged_date": "string",
      "lodged_notes": "string",
      "closed_referral_fee": false,
      "closed_referral_fee_date": "string",
      "closed_referral_fee_notes": "string",
      "closed_royalty_fee": false,
      "closed_royalty_fee_date": "string",
      "closed_royalty_fee_notes": "string",
      "closed_invoices_sent": false,
      "closed_invoices_sent_date": "string",
      "closed_invoices_sent_notes": "string",
      "closed_date": "string",
      "cancelled_date": "string",
      "registered_date": "string",
      "registered_notes": "string",
      "cancelled_reason": "string"
    }
  ]
}

Name	Description
order_by	string Which field to use when ordering the results.
offset	integer Offset for Pagination
limit	integer Page Size
search	string Free-text search across the model's configured search fields
fields	string Comma-separated list of fields to match the search/trigram query against
id	string Filter results by exact id. Allowed lookups: `__or`, `__not`, `__ornot`, `__any`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
tags	string Filter results by exact tags. Allowed lookups: `__or`, `__not`, `__ornot`
deal	string Filter results by exact deal. Allowed lookups: `__or`, `__not`, `__ornot`
suspensive_conditions	string Filter results by exact suspensive_conditions. Also accepts any `suspensive_conditions__<lookup>` suffix (e.g. `suspensive_conditions__in`).
other_conditions	string Filter results by exact other_conditions. Also accepts any `other_conditions__<lookup>` suffix (e.g. `other_conditions__in`).
selling_agents	string Filter results by exact selling_agents. Also accepts any `selling_agents__<lookup>` suffix (e.g. `selling_agents__in`).
commission	string Filter results by exact commission. Also accepts any `commission__<lookup>` suffix (e.g. `commission__in`).
model_type	string Filter results by exact model_type. Also accepts any `model_type__<lookup>` suffix (e.g. `model_type__in`).
meta	string Filter results by exact meta. Allowed lookups: `__or`, `__not`, `__ornot`
deal_ref	string Filter results by exact deal_ref. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
sale_price	string Filter results by exact sale_price. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
agent	string Filter results by exact agent. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
created	string Filter results by exact created. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__date`, `__day`, `__endswith`, `__gt`, `__gte`, `__hour`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__minute`, `__month`, `__quarter`, `__range`, `__second`, `__startswith`, `__time`, `__week`, `__week_day`, `__year`
modified	string Filter results by exact modified. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__date`, `__day`, `__endswith`, `__gt`, `__gte`, `__hour`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__minute`, `__month`, `__quarter`, `__range`, `__second`, `__startswith`, `__time`, `__week`, `__week_day`, `__year`
deleted	string Filter results by exact deleted. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__date`, `__day`, `__endswith`, `__gt`, `__gte`, `__hour`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__minute`, `__month`, `__quarter`, `__range`, `__second`, `__startswith`, `__time`, `__week`, `__week_day`, `__year`
uuid	string Filter results by exact uuid. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
source_ref	string Filter results by exact source_ref. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
deal_name	string Filter results by exact deal_name. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
user	string Filter results by exact user. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
branch	string Filter results by exact branch. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
offer	string Filter results by exact offer. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
business_type	string Filter results by exact business_type. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
status	string Filter results by exact status. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
transfer_attorney_instruction_type	string Filter results by exact transfer_attorney_instruction_type. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
transfer_attorney	string Filter results by exact transfer_attorney. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
transfer_attorney_contacts	string Filter results by exact transfer_attorney_contacts. Allowed lookups: `__or`, `__not`, `__ornot`, `__all`, `__all_exact`, `__all_gt`, `__all_gte`, `__all_in`, `__all_isendof`, `__all_isstartof`, `__all_lt`, `__all_lte`, `__all_regex`, `__any`, `__any_contains`, `__any_exact`, `__any_gt`, `__any_gte`, `__any_in`, `__any_isendof`, `__any_isstartof`, `__any_lt`, `__any_lte`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__len`, `__lt`, `__lte`, `__overlap`, `__range`, `__startswith`
transfer_instruction_status	string Filter results by exact transfer_instruction_status. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
bond_attorney_instruction_type	string Filter results by exact bond_attorney_instruction_type. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
bond_attorney	string Filter results by exact bond_attorney. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
bond_attorney_contacts	string Filter results by exact bond_attorney_contacts. Allowed lookups: `__or`, `__not`, `__ornot`, `__all`, `__all_exact`, `__all_gt`, `__all_gte`, `__all_in`, `__all_isendof`, `__all_isstartof`, `__all_lt`, `__all_lte`, `__all_regex`, `__any`, `__any_contains`, `__any_exact`, `__any_gt`, `__any_gte`, `__any_in`, `__any_isendof`, `__any_isstartof`, `__any_lt`, `__any_lte`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__len`, `__lt`, `__lte`, `__overlap`, `__range`, `__startswith`
sellers	string Filter results by exact sellers. Allowed lookups: `__or`, `__not`, `__ornot`, `__all`, `__all_exact`, `__all_gt`, `__all_gte`, `__all_in`, `__all_isendof`, `__all_isstartof`, `__all_lt`, `__all_lte`, `__all_regex`, `__any`, `__any_contains`, `__any_exact`, `__any_gt`, `__any_gte`, `__any_in`, `__any_isendof`, `__any_isstartof`, `__any_lt`, `__any_lte`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__len`, `__lt`, `__lte`, `__overlap`, `__range`, `__startswith`
seller_notes	string Filter results by exact seller_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
seller_type	string Filter results by exact seller_type. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
buyers	string Filter results by exact buyers. Allowed lookups: `__or`, `__not`, `__ornot`, `__all`, `__all_exact`, `__all_gt`, `__all_gte`, `__all_in`, `__all_isendof`, `__all_isstartof`, `__all_lt`, `__all_lte`, `__all_regex`, `__any`, `__any_contains`, `__any_exact`, `__any_gt`, `__any_gte`, `__any_in`, `__any_isendof`, `__any_isstartof`, `__any_lt`, `__any_lte`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__len`, `__lt`, `__lte`, `__overlap`, `__range`, `__startswith`
buyer_notes	string Filter results by exact buyer_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
buyer_type	string Filter results by exact buyer_type. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
model_id	string Filter results by exact model_id. Allowed lookups: `__or`, `__not`, `__ornot`, `__any`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
lightstone_id	string Filter results by exact lightstone_id. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
lightstone_data	string Filter results by exact lightstone_data. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__has_any_keys`, `__has_key`, `__has_keys`, `__iendswith`, `__in`, `__isnone`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
property_type	string Filter results by exact property_type. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
location	string Filter results by exact location. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
farm_name	string Filter results by exact farm_name. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
unit_number	string Filter results by exact unit_number. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
street_number	string Filter results by exact street_number. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
street_name	string Filter results by exact street_name. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
complex_name	string Filter results by exact complex_name. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
floor_number	string Filter results by exact floor_number. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
building_name	string Filter results by exact building_name. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
erf_number	string Filter results by exact erf_number. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
share_block_number	string Filter results by exact share_block_number. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
sectional_scheme_name	string Filter results by exact sectional_scheme_name. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
section_number	string Filter results by exact section_number. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
section_plan_number	string Filter results by exact section_plan_number. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
mandate_type	string Filter results by exact mandate_type. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
sale_status	string Filter results by exact sale_status. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
sale_date	string Filter results by exact sale_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
expected_transfer_date	string Filter results by exact expected_transfer_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
cash_amount	string Filter results by exact cash_amount. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
deposit_required	string Filter results by exact deposit_required. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
deposit_amount	string Filter results by exact deposit_amount. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
deposit_due_date	string Filter results by exact deposit_due_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
assisted_sale	string Filter results by exact assisted_sale. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
sale_bank	string Filter results by exact sale_bank. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
gas_compliance_required	string Filter results by exact gas_compliance_required. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
beetle_compliance_required	string Filter results by exact beetle_compliance_required. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
electrical_compliance_required	string Filter results by exact electrical_compliance_required. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
plumbing_compliance_required	string Filter results by exact plumbing_compliance_required. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__length`, `__lt`, `__lte`, `__range`, `__startswith`
seller_documents	string Filter results by exact seller_documents. Allowed lookups: `__or`, `__not`, `__ornot`, `__all`, `__all_exact`, `__all_gt`, `__all_gte`, `__all_in`, `__all_isendof`, `__all_isstartof`, `__all_lt`, `__all_lte`, `__all_regex`, `__any`, `__any_contains`, `__any_exact`, `__any_gt`, `__any_gte`, `__any_in`, `__any_isendof`, `__any_isstartof`, `__any_lt`, `__any_lte`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__len`, `__lt`, `__lte`, `__overlap`, `__range`, `__startswith`
buyer_documents	string Filter results by exact buyer_documents. Allowed lookups: `__or`, `__not`, `__ornot`, `__all`, `__all_exact`, `__all_gt`, `__all_gte`, `__all_in`, `__all_isendof`, `__all_isstartof`, `__all_lt`, `__all_lte`, `__all_regex`, `__any`, `__any_contains`, `__any_exact`, `__any_gt`, `__any_gte`, `__any_in`, `__any_isendof`, `__any_isstartof`, `__any_lt`, `__any_lte`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__len`, `__lt`, `__lte`, `__overlap`, `__range`, `__startswith`
sale_agreement_documents	string Filter results by exact sale_agreement_documents. Allowed lookups: `__or`, `__not`, `__ornot`, `__all`, `__all_exact`, `__all_gt`, `__all_gte`, `__all_in`, `__all_isendof`, `__all_isstartof`, `__all_lt`, `__all_lte`, `__all_regex`, `__any`, `__any_contains`, `__any_exact`, `__any_gt`, `__any_gte`, `__any_in`, `__any_isendof`, `__any_isstartof`, `__any_lt`, `__any_lte`, `__contained_by`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__len`, `__lt`, `__lte`, `__overlap`, `__range`, `__startswith`
offer_made_date	string Filter results by exact offer_made_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
offer_made_notes	string Filter results by exact offer_made_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
sale_agreement_date	string Filter results by exact sale_agreement_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
sale_agreement_notes	string Filter results by exact sale_agreement_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
sale_agreement_undertaking_letter	string Filter results by exact sale_agreement_undertaking_letter. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
sale_agreement_undertaking_letter_date	string Filter results by exact sale_agreement_undertaking_letter_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
sale_agreement_undertaking_letter_notes	string Filter results by exact sale_agreement_undertaking_letter_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
instruction_sent_date	string Filter results by exact instruction_sent_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
instruction_sent_notes	string Filter results by exact instruction_sent_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
buyer_signed_date	string Filter results by exact buyer_signed_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
buyer_signed_notes	string Filter results by exact buyer_signed_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
seller_signed_date	string Filter results by exact seller_signed_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
seller_signed_notes	string Filter results by exact seller_signed_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
deposit_received_date	string Filter results by exact deposit_received_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
deposit_received_notes	string Filter results by exact deposit_received_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
conditions_met_date	string Filter results by exact conditions_met_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
conditions_met_notes	string Filter results by exact conditions_met_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
final_date	string Filter results by exact final_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
lodged_date	string Filter results by exact lodged_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
lodged_notes	string Filter results by exact lodged_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
closed_referral_fee	string Filter results by exact closed_referral_fee. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
closed_referral_fee_date	string Filter results by exact closed_referral_fee_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
closed_referral_fee_notes	string Filter results by exact closed_referral_fee_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
closed_royalty_fee	string Filter results by exact closed_royalty_fee. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
closed_royalty_fee_date	string Filter results by exact closed_royalty_fee_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
closed_royalty_fee_notes	string Filter results by exact closed_royalty_fee_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
closed_invoices_sent	string Filter results by exact closed_invoices_sent. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
closed_invoices_sent_date	string Filter results by exact closed_invoices_sent_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
closed_invoices_sent_notes	string Filter results by exact closed_invoices_sent_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
closed_date	string Filter results by exact closed_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
cancelled_date	string Filter results by exact cancelled_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
registered_date	string Filter results by exact registered_date. Allowed lookups: `__or`, `__not`, `__ornot`, `__contained_by`, `__day`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__iso_week_day`, `__iso_year`, `__istartswith`, `__lt`, `__lte`, `__month`, `__quarter`, `__range`, `__startswith`, `__week`, `__week_day`, `__year`
registered_notes	string Filter results by exact registered_notes. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`
cancelled_reason	string Filter results by exact cancelled_reason. Allowed lookups: `__or`, `__not`, `__ornot`, `__endswith`, `__gt`, `__gte`, `__iendswith`, `__in`, `__isnull`, `__isnullorempty`, `__istartswith`, `__lt`, `__lte`, `__range`, `__startswith`

Responses

200

403 You do not have permission to perform this action

500 Internal server error

503 This website is not active