Search Jobs
search_jobsRead-onlyIdempotent
Search jobs using flexible filters like status, customer, date range, address, and more. Paginated results sorted by start date descending.
Instructions
Search for jobs with flexible filters. Supports filtering by status, customer name, date range, address, phone, email, category, and more. Returns paginated results sorted by most recent first by default.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| status | No | Filter by job status. Comma-separated for multiple (e.g., 'Open,Scheduled'). Common statuses: Open, Scheduled, Dispatched, In Progress, Completed, Cancelled. | |
| sub_status | No | Filter by sub-status (exact match). May not be supported by all accounts. | |
| customer_name | No | Filter by customer name (partial match). | |
| start_date_gte | No | Jobs starting on or after this date (YYYY-MM-DD). | |
| start_date_lte | No | Jobs starting on or before this date (YYYY-MM-DD). | |
| end_date_gte | No | Jobs ending on or after this date (YYYY-MM-DD). | |
| end_date_lte | No | Jobs ending on or before this date (YYYY-MM-DD). | |
| address | No | Filter by job address (partial match). | |
| city | No | Filter by city (exact match). | |
| zip_code | No | Filter by zip/postal code (exact match). | |
| phone | No | Filter by phone number (partial match). | |
| No | Filter by email address (exact match). | ||
| category | No | Filter by job category. Comma-separated for multiple. | |
| source | No | Filter by lead source. Comma-separated for multiple. | |
| number | No | Filter by job number (partial match). | |
| sort | No | Sort results. Prefix with '-' for descending. Examples: '-start_date', 'customer_name', '-created_at'. Default: '-start_date'. | |
| page | No | Page number (default: 1). | |
| per_page | No | Results per page (default: 20, max: 50). |