Search Deals
Search Deal records using field filters and free-text search.
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
POST/listings/api/v1/deals/search/
Example Response
{"count": 0,"next": "http://www.example.com","previous": "http://www.example.com","results": [{"id": 0,"site": 0,"amount_paid": "0.00","date_paid": "string","recipient": 0}]}
| Name | Description |
|---|---|
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
400 Bad request body
403 You do not have permission to perform this action
500 Internal server error
503 This website is not active