--- name: "hr_report" area: "hr" title: "Run an HR report" price: "free" method: "POST" url: "https://api.conecto.chat/v1/tools/hr_report" mcp_server: "https://api.conecto.chat/mcp/hr" auth: "Authorization: Bearer " docs_url: "https://conecto.chat/tools/hr/hr_report" --- # Run an HR report (`hr_report`) Headcount, joiners and leavers, time off taken, or everyone's leave balances. headcount: who works here on as_of (default today), by department, location and employment type, people on leave counted. joiners_leavers: who started, and whose last day fell, from-to. time_off: approved working days off from-to, per leave type and per person. balances: everyone's balance of each tracked leave type for a leave year (default the current one), paged. Periods default to this leave year so far. To show a person, put it in a view (view_show). Price: Free up to 1,000,000 reads a month for the whole account, then $0.50 per 10,000 reads. A call that fails costs nothing. ## Use it when Someone asks how big the team is, who joined or left, or how much leave is left. - For a page that shows the report to a person, use [view_show](https://conecto.chat/tools/views/view_show.md). ## Say this to your agent > How many vacation days does everyone have left this year? ## Inputs | Name | Type | Required | Description | Allowed values | Default | |---|---|---|---|---|---| | `report` | string | yes | | `"headcount"`, `"joiners_leavers"`, `"time_off"`, `"balances"` | | | `as_of` | string | no | YYYY-MM-DD (matches ^\\d{4}-\\d{2}-\\d{2}$) | | | | `from` | string | no | YYYY-MM-DD (matches ^\\d{4}-\\d{2}-\\d{2}$) | | | | `to` | string | no | YYYY-MM-DD (matches ^\\d{4}-\\d{2}-\\d{2}$) | | | | `year` | integer | no | A leave year, named by the year it starts in. Default: the current one. 2,000 to 2,100. | | | | `limit` | integer | no | 1 to 500. | | `100` | | `offset` | integer | no | At least 0. | | `0` | ## Example Written for Hansen & Voss, a restaurant-equipment wholesaler in Hamburg with 60 staff. MCP: call `hr_report` on the MCP server `https://api.conecto.chat/mcp/hr` with these arguments: ```json { "report": "balances" } ``` REST: ```bash curl https://api.conecto.chat/v1/tools/hr_report \ -H "Authorization: Bearer $CONECTO_KEY" \ -H "Content-Type: application/json" \ -d '{"report": "balances"}' ``` ## Response ```json { "call_id": "5f0c8a2e-3b7d-4c1e-9a64-2d8e1f7b0c93", "tool": "hr_report", "status": "succeeded", "replayed": false, "cost_usd": "$0.00", "balance_usd": "$19.75", "result": { "report": "balances", "year": 2026, "from": "2026-01-01", "to": "2026-12-31", "leave_types": [ "Vacation" ], "people": [ { "person_id": 4103, "name": "Jonas Becker", "department": "Warehouse", "balances": [ { "leave_type": "Vacation", "entitlement": "28", "carried_over": "0", "adjustments": "0", "approved": "3", "balance": "25", "pending": "0", "available_after_pending": "25" } ] }, { "person_id": 4101, "name": "Lena Brandt", "department": "Operations", "balances": [ { "leave_type": "Vacation", "entitlement": "28", "carried_over": "0", "adjustments": "0", "approved": "0", "balance": "28", "pending": "0", "available_after_pending": "28" } ] } ], "total": 4 } } ``` `result`: The report's name and dates, and its rows: for balances the leave types and each person's balances, with the total; for headcount people by department, location and type; for joiners_leavers who started and left; for time_off the days off per type and person. ## Errors | Code | Status | When | Fix | |---|---|---|---| | `invalid_input` | 400 | A date is not a date like 2026-10-01, or from is after to. | Fix the date. | The refusals every tool can give (401 key, 402 balance, 429 limits) are on the errors page: https://conecto.chat/docs/errors.md ## Related - [hr_save_people](https://conecto.chat/tools/hr/hr_save_people.md): Adds people or changes them, up to 100 at a time, all or none: names, emails, job, department, location, manager, dates and allowances. $1.00 per person added. - [hr_list_people](https://conecto.chat/tools/hr/hr_list_people.md): People by last name, everyone who hasn't left by default, filtered by status, department, location, manager, type or words. Free up to 1,000,000 reads a month. - [hr_get_person](https://conecto.chat/tools/hr/hr_get_person.md): Everything about one person: details, leave balances for a year, pending and upcoming leave, documents, open tasks and direct reports. Free up to 1,000,000 reads a month. - [hr_delete_person](https://conecto.chat/tools/hr/hr_delete_person.md): Erases a person for good with their leave, tasks and document records; their files stay in the store. Free. - [hr_get_settings](https://conecto.chat/tools/hr/hr_get_settings.md): The working days, hours, leave year, time zone, leave types, public holidays and checklists. Free up to 1,000,000 reads a month. - [hr_save_settings](https://conecto.chat/tools/hr/hr_save_settings.md): Sets the work calendar: working days, hours per day, leave year, time zone, and one location's public holidays for a year. $0.001 a call. - [hr_save_leave_type](https://conecto.chat/tools/hr/hr_save_leave_type.md): Adds or changes a kind of time off: annual days, monthly or yearly accrual, carry-over, paid and tracked. $0.001 a call. - [hr_adjust_leave](https://conecto.chat/tools/hr/hr_adjust_leave.md): Adds days to, or takes days off, one person's balance of a tracked leave type, with the reason. $0.01 a call. - [hr_request_leave](https://conecto.chat/tools/hr/hr_request_leave.md): Asks for time off for someone, counting working days less holidays; it waits for a decision unless approved at once. $0.01 a call. - [hr_decide_leave](https://conecto.chat/tools/hr/hr_decide_leave.md): Approves or declines a pending leave request, or cancels one that is pending or approved. $0.01 a call. - [hr_list_leave](https://conecto.chat/tools/hr/hr_list_leave.md): Leave requests, latest start first, by person, status, type or dates. Free up to 1,000,000 reads a month. - [hr_who_is_out](https://conecto.chat/tools/hr/hr_who_is_out.md): Who is off in a period (today by default), with each leave and its days, plus public holidays and people on long leave. Free up to 1,000,000 reads a month. - [hr_save_checklist](https://conecto.chat/tools/hr/hr_save_checklist.md): Adds or changes an onboarding or offboarding checklist: items with an owner and a due day relative to the start or last day. $0.001 a call. - [hr_start_checklist](https://conecto.chat/tools/hr/hr_start_checklist.md): Turns a checklist into tasks for one person, each due relative to their start date or last day. $0.01 a call. - [hr_tasks](https://conecto.chat/tools/hr/hr_tasks.md): Checklist tasks, soonest due first: open, overdue, done or all, for one person, one owner or a date. Free up to 1,000,000 reads a month. - [hr_complete_task](https://conecto.chat/tools/hr/hr_complete_task.md): Marks a checklist task done, or opens it again. $0.01 a call. - [hr_save_document](https://conecto.chat/tools/hr/hr_save_document.md): Keeps a file from the store on a person's record (a contract, an ID, a certificate), or changes or removes it. $0.01 a call. - [hr_dashboard_link](https://conecto.chat/tools/hr/hr_dashboard_link.md): A one-time link to HR at a glance: who is out, leave to decide, open tasks, and who starts or leaves soon. Free up to 1,000,000 reads a month. - [hr_save_policy](https://conecto.chat/tools/hr/hr_save_policy.md): Keeps a policy people must read and confirm, like an AI use policy; a changed text is a new version. $0.001 a call. - [hr_send_policy](https://conecto.chat/tools/hr/hr_send_policy.md): Emails each person in a policy's scope a one-time link to read and confirm its current version. $0.02 per email sent. - [hr_record_training](https://conecto.chat/tools/hr/hr_record_training.md): Records a training someone completed, like AI literacy, with its date, hours, certificate and expiry. $0.01 a call. - [hr_policy_status](https://conecto.chat/tools/hr/hr_policy_status.md): Who confirmed each policy's current version, and who holds a valid training of each kind. Free up to 1,000,000 reads a month.