Preset

Preset is a managed cloud BI and analytics platform powered by Apache Superset. Its REST API combines a Preset Manager surface (authentication, teams, workspaces, users, guest tokens) at https://api.app.preset.io with a per-workspace proxy to the underlying Superset REST API for charts, dashboards, datasets, databases, and SQL Lab.

7 APIs 0 Features

BIAnalyticsSupersetDashboardsData Visualization

APIs

Preset Auth API

Exchanges an API token name and secret for a short-lived JWT access token via POST /v1/auth/. The returned bearer token authenticates all subsequent Preset Manager and Superset ...

Preset Teams and Workspaces API

Preset Manager endpoints for listing teams, listing and creating workspaces within a team, managing team membership, and minting guest tokens for embedded dashboards via POST /v...

Preset Superset Dashboards API

Per-workspace proxy to the Apache Superset Dashboard REST API (/api/v1/dashboard/) for listing, creating, reading, updating, deleting, and exporting dashboards as code. Reached ...

Preset Superset Charts API

Per-workspace proxy to the Apache Superset Chart REST API (/api/v1/chart/) for CRUD on charts, chart data queries, and import/export of charts as code within a Preset workspace.

Preset Superset Datasets API

Per-workspace proxy to the Apache Superset Dataset REST API (/api/v1/dataset/) for managing physical and virtual datasets, columns, metrics, and the semantic layer.

Preset Superset Databases API

Per-workspace proxy to the Apache Superset Database REST API (/api/v1/database/) for managing data source connections, testing connectivity, and listing schemas and tables.

Preset Superset SQL Lab API

Per-workspace proxy to the Apache Superset SQL Lab REST API (/api/v1/sqllab/execute/) for executing ad hoc SQL against connected databases and retrieving query results.

Collections

Preset API

OPEN

Pricing Plans

Preset Plans Pricing

3 plans

PLANS

Rate Limits

Preset Rate Limits

5 limits

RATE LIMITS

FinOps

Preset Finops

FINOPS

Resources

👥

GitHubOrganization

Sources

opencollection: 1.0.0
info:
  name: Preset API
  version: '1.0'
request:
  auth:
    type: bearer
    token: '{{bearerToken}}'
items:
- info:
    name: Authentication
    type: folder
  items:
  - info:
      name: Exchange API token for JWT
      type: http
    http:
      method: POST
      url: https://api.app.preset.io/v1/auth/
      body:
        type: json
        data: "{\n  \"name\": \"{{apiTokenName}}\",\n  \"secret\": \"{{apiTokenSecret}}\"\n}"
    docs: Exchanges an API token name and secret for a short-lived JWT access token.
- info:
    name: Teams and Workspaces
    type: folder
  items:
  - info:
      name: List teams
      type: http
    http:
      method: GET
      url: https://api.app.preset.io/v1/teams/
    docs: Lists the teams the authenticated principal belongs to.
  - info:
      name: List workspaces in a team
      type: http
    http:
      method: GET
      url: https://api.app.preset.io/v1/teams/{{teamName}}/workspaces/
    docs: Lists workspaces in a team, including each workspace name (slug) and region.
  - info:
      name: Create a workspace
      type: http
    http:
      method: POST
      url: https://api.app.preset.io/v1/teams/{{teamName}}/workspaces/
      body:
        type: json
        data: "{\n  \"title\": \"My Workspace\",\n  \"region\": \"us2a\"\n}"
    docs: Creates a new Superset-backed workspace in a team.
  - info:
      name: Create a guest token
      type: http
    http:
      method: POST
      url: https://api.app.preset.io/v1/teams/{{teamName}}/workspaces/{{workspaceName}}/guest-token/
      body:
        type: json
        data: "{\n  \"user\": {},\n  \"resources\": [],\n  \"rls\": []\n}"
    docs: Mints a short-lived guest token for an embedded dashboard.
- info:
    name: Superset Proxy
    type: folder
  items:
  - info:
      name: List dashboards
      type: http
    http:
      method: GET
      url: https://{{workspaceSlug}}.{{region}}.app.preset.io/api/v1/dashboard/
    docs: Per-workspace proxy to the Superset Dashboard API.
  - info:
      name: List charts
      type: http
    http:
      method: GET
      url: https://{{workspaceSlug}}.{{region}}.app.preset.io/api/v1/chart/
    docs: Per-workspace proxy to the Superset Chart API.
  - info:
      name: Query chart data
      type: http
    http:
      method: POST
      url: https://{{workspaceSlug}}.{{region}}.app.preset.io/api/v1/chart/data
      body:
        type: json
        data: '{}'
    docs: Executes a chart data query and returns the result payload.
  - info:
      name: List datasets
      type: http
    http:
      method: GET
      url: https://{{workspaceSlug}}.{{region}}.app.preset.io/api/v1/dataset/
    docs: Per-workspace proxy to the Superset Dataset API.
  - info:
      name: List databases
      type: http
    http:
      method: GET
      url: https://{{workspaceSlug}}.{{region}}.app.preset.io/api/v1/database/
    docs: Per-workspace proxy to the Superset Database API.
  - info:
      name: Execute SQL
      type: http
    http:
      method: POST
      url: https://{{workspaceSlug}}.{{region}}.app.preset.io/api/v1/sqllab/execute/
      body:
        type: json
        data: "{\n  \"database_id\": 1,\n  \"sql\": \"SELECT 1\",\n  \"schema\": \"public\",\n  \"runAsync\": false\n}"
    docs: Per-workspace proxy to the Superset SQL Lab execute endpoint.