> ## Documentation Index > Fetch the complete documentation index at: https://basedash.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Get an insight > Retrieves an insight by ID, including the Markdown body, chart details, a chart image URL, and raw chart data. Requires admin access to the organization. ## OpenAPI ````yaml https://charts.basedash.com/api/public/openapi get /api/public/organizations/{orgId}/insights/{id} openapi: 3.1.0 info: title: Basedash Public API version: 0.0.0 description: >- API for programmatic access to Basedash features. Use API keys for authentication. contact: name: Basedash Support url: https://basedash.com email: support@basedash.com servers: - url: https://charts.basedash.com description: Production security: [] tags: - name: Organizations description: Manage organizations - name: Groups description: Manage organization groups and memberships - name: Data Sources description: Manage database connections and data sources - name: MCP servers description: Manage MCP server data sources - name: Insights description: Manage generated insights - name: Automations description: Manage automations and automation runs - name: Skills description: Manage organization skills - name: Definitions description: Manage reusable SQL definitions - name: Dashboards description: Manage dashboards and their tabs - name: Charts description: Manage charts and their SQL queries - name: Chats description: >- Chat with the Basedash AI agent about your data. Start a chat by sending a message, then continue the conversation with follow-up messages. The assistant responds asynchronously: pass the `wait` query parameter to receive the finished response in the same request, or poll the assistant message (or stream its events) after an HTTP 202. Chats created through the API are not shown in the Basedash app. paths: /api/public/organizations/{orgId}/insights/{id}: get: tags: - Insights summary: Get an insight description: >- Retrieves an insight by ID, including the Markdown body, chart details, a chart image URL, and raw chart data. Requires admin access to the organization. parameters: - schema: type: string description: Organization ID required: true description: Organization ID name: orgId in: path - schema: type: string description: Insight ID required: true description: Insight ID name: id in: path - schema: type: integer minimum: 1 maximum: 1000 default: 1000 description: Maximum raw chart rows to return (1-1000, default 1000) required: false description: Maximum raw chart rows to return (1-1000, default 1000) name: rawDataLimit in: query - schema: type: integer minimum: 1 default: 1 description: Raw chart data page number required: false description: Raw chart data page number name: rawDataPage in: query responses: '200': description: Insight retrieved successfully content: application/json: schema: $ref: '#/components/schemas/PublicInsightDetailResponse' examples: revenueGrowth: summary: Revenue growth insight value: 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://charts.basedash.com/api/public/organizations/org_01jvmjz0f4m8t9s6r2p3q1n7xb/charts/chart_01jvmk1ay8m4n6p2q9r7t3c5hd/image?chartVersionId=chart_version_01jvmk1c2e7f9h4j6m8p0q3r5t 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. This 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' 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 '400': description: Bad request - Invalid query parameters content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '401': description: Unauthorized - Missing or invalid API key content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '404': description: Not found - Insight not found or no admin access content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' '429': description: Rate limit exceeded - Too many requests content: application/json: schema: $ref: '#/components/schemas/RateLimitErrorResponse' '500': description: Internal server error content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' security: - bearerAuth: [] components: schemas: PublicInsightDetailResponse: type: object properties: data: $ref: '#/components/schemas/PublicInsightDetail' required: - data ErrorResponse: type: object properties: error: $ref: '#/components/schemas/ApiError' required: - error RateLimitErrorResponse: type: object properties: error: $ref: '#/components/schemas/RateLimitError' required: - error PublicInsightDetail: allOf: - $ref: '#/components/schemas/PublicInsightListItem' - type: object properties: chart: $ref: '#/components/schemas/PublicInsightChart' bodyMarkdown: type: string description: Insight body as Markdown sourceMeta: description: Insight generation metadata rawData: $ref: '#/components/schemas/PublicInsightRawData' required: - bodyMarkdown - rawData ApiError: type: object properties: title: type: string description: Error type identifier detail: type: string description: Human-readable error description required: - title - detail RateLimitError: allOf: - $ref: '#/components/schemas/ApiError' - type: object properties: title: type: string enum: - RateLimitExceeded retryAfterMs: type: number description: Milliseconds until the rate limit window resets required: - retryAfterMs PublicInsightListItem: type: object properties: id: type: string description: Insight ID organizationId: type: string description: Organization ID title: type: string description: Insight title chartId: type: string description: Chart ID chart: type: object properties: id: type: string description: Chart ID versionId: type: - string - 'null' description: Latest chart version ID name: type: - string - 'null' description: Latest chart version name type: type: - string - 'null' description: Chart type required: - id - versionId - name - type description: Basic chart information createdAt: type: string format: date-time description: Creation timestamp updatedAt: type: string format: date-time description: Last update timestamp required: - id - organizationId - title - chartId - chart - createdAt - updatedAt PublicInsightChart: type: object properties: id: type: string description: Chart ID versionId: type: - string - 'null' description: Latest chart version ID name: type: - string - 'null' description: Latest chart version name type: type: - string - 'null' description: Chart type sqlQuery: type: - string - 'null' description: SQL query used by the chart databaseConnectionId: type: - string - 'null' description: Data source ID used by the chart imageUrl: type: - string - 'null' format: uri description: >- URL that renders the latest chart version as a PNG image (the "Get a chart image" endpoint). Request it with the same API key authentication. required: - id - versionId - name - type - sqlQuery - databaseConnectionId - imageUrl description: Chart information PublicInsightRawData: type: - object - 'null' properties: rows: type: array items: type: object additionalProperties: {} description: A raw chart data row description: Raw chart rows count: type: number description: Total row count for the chart query page: type: number description: Raw data page number limit: type: number description: Maximum raw rows returned required: - rows - count - page - limit description: Raw data returned by the insight chart query securitySchemes: bearerAuth: type: http scheme: bearer description: >- API key authentication using Bearer token format: `Bearer ` ````