Get the monthly leave summary

Leave totals per person and leave type for one month, plus the booking rows.

GET https://cotlet.dev/api/v1/timetastic/monthly-summary

read

Reads the Monthly summary from Settings > Reporting & Backup: totals per active user by leave type, and the month's requests and bookings. The rows include declined and cancelled requests, each with its status. The account must be able to open that page, or the call fails with APP_PERMISSION_DENIED.

Parameters

Parameters: get_monthly_summary
NameTypeDescription
month string required string Month as YYYY-MM.
include_rows boolean boolean Also return the booking rows of the Leave sheet. Defaults to true.

Request

cURL
curl "https://cotlet.dev/api/v1/timetastic/monthly-summary?month=2026-09" \
  -H "Authorization: Bearer $COTLET_API_KEY"
Python
result = client.call("timetastic", "get_monthly_summary", {"month":"2026-09"})
Node.js
const result = await cotlet.call('timetastic', 'get_monthly_summary', {"month":"2026-09"});
CLI
cotlet call timetastic get_monthly_summary --data '{"month":"2026-09"}'

Example response

JSON

{
  "month": "2026-09",
  "totals": [
    {
      "employee": "Ana Torres",
      "leave": {
        "Holiday": 2,
        "Sick leave": 1
      }
    },
    {
      "employee": "Ben Okafor",
      "leave": {
        "Sick leave": 2
      }
    },
    {
      "employee": "Priya Nair",
      "leave": {}
    }
  ],
  "rows": [
    {
      "employee": "Ana Torres",
      "leave_type": "Holiday",
      "from": "2026-09-07",
      "to": "2026-09-08",
      "status": "Approved"
    },
    {
      "employee": "Ana Torres",
      "leave_type": "Sick leave",
      "from": "2026-09-15",
      "to": "2026-09-15",
      "status": "Approved"
    },
    {
      "employee": "Ben Okafor",
      "leave_type": "Sick leave",
      "from": "2026-09-02",
      "to": "2026-09-03",
      "status": "Approved"
    },
    {
      "employee": "Ben Okafor",
      "leave_type": "Holiday",
      "from": "2026-09-28",
      "to": "2026-09-30",
      "status": "Declined"
    }
  ]
}

Sign in once. Your agent does the rest.

Sign up and add the apps you need. Free 7-day trial with 2,000 credits, no card needed.