deals_list
Retrieve a paginated list of deals with filters for status, stage, owner, and more. Use to narrow results by pipeline, person, or date range.
Instructions
List deals with pagination and filtering options.
Returns a paginated list of deals. Use filters to narrow results by status, stage, owner, person, organization, or pipeline.
Workflow tips:
Use status filter to get only 'open', 'won', 'lost', or 'all_not_deleted' deals
Set owned_by_you=1 to see only your deals
Combine with filter_id to use pre-configured Pipedrive filters
Use start/limit for pagination (default limit: 100, max: 500)
For all deals without pagination, use deals/list_all_auto instead
Use add_time_from / add_time_until to filter by creation date (client-side). NOTE: this only filters the current page; for complete date-range results use deals/list_all_auto
Common use cases:
List all open deals: { "status": "open" }
List my won deals: { "status": "won", "owned_by_you": 1 }
List deals in a specific stage: { "stage_id": 123 }
List deals added before 2023: { "add_time_until": "2022-12-31" }
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Field to sort by (e.g., title, value, stage_id) | |
| limit | No | Number of items to return | |
| start | No | Pagination start | |
| org_id | No | Filter by organization ID | |
| status | No | Filter by deal status | |
| sort_by | No | Sort direction | |
| user_id | No | Filter by user (owner) ID | |
| stage_id | No | Filter by stage ID | |
| filter_id | No | ID of the filter to use | |
| person_id | No | Filter by person ID | |
| pipeline_id | No | Filter by pipeline ID | |
| owned_by_you | No | Filter deals owned by the authorized user (1 = yes, 0 = no) | |
| add_time_from | No | Filter deals created on or after this date (YYYY-MM-DD). Applied client-side. | |
| add_time_until | No | Filter deals created on or before this date (YYYY-MM-DD). Applied client-side. |