Every dashboard and metric, as data.

curl -X POST "https://app.os.construction/oauth/token" \
  -H "Content-Type: application/json" \
  -d '{"grant_type":"password","username":"you@example.com","password":"…",
       "scope":"analytics:read rfis:read budget:read"}'

curl "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/catalog" \
  -H "Authorization: Bearer $OS_ACCESS_TOKEN"

{
  "metrics": [
    { "key": "pm.rfis_open", "label": "Open rfis", "description": "RFIs not yet closed.",
      "unit": "count", "direction": "lower_better", "source": "rfis", "domain": "pm", … }
  ],
  "dimensions": [
    { "key": "status", "label": "Status", "type": "category", … },
    { "key": "created", "label": "Created", "type": "time", "grains": ["day", "week", "month", "quarter", "year"], … }
  ],
  "sources": [
    { "key": "rfis", "label": "RFIs", "tool": "rfis", "scopes": ["rfis:read"], "defaultTime": "created", … }
  ],
  "compat": { "pm.rfis_open": ["project", "status", "created", …] }
}

curl -X POST "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/query" \
  -H "Authorization: Bearer $OS_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"query": {
        "metrics": ["pm.rfis_open", "pm.rfis_total"],
        "dimensions": [{ "key": "status" }],
        "time": { "preset": "last_90d" }
      }}'

const base = "https://app.os.construction/rest/v1.0/companies/1/analytics";
const headers = {
  Authorization: `Bearer ${process.env.OS_ACCESS_TOKEN}`,
  "Content-Type": "application/json",
};
const res = await fetch(`${base}/query`, {
  method: "POST",
  headers,
  body: JSON.stringify({ query: {
    metrics: ["pm.rfis_open"],
    dimensions: [{ key: "project" }],
    time: { preset: "last_90d" },
  } }),
});
const { columns, rows, unavailable } = await res.json();
if (unavailable.length) console.warn("not readable with this token:", unavailable);

import os, requests

base = "https://app.os.construction/rest/v1.0/companies/1/analytics"
h = {"Authorization": f"Bearer {os.environ['OS_ACCESS_TOKEN']}"}

r = requests.post(f"{base}/query", headers=h, json={"query": {
    "metrics": ["pm.rfis_open"],
    "dimensions": [{"key": "status"}],
}})
r.raise_for_status()
res = r.json()
print([c["label"] for c in res["columns"]], res["rows"])

{
  "columns": [
    { "key": "status", "label": "Status", "role": "dim", "type": "string" },
    { "key": "pm.rfis_open", "label": "Open rfis", "role": "metric", "type": "number", "unit": "count" },
    { "key": "pm.rfis_total", "label": "RFIs", "role": "metric", "type": "number", "unit": "count" }
  ],
  "rows": [["open", 4, 4], ["closed", 0, 3], ["draft", 0, 1]],
  "labels": { "status": { "open": "Open", "closed": "Closed", "draft": "Draft" } },
  "totals": [4, 8],
  "truncated": false,
  "partial": [],
  "unavailable": [],
  "meta": { "asOf": "2026-10-26T04:45:14Z", "timezone": "UTC", "projects": 1, "cached": false, "ms": 280,
            "plans": [{ "source": "rfis", "via": "base" }] }
}

# Dashboards you can see (page / per_page, Total + Link headers)
curl "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/dashboards?per_page=100" -H "Authorization: Bearer $OS_ACCESS_TOKEN"

# One definition: spec.filters, spec.tiles (each with a stable id), layout
curl "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/dashboards/42" -H "Authorization: Bearer $OS_ACCESS_TOKEN"

# Every tile computed as you, this year, two statuses
curl "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/dashboards/42/data?time_preset=ytd&filters[status]=open,draft" \
  -H "Authorization: Bearer $OS_ACCESS_TOKEN"

# One tile as CSV
curl "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/dashboards/42/data?tile=by_status&format=csv" \
  -H "Authorization: Bearer $OS_ACCESS_TOKEN" -o rfis-by-status.csv

{
  "target": { "type": "dashboard", "id": 42, "name": "PM weekly overview" },
  "project_id": null,
  "url": "/rest/v1.0/companies/1/analytics/dashboards/42/data",
  "filters_applied": ["Created: Year to date", "Status: open, draft"],
  "as_of": "2026-10-26T04:46:34Z",
  "tiles": [
    {
      "id": "by_status",
      "title": "RFIs by status",
      "kind": "query",
      "url": "/rest/v1.0/companies/1/analytics/dashboards/42/data?tile=by_status",
      "export_url": "/rest/v1.0/companies/1/analytics/dashboards/42/data?tile=by_status&format=csv",
      "query": { "metrics": ["pm.rfis_total"], "dimensions": [{ "key": "status" }], "time": { "dim": "created", "preset": "ytd" }, … },
      "result": { "columns": [ … ], "rows": [["open", 4], ["draft", 1]], … },
      "records": null,
      "error": null
    }
  ]
}

# Save the current filters as a personal view
curl -X POST "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/dashboards/42/views" \
  -H "Authorization: Bearer $OS_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"view": {"name": "Open, this year",
               "state": {"values": {"status": ["open"], "created": {"preset": "ytd"}}, "chips": []},
               "shared": false}}'

# Views you can see: your own and shared ones
curl "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/dashboards/42/views" -H "Authorization: Bearer $OS_ACCESS_TOKEN"

# Every tile with that view applied
curl "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/dashboards/42/data?view_id=7" -H "Authorization: Bearer $OS_ACCESS_TOKEN"

curl -X POST "https://app.os.construction/rest/v1.0/companies/{company_id}/analytics/schedules" \
  -H "Authorization: Bearer $OS_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"schedule": {
        "name": "Late RFIs, Mondays",
        "target_type": "dashboard", "target_id": 42, "view_id": 7,
        "format": "pdf", "cadence": "weekly", "weekday": 1, "hour": 7,
        "timezone": "America/Chicago", "recipient_ids": [12, 31],
        "condition": { "metric_key": "pm.rfis_late", "op": "gt", "threshold": 5, "window": "last_30d" },
        "webhook": true
      }}'

{
  "event": "analytics.schedule.delivered",
  "data": {
    "schedule": { "id": 9, "name": "Late RFIs, Mondays", "target_type": "dashboard", "target_id": 42,
                  "pack_key": null, "format": "pdf", "cadence": "weekly" },
    "project_id": null,
    "period_key": "…",
    "delivered_at": "2026-10-26T12:00:04Z",
    "title": "…",
    "rendered_as": { "user_id": 12 },
    "recipients": 2,
    "file": {
      "filename": "…", "content_type": "application/pdf", "bytes": 48213,
      "download_url": "https://app.os.construction/rest/v1.0/companies/1/analytics/schedules/9/file?token=…",
      "expires_at": "2026-11-02T12:00:04Z"
    },
    "url": "https://app.os.construction/…"
  },
  …
}

let
  Source = Web.Contents(
    "https://app.os.construction/rest/v1.0/companies/1/analytics/dashboards/42/data",
    [Query = [tile = "by_status", format = "csv"],
     Headers = [Authorization = "Bearer " & Token]]),
  Table = Table.PromoteHeaders(Csv.Document(Source, [Encoding = 65001]))
in
  Table

// In a cell: =OS_TILE(42, "by_status")
// Store the token in Project settings → Script properties as OS_TOKEN.
function OS_TILE(dashboardId, tileId) {
  const token = PropertiesService.getScriptProperties().getProperty("OS_TOKEN");
  const url = "https://app.os.construction/rest/v1.0/companies/1/analytics/dashboards/" + dashboardId +
    "/data?format=csv&tile=" + encodeURIComponent(tileId);
  const res = UrlFetchApp.fetch(url, { headers: { Authorization: "Bearer " + token } });
  return Utilities.parseCsv(res.getContentText().replace(/^\uFEFF/, ""));
}

csv = requests.get(f"{base}/dashboards/42/data", headers=h,
                   params={"tile": "by_status", "format": "csv"})
open("by_status.csv", "wb").write(csv.content)