UK profit warnings,
structured and queryable

// Request
GET /v1/warnings
  ?from=2025-01-01
  &index=FTSE250
  &severity=material
  &limit=20

Authorization: Bearer fk_live_xxx

// Response
{
  "data": [
    {
      "id": "warn_01j8x2k...",
      "company": "Fevertree Drinks",
      "ticker": "FEVR",
      "index": "FTSE250",
      "announced_at": "2025-03-12T08:14:00Z",
      "severity": "material",
      "reason_primary": "demand_weakness",
      "reason_detail": "US on-trade volumes
        deteriorated sharply in H2",
      "confidence": 0.97,
      "rns_url": "https://..."
    }
  ],
  "meta": {
    "total": 284,
    "page": 1,
    "limit": 20
  }
}

// Get all warnings for a company
GET /v1/company/FEVR/warnings

// Response
{
  "company": {
    "name": "Fevertree Drinks plc",
    "ticker": "FEVR",
    "isin": "GB00B3FLWH99",
    "index": "FTSE250",
    "sector": "Beverages"
  },
  "warning_count": 4,
  "last_warning": "2025-03-12",
  "warnings": [
    { "id": "warn_01j8x2k", ... },
    { "id": "warn_01h4m9p", ... }
  ]
}

// Register webhook (Professional+)
POST /v1/webhooks
{
  "url": "https://your-app.com/hook",
  "filters": {
    "index": ["FTSE100", "FTSE250"],
    "severity": ["material"],
    "min_confidence": 0.90
  }
}

// Payload fired on each match:
{
  "event": "warning.classified",
  "data": { ... },
  "classified_at": "2025-03-12T08:17:22Z",
  "latency_seconds": 187
}

-- Core warnings table
CREATE TABLE warnings (
  id          TEXT PRIMARY KEY,
  rns_id      TEXT UNIQUE,
  ticker      TEXT,
  company     TEXT,
  isin        TEXT,
  index_name  TEXT,
  announced_at DATETIME,
  raw_text    TEXT,

  -- Classification (populated by Claude)
  is_warning  BOOLEAN,
  confidence  REAL,
  severity    TEXT,
  reason_primary TEXT,
  reason_detail  TEXT,
  classified_at  DATETIME,

  -- Flags
  needs_review BOOLEAN DEFAULT false
);