deals_list_all_auto
Retrieve all Pipedrive deals in a single response with automatic cursor pagination; use filters or max_items to limit results for reports or exports.
Instructions
Automatically fetch ALL deals with pagination handling. Backed by Pipedrive API v2 (GET /api/v2/deals), paginated via cursor.
This tool automatically handles cursor pagination and fetches all deals matching the filters. Unlike deals/list, this returns ALL results in a single response.
WARNING: This can return large datasets. Use filters to limit results.
Workflow tips:
Same filters as deals/list (status, stage_id, user_id, person_id, org_id, etc.)
Specify max_items to limit total results if needed
No need to manage cursor - pagination is automatic (loops until additional_data.next_cursor is null)
Best for exports, reports, or comprehensive analysis
Use add_time_from / add_time_until to filter by creation date (client-side)
sort_by only accepts a small set of v2 fields (confirmed working: id, add_time, update_time)
Common use cases:
Get all open deals: { "status": "open" }
Export all deals for a pipeline: { "pipeline_id": 1 }
Get old unqualified deals: { "pipeline_id": 4, "add_time_until": "2023-12-31" }
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Field to sort by. v2 only accepts a small enum — confirmed: id, add_time, update_time. | |
| org_id | No | Filter by organization ID | |
| status | No | Filter by deal status. 'all_not_deleted' is v1-only and is translated to 'no status filter'. | |
| sort_by | No | Sort direction | |
| user_id | No | Filter by user (owner) ID — sent as owner_id to v2. If owned_by_you=1 is also set, owned_by_you takes precedence and this value is ignored. | |
| stage_id | No | Filter by stage ID | |
| filter_id | No | ID of the filter to use | |
| max_items | No | Maximum number of items to return | |
| 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. Takes precedence over user_id when both are provided. | |
| 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. |