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
| Action | What it does |
|---|---|
| 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. |
| Find charts | Find charts by words in their names, on one dashboard or anywhere, with their links. |
| Find dashboards | Find dashboards by words in their titles, most recently changed first, with their links. |
| Find datasets | Find datasets (the tables and SQL charts are built on) by words in their names, in one database or all. |
| Get chart data | Run a chart's query and get its rows, to send as a report or copy to a sheet. |
| Get dashboard | Get a dashboard's details, its filters and the charts on it, to get each chart's data. |
| List databases | List the databases connected to Superset that Lodol's user can use. |
| Run SQL query | Run SQL in SQL Lab on a database connected to Superset and get the rows. |
| 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. |
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
- Chart
charttextRequired - The chart. Pick one, or give its number, link or name.
- Skip the cache
freshtrue/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
- Words
querytext - Words in the charts' names. Leave blank to list them all.
- Dashboard
dashboardtext - Only charts on this dashboard. Leave blank to look everywhere.
- How many
limitnumber - 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
- Words
querytext - Words in the dashboards' titles. Leave blank to list them all.
- How many
limitnumber - 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
- Words
querytext - Words in the datasets' names. Leave blank to list them all.
- Database
databasetext - Only datasets in this database. Leave blank for all of them.
- How many
limitnumber - 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
- Chart
charttextRequired - The chart. Pick one, or give its number, link or name.
- Row limit
limitnumber - The most rows to return, up to 10,000. Defaults to 100.From 1 to 10000.
- Skip the cache
freshtrue/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
- Dashboard
dashboardtextRequired - 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
- Database
databasetextRequired - The database. Pick one, or type its name.
- SQL
sqltextRequired - The SQL to run, written for that database, such as SELECT * FROM orders.
- Schema
schematext - The schema table names are looked up in, such as public. Leave blank for the database's default.
- Row limit
limitnumber - 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
- Dataset
datasettextRequired - 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"
}