Get report
get_reportJob 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. |