Search and filter deals with pagination and sorting using the deals_list_query RPC.
Filters: keywords (name + company search), deal_status_ids_included/excluded, owner_ids_included/excluded, show_open_deals_only, show_archived, closed_date_filter, open_date_filter, and custom attribute filters (select_attribute_filters, numeric_attribute_filters, date_attribute_filters, team_member_attribute_filters).
Sorting: name, amount, win_probability, company, status, closed_date, last_contacted_at, created_at, or custom_<attribute_id> for custom attribute sorting.
Include: Pass ["custom_fields"] to include deal custom attribute values.
Authenticate with a Bearer token: API key, OAuth token, or session token.
Records to skip for pagination. Defaults to 0.
x >= 0Max records to return (1–100). Defaults to 100.
1 <= x <= 100Column to sort by. Accepted values:
name — deal name (alphabetical)amount — deal monetary amountwin_probability — win probability percentagecompany — client company name (alphabetical)status — deal status (by stage order)closed_date — expected or actual close datelast_contacted_at — most recent engagement with client contactscreated_at — creation timestamp (default)custom_<attribute_id> — any custom attribute UUID prefixed with custom_ (e.g. custom_e5f6a7b8-...). Sorts by the attribute's decimal, date, string, or tag value.Sort direction. Defaults to desc (newest first).
asc, desc Full-text search across deal name, client company name, and domain. Multiple keywords use OR logic.
Pre-filter to a specific set of deal UUIDs.
Filter to deals belonging to this list.
Include only deals with these status UUIDs.
Exclude deals with these status UUIDs.
Include only deals owned by these team members. Get IDs from GET /v1/team-members.
Exclude deals owned by these team members.
When true, only return deals with an "active" status type.
When true, return archived (soft-deleted) deals instead of active ones.
Filter by closed_date range. Supports start_date, end_date, and include_empty.
Filter by creation date (open date) range. Supports start_date, end_date, and include_empty.
Filter by select/multi-select custom fields. Get attribute_id and tag IDs from GET /v1/custom-fields/deals.
Filter by numeric custom fields (min/max range). Get attribute_id from GET /v1/custom-fields/deals.
Filter by date custom fields (date range). Get attribute_id from GET /v1/custom-fields/deals.
Filter by team-member custom fields. Get attribute_id from GET /v1/custom-fields/deals.
Extra sections to embed. Values: custom_fields. Omit for base fields only.
custom_fields