Skip to main content
GET
/
api
/
public
/
organizations
/
{orgId}
/
insights
/
{id}
Get an insight
curl --request GET \
  --url https://charts.basedash.com/api/public/organizations/{orgId}/insights/{id} \
  --header 'Authorization: Bearer <token>'
{
  "data": {
    "id": "insight_01jvmk3x9r6p8q4n2b7z5c1h0a",
    "organizationId": "org_01jvmjz0f4m8t9s6r2p3q1n7xb",
    "title": "Enterprise expansion drove revenue growth",
    "chartId": "chart_01jvmk1ay8m4n6p2q9r7t3c5hd",
    "chart": {
      "id": "chart_01jvmk1ay8m4n6p2q9r7t3c5hd",
      "versionId": "chart_version_01jvmk1c2e7f9h4j6m8p0q3r5t",
      "name": "Monthly recurring revenue by segment",
      "type": "LINE",
      "sqlQuery": "select date_trunc('month', started_at) as month, segment, sum(mrr) as mrr from subscriptions where status = 'active' group by 1, 2 order by 1",
      "databaseConnectionId": "db_conn_01jvmhy3v6b9n2p4q8r5t7x1zc",
      "imageUrl": "https://static.basedash.com/chart-screenshots/insights/insight_01jvmk3x9r6p8q4n2b7z5c1h0a/chart_version_01jvmk1c2e7f9h4j6m8p0q3r5t-1400x1000.png"
    },
    "createdAt": "2026-05-26T13:42:18.000Z",
    "updatedAt": "2026-05-26T13:42:18.000Z",
    "bodyMarkdown": "Enterprise MRR increased 18% month over month, outpacing self-serve growth by 11 percentage points. The increase was concentrated in the final week of April, when three annual expansions were booked.\n\nThis suggests the expansion motion is becoming a larger contributor to new recurring revenue.",
    "sourceMeta": {
      "model": "gpt-5.4",
      "generatedAt": "2026-05-26T13:42:18.000Z",
      "chartScreenshot": {
        "chartVersionId": "chart_version_01jvmk1c2e7f9h4j6m8p0q3r5t",
        "key": "chart-screenshots/insights/insight_01jvmk3x9r6p8q4n2b7z5c1h0a/chart_version_01jvmk1c2e7f9h4j6m8p0q3r5t-1400x1000.png",
        "url": "https://static.basedash.com/chart-screenshots/insights/insight_01jvmk3x9r6p8q4n2b7z5c1h0a/chart_version_01jvmk1c2e7f9h4j6m8p0q3r5t-1400x1000.png",
        "width": 700,
        "height": 500,
        "scale": 2,
        "generatedAt": "2026-05-26T13:42:20.000Z"
      }
    },
    "rawData": {
      "rows": [
        {
          "month": "2026-02-01T00:00:00.000Z",
          "segment": "Self serve",
          "mrr": 84200
        },
        {
          "month": "2026-02-01T00:00:00.000Z",
          "segment": "Enterprise",
          "mrr": 126500
        },
        {
          "month": "2026-03-01T00:00:00.000Z",
          "segment": "Self serve",
          "mrr": 89300
        },
        {
          "month": "2026-03-01T00:00:00.000Z",
          "segment": "Enterprise",
          "mrr": 141800
        },
        {
          "month": "2026-04-01T00:00:00.000Z",
          "segment": "Self serve",
          "mrr": 95600
        },
        {
          "month": "2026-04-01T00:00:00.000Z",
          "segment": "Enterprise",
          "mrr": 167300
        }
      ],
      "count": 6,
      "page": 1,
      "limit": 1000
    }
  }
}

Authorizations

Authorization
string
header
required

API key authentication using Bearer token format: Bearer <basedash_api_key>

Path Parameters

orgId
string
required

Organization ID

id
string
required

Insight ID

Query Parameters

rawDataLimit
integer
default:1000

Maximum raw chart rows to return (1-1000, default 1000)

Required range: 1 <= x <= 1000
rawDataPage
integer
default:1

Raw chart data page number

Required range: x >= 1

Response

Insight retrieved successfully

data
object
required