Get report
get_reportRun one Tradify report for a date range and return rows for job profitability, job sheets, staff productivity, or timesheets to review costs, invoices, schedules, and logged hours.
Instructions
Job profitability, job sheet, staff productivity or timesheet report for a period, as rows.
Runs one report of Tradify's Reports page for the days from to to (both included, at most a year) and returns the rows of its CSV download, amounts as numbers. job_profitability gives three rows per job (Time, Materials, Total) with estimated cost from quotes, actual cost, invoiced, to invoice, gross profit and margin. job_sheet lists the jobs with site, staff, schedule, contacts, entered by and on. staff_productivity gives billable, non-billable and total hours (h:mm) per staff member. timesheets lists each time entry with job, customer, staff member, billing rate, notes, date and hours. date_basis picks jobs by entry or by schedule date. Stops at 1000 rows with truncated true.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"report": "<report>",
"from": "<from>",
"to": "<to>"
},
"name": "get_report"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | Last day of the period, up to a year after from. | |
| from | Yes | First day of the period. | |
| staff | No | Only this staff member, by full name. | |
| report | Yes | job_profitability (estimated and actual cost, invoiced, to invoice, gross profit and margin per job, split into time and materials), job_sheet (jobs with site, staff, schedule, contacts, labour and cost), staff_productivity (billable and non-billable hours per staff member) or timesheets (time logged per job and staff member). | |
| date_basis | No | job_profitability and job_sheet: jobs entered in the period (default) or scheduled in it. | entered |
| customer_id | No | job_profitability, job_sheet, timesheets: only this customer (list_customers). | |
| include_inactive_jobs | No | job_sheet: also complete and cancelled jobs. |