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
}
}
}Insights
Get an insight
Retrieves an insight by ID, including the Markdown body, chart details, a rendered chart image URL, and raw chart data. Requires admin access to the organization.
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
API key authentication using Bearer token format: Bearer <basedash_api_key>
Query Parameters
Maximum raw chart rows to return (1-1000, default 1000)
Required range:
1 <= x <= 1000Raw chart data page number
Required range:
x >= 1Response
Insight retrieved successfully
Show child attributes
Show child attributes
Was this page helpful?
⌘I