redrover-manager

# Red Rover Manager Skill

## Overview

Red Rover is an absence management system used by PSD to track staff absences and substitute coverage. This skill provides access to absence data for reporting and analysis.

## Configuration

- **Base URL**: `https://connect.redroverk12.com/`
- **Org ID**: 1305 (Peninsula School District)
- **Authentication**: HTTP Basic Auth + API Key header
- **Credentials**: Stored in 1Password as "RedRover"
- **Rate Limit**: 100 requests/minute

## Authentication

All requests require both:
1. `Authorization: Basic [base64(username:password)]` header
2. `apiKey: [key]` header (obtained from organization endpoint)

The organization endpoint returns a dynamic API key that should be used for subsequent requests.

## Scripts

All scripts are in `skills/redrover-manager/scripts/`. Run with `bun`:

### get_organization.js
Fetch organization info and validate credentials.

```bash
bun get_organization.js
```

Returns: Organization ID, name, and API key.

### get_absences.js
Fetch raw absence/vacancy data for a date range.

```bash
bun get_absences.js <start_date> <end_date> [filled|unfilled|all]
```

Examples:
```bash
bun get_absences.js 2026-01-20 2026-01-27
bun get_absences.js 2026-01-27 2026-01-27 unfilled
```

**Note:** Max date range is 31 days.

### get_daily_summary.js
Get daily absence summary (all staff) with counts by school, reason, and fill status.

```bash
bun get_daily_summary.js [date]
```

Date options:
- `today` (default)
- `yesterday`
- Day names: `monday`, `tuesday`, etc.
- `last wednesday`, `last friday`
- Specific date: `2026-01-27`

### get_certificated_summary.js
Get daily absence summary for **certificated staff only** (Teachers, ESA, CTE).

```bash
bun get_certificated_summary.js [date]
```

Same date options as above. This is the most commonly requested report - focuses on classroom coverage.

### get_weekly_summary.js
Get weekly trends and patterns.

```bash
bun get_weekly_summary.js [weeks_ago]
```

Options:
- `0` = t