Apache Superset

App · 9 actions

Get Superset chart data and run SQL in a workflow: send a report, copy rows to a sheet, find dashboards and charts. Start a workflow when a dashboard changes, a chart has a new row, or a number crosses a threshold.

Actions

ActionWhat it does
Download chart as CSVSave a chart's data as a CSV file in Lodol, as Superset's Export to .CSV makes it, to attach to an email or upload.
Find chartsFind charts by words in their names, on one dashboard or anywhere, with their links.
Find dashboardsFind dashboards by words in their titles, most recently changed first, with their links.
Find datasetsFind datasets (the tables and SQL charts are built on) by words in their names, in one database or all.
Get chart dataRun a chart's query and get its rows, to send as a report or copy to a sheet.
Get dashboardGet a dashboard's details, its filters and the charts on it, to get each chart's data.
List databasesList the databases connected to Superset that Lodol's user can use.
Run SQL queryRun SQL in SQL Lab on a database connected to Superset and get the rows.
Sync dataset columnsUpdate a dataset's columns from its table, as Superset's Sync columns from source does, after a column is added or changed.

Download chart as CSV

Save a chart's data as a CSV file in Lodol, as Superset's Export to .CSV makes it, to attach to an email or upload.

Inputs

ChartcharttextRequired
The chart. Pick one, or give its number, link or name.
Skip the cachefreshtrue/false
Read the database now rather than use the results Superset has kept from the chart's last run.Default: false.

Outputs

chart_idnumber
The chart's number
chart_nametext
Its name
content_typetext
text/csv, or application/zip for a chart of several queries
csvtext
The CSV's text, up to its first 200,000 characters
document_reftext
The CSV file, for a later step that takes one, such as an email's attachments or a drive upload
filenametext
The file's name, such as Orders-by-region.csv
linktext
A link to the chart in Superset
row_countnumber
How many rows the CSV has
size_bytesnumber
The file's size in bytes
Example output
{
  "chart_id": 1,
  "chart_name": "Orders by region",
  "content_type": "text/csv",
  "csv": "region,COUNT(*),Revenue\nSouth,30,3280.00\nEast,30,3250.00\nWest,30,3030.00\nNorth,30,3000.00\n",
  "document_ref": "doc_7f3a9c2e1b",
  "filename": "Orders-by-region.csv",
  "link": "https://superset.example.com/explore/?slice_id=1",
  "row_count": 4,
  "size_bytes": 87
}

Find charts

Find charts by words in their names, on one dashboard or anywhere, with their links.

Inputs

Wordsquerytext
Words in the charts' names. Leave blank to list them all.
Dashboarddashboardtext
Only charts on this dashboard. Leave blank to look everywhere.
How manylimitnumber
The most to list, up to 100. Defaults to 25.From 1 to 100.

Outputs

chartslist
The charts found
countnumber
How many are listed
totalnumber
How many match in all
Example output
{
  "charts": [
    {
      "changed_on": "2026-11-07T01:13:22.894921Z",
      "dashboards": [
        "Sales overview"
      ],
      "dataset": "public.orders",
      "dataset_id": 1,
      "description": "",
      "id": 1,
      "link": "https://superset.example.com/explore/?slice_id=1",
      "name": "Orders by region",
      "type": "table"
    }
  ],
  "count": 1,
  "total": 1
}

Find dashboards

Find dashboards by words in their titles, most recently changed first, with their links.

Inputs

Wordsquerytext
Words in the dashboards' titles. Leave blank to list them all.
How manylimitnumber
The most to list, up to 100. Defaults to 25.From 1 to 100.

Outputs

countnumber
How many are listed
dashboardslist
The dashboards found
totalnumber
How many match in all
Example output
{
  "count": 1,
  "dashboards": [
    {
      "changed_by": "Ada Admin",
      "changed_on": "2026-11-07T01:13:22.791518Z",
      "id": 1,
      "link": "https://superset.example.com/superset/dashboard/sales-overview/",
      "owners": [
        "Ada Admin"
      ],
      "slug": "sales-overview",
      "status": "published",
      "title": "Sales overview"
    }
  ],
  "total": 1
}

Find datasets

Find datasets (the tables and SQL charts are built on) by words in their names, in one database or all.

Inputs

Wordsquerytext
Words in the datasets' names. Leave blank to list them all.
Databasedatabasetext
Only datasets in this database. Leave blank for all of them.
How manylimitnumber
The most to list, up to 100. Defaults to 25.From 1 to 100.

Outputs

countnumber
How many are listed
datasetslist
The datasets found
totalnumber
How many match in all
Example output
{
  "count": 1,
  "datasets": [
    {
      "changed_on": "2026-11-07T01:12:59.137447Z",
      "database": "Shop",
      "database_id": 1,
      "description": "",
      "id": 1,
      "kind": "physical",
      "link": "https://superset.example.com/explore/?datasource_type=table&datasource_id=1",
      "name": "orders",
      "schema": "public"
    }
  ],
  "total": 1
}

Get chart data

Run a chart's query and get its rows, to send as a report or copy to a sheet.

Inputs

ChartcharttextRequired
The chart. Pick one, or give its number, link or name.
Row limitlimitnumber
The most rows to return, up to 10,000. Defaults to 100.From 1 to 10000.
Skip the cachefreshtrue/false
Read the database now rather than use the results Superset has kept from the chart's last run.Default: false.

Outputs

chart_idnumber
The chart's number
chart_nametext
Its name
chart_typetext
Its kind, such as table, pie or big_number_total
columnslist
The columns, in order
has_moretrue/false
True when the chart had more rows than returned
linktext
A link to the chart in Superset
row_countnumber
How many rows are returned
rowslist
The rows, each an object keyed by column name; times are ISO 8601
total_rowsnumber
How many rows the chart's query gave
Example output
{
  "chart_id": 1,
  "chart_name": "Orders by region",
  "chart_type": "table",
  "columns": [
    {
      "name": "region",
      "type": "text"
    },
    {
      "name": "COUNT(*)",
      "type": "number"
    },
    {
      "name": "Revenue",
      "type": "number"
    }
  ],
  "has_more": false,
  "link": "https://superset.example.com/explore/?slice_id=1",
  "row_count": 2,
  "rows": [
    {
      "COUNT(*)": 30,
      "Revenue": 3280.0,
      "region": "South"
    },
    {
      "COUNT(*)": 30,
      "Revenue": 3250.0,
      "region": "East"
    }
  ],
  "total_rows": 2
}

Get dashboard

Get a dashboard's details, its filters and the charts on it, to get each chart's data.

Inputs

DashboarddashboardtextRequired
The dashboard. Pick one, or give its number, link or title.

Outputs

changed_bytext
Who changed it last
changed_ontext
When it last changed (ISO 8601)
chart_countnumber
How many charts are on it
chartslist
The charts on it, in its layout's order
filterslist
Its filters, by name
idnumber
Its number
linktext
A link to it in Superset
ownerslist
Who owns it
slugtext
Its short name in links; blank when it has none
statustext
published or draft
titletext
Its title
Example output
{
  "changed_by": "Ada Admin",
  "changed_on": "2026-11-07T01:13:22.791518Z",
  "chart_count": 2,
  "charts": [
    {
      "chart_id": 2,
      "link": "https://superset.example.com/explore/?slice_id=2",
      "name": "Revenue (all orders)",
      "type": "big_number_total"
    },
    {
      "chart_id": 1,
      "link": "https://superset.example.com/explore/?slice_id=1",
      "name": "Orders by region",
      "type": "table"
    }
  ],
  "filters": [
    "Region"
  ],
  "id": 1,
  "link": "https://superset.example.com/superset/dashboard/sales-overview/",
  "owners": [
    "Ada Admin"
  ],
  "slug": "sales-overview",
  "status": "published",
  "title": "Sales overview"
}

List databases

List the databases connected to Superset that Lodol's user can use.

Inputs

None.

Outputs

countnumber
How many
databaseslist
The databases
Example output
{
  "count": 1,
  "databases": [
    {
      "allows_changes": false,
      "backend": "postgresql",
      "id": 1,
      "in_sql_lab": true,
      "name": "Shop",
      "runs_async": false
    }
  ]
}

Run SQL query

Run SQL in SQL Lab on a database connected to Superset and get the rows. Superset runs only what the database allows from SQL Lab: reads, unless it's set to allow changes.

Inputs

DatabasedatabasetextRequired
The database. Pick one, or type its name.
SQLsqltextRequired
The SQL to run, written for that database, such as SELECT * FROM orders.
Schemaschematext
The schema table names are looked up in, such as public. Leave blank for the database's default.
Row limitlimitnumber
The most rows to return, up to 10,000. Defaults to 100.From 1 to 10000.

Outputs

columnslist
The columns, in order
database_idnumber
The database's number
executed_sqltext
The SQL Superset ran, with the row limit it added
has_moretrue/false
True when the query had more rows than returned
row_countnumber
How many rows are returned
rowslist
The rows, each an object keyed by column name; times are ISO 8601
Example output
{
  "columns": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "total",
      "type": "number"
    },
    {
      "name": "created_at",
      "type": "time"
    }
  ],
  "database_id": 1,
  "executed_sql": "SELECT id, total, created_at FROM orders ORDER BY id DESC LIMIT 3",
  "has_more": true,
  "row_count": 2,
  "rows": [
    {
      "created_at": "2026-10-30T00:09:36.921923+00:00",
      "id": 120,
      "total": 80.0
    },
    {
      "created_at": "2026-10-31T01:09:36.921923+00:00",
      "id": 119,
      "total": 43.0
    }
  ]
}

Sync dataset columns

Update a dataset's columns from its table, as Superset's Sync columns from source does, after a column is added or changed. Lodol's user must be one of the dataset's owners.

Inputs

DatasetdatasettextRequired
The dataset. Pick one, or give its number or table name.

Outputs

changed_ontext
When it last changed (ISO 8601)
column_countnumber
How many columns it has
columnslist
Its columns after the sync
databasetext
The database it reads
database_idnumber
That database's number
descriptiontext
Its description
idnumber
Its number
kindtext
physical (a table) or virtual (SQL)
linktext
A link to explore it in Superset
nametext
Its table's name, or its own for a SQL dataset
schematext
The schema its table is in
Example output
{
  "changed_on": "2026-11-07T01:12:59.137447Z",
  "column_count": 3,
  "columns": [
    {
      "is_time": false,
      "name": "id",
      "type": "INTEGER"
    },
    {
      "is_time": false,
      "name": "total",
      "type": "NUMERIC(10, 2)"
    },
    {
      "is_time": true,
      "name": "created_at",
      "type": "TIMESTAMP WITH TIME ZONE"
    }
  ],
  "database": "Shop",
  "database_id": 1,
  "description": "",
  "id": 1,
  "kind": "physical",
  "link": "https://superset.example.com/explore/?datasource_type=table&datasource_id=1",
  "name": "orders",
  "schema": "public"
}

On this page