Onboarding health dashboard

curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://api.onramp.us/v1/projects"

import requests

resp = requests.get(
    "https://api.onramp.us/v1/projects",
    headers={"Authorization": "Bearer YOUR_API_KEY"},
)
print(resp.json())

const resp = await fetch("https://api.onramp.us/v1/projects", {
  headers: { Authorization: "Bearer YOUR_API_KEY" },
});
console.log(await resp.json());

# curl is great for one call at a time, but building the full spreadsheet
# means looping over every project and counting tasks — that's much easier
# in Python or Node. The building blocks, if you want to script it yourself:

# 1. List projects (name, status, completion %)
curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://api.onramp.us/v1/projects?page=1&limit=100"

# 2. Count overdue tasks for one project (read data.pagination.total in the reply)
curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://api.onramp.us/v1/tasks?project_uuid=PROJECT_UUID&is_overdue=true&limit=1"

# 3. Count work due in the next 7 days
curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://api.onramp.us/v1/tasks?project_uuid=PROJECT_UUID&due_date_before=2026-08-30&limit=1"

import csv, datetime as dt, requests

BASE = "https://api.onramp.us/v1"
HEADERS = {"Authorization": "Bearer YOUR_API_KEY"}
SOON = (dt.date.today() + dt.timedelta(days=7)).isoformat()

def pages(path, list_key, params=None):
    """Walk every page; lists live at data.<resource>, paging at data.pagination."""
    page = 1
    while page:
        body = requests.get(f"{BASE}{path}", headers=HEADERS,
                            params=dict(params or {}, page=page, limit=100)).json()
        yield from body["data"][list_key]
        page = body["data"]["pagination"]["nextPage"]  # None on the last page

def total(path, params):  # count matches without downloading them
    body = requests.get(f"{BASE}{path}", headers=HEADERS,
                        params=dict(params, page=1, limit=1)).json()
    return body["data"]["pagination"]["total"]

with open("onboarding_health.csv", "w", newline="") as f:
    out = csv.writer(f)
    out.writerow(["project", "status", "completed_%", "overdue", "due_soon"])
    for p in pages("/projects", "projects"):
        uuid = p["uuid"]
        out.writerow([
            p["name"], p["status"]["name"], p["completed_percentage"],
            total("/tasks", {"project_uuid": uuid, "is_overdue": "true"}),
            total("/tasks", {"project_uuid": uuid, "due_date_before": SOON}),
        ])
print("Wrote onboarding_health.csv")

import { writeFileSync } from "node:fs";

const BASE = "https://api.onramp.us/v1";
const HEADERS = { Authorization: "Bearer YOUR_API_KEY" };
const soon = new Date(Date.now() + 7 * 864e5).toISOString().slice(0, 10);

const get = async (path, params) => {
  const url = new URL(BASE + path);
  Object.entries(params).forEach(([k, v]) => url.searchParams.set(k, v));
  return (await fetch(url, { headers: HEADERS })).json();
};

// Lists live at data.<resource>; paging info at data.pagination.
async function* pages(path, listKey) {
  let page = 1;
  while (page) {
    const { data } = await get(path, { page, limit: 100 });
    yield* data[listKey];
    page = data.pagination.nextPage; // null on the last page
  }
}

const total = async (path, params) =>
  (await get(path, { ...params, page: 1, limit: 1 })).data.pagination.total;

const rows = [["project", "status", "completed_%", "overdue", "due_soon"]];
for await (const p of pages("/projects", "projects")) {
  rows.push([
    p.name, p.status.name, p.completed_percentage,
    await total("/tasks", { project_uuid: p.uuid, is_overdue: "true" }),
    await total("/tasks", { project_uuid: p.uuid, due_date_before: soon }),
  ]);
}
writeFileSync("onboarding_health.csv", rows.map((r) => r.join(",")).join("\n"));
console.log("Wrote onboarding_health.csv");