Automate Apache Superset
HumDay reads Apache Superset’s own published API description and derives 120 operations from it. Describe the outcome you want in plain words — you get a program that is written, proven on real data, and run for you.
What Apache Superset is
Superset
API host: superset.apache.local
What HumDay can do in Apache Superset
50 documented operations change something in Apache Superset. The 44 most useful are listed here.
- POSTCreate a new Chart.
/chart/ - POSTCreate a report schedule
/report/ - POSTCreate a new Dataset
/dataset/ - POSTCreate a new Database.
/database/ - POSTCreate a new Dashboard.
/dashboard/ - POSTCreate a saved query
/saved_query/ - POSTTakes a list of datasources, finds the associated cache records and invalidates them and removes the database records
/cachekey/invalidate - POSTCreate a CSS template
/css_template/ - POSTCreate an Annotation layer
/annotation_layer/ - POSTTakes a query context constructed in the client and returns payload data response for the given query.
/chart/data - POSTUse the refresh token to get a new JWT access token
/security/refresh - DELETEDelete a report schedule
/report/{pk} - PUTUpdate a report schedule
/report/{pk} - DELETEDelete saved query
/saved_query/{pk} - PUTUpdate a saved query
/saved_query/{pk} - DELETEDeletes multiple Charts in a bulk operation.
/chart/ - DELETEDeletes multiple report schedules in a bulk operation.
/report/ - DELETEDeletes multiple Datasets in a bulk operation.
/dataset/ - DELETEDeletes multiple Dashboards in a bulk operation.
/dashboard/ - DELETEDeletes multiple saved queries in a bulk operation.
/saved_query/ - DELETEDeletes multiple css templates in a bulk operation.
/css_template/ - DELETEDeletes multiple annotation layers in a bulk operation.
/annotation_layer/ - POSTCreate an Annotation layer
/annotation_layer/{pk}/annotation/ - POSTAuthenticate and get a JWT access and refresh token
/security/login - POSTTests a database connection
/database/test_connection - DELETEDeletes a Chart.
/chart/{pk} - PUTChanges a Chart.
/chart/{pk} - DELETEDeletes a Dataset
/dataset/{pk} - PUTChanges a Dataset
/dataset/{pk} - DELETEDeletes a Database.
/database/{pk} - PUTChanges a Database.
/database/{pk} - POSTValidates parameters used to connect to a database
/database/validate_parameters - DELETEDeletes a Dashboard.
/dashboard/{pk} - PUTChanges a Dashboard.
/dashboard/{pk} - DELETEDelete CSS template
/css_template/{pk} - PUTUpdate a CSS template
/css_template/{pk} - DELETEDelete Annotation layer
/annotation_layer/{pk} - PUTUpdate an Annotation layer
/annotation_layer/{pk} - PUTRefreshes and updates columns of a dataset
/dataset/{pk}/refresh - DELETEDeletes multiple annotation in a bulk operation.
/annotation_layer/{pk}/annotation/ - DELETEDelete a Dataset column
/dataset/{pk}/column/{column_id} - DELETEDelete a Dataset metric
/dataset/{pk}/metric/{metric_id} - DELETEDelete Annotation layer
/annotation_layer/{pk}/annotation/{annotation_id} - PUTUpdate an Annotation layer
/annotation_layer/{pk}/annotation/{annotation_id}
What HumDay can read from Apache Superset
These are the operations a schedule or a trigger can watch.
- GETReads off of the Redis events stream, using the user's JWT token and optional query params for last event received.
/async_event/ - GETGet a list of charts, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/chart/ - GETGet a list of queries, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/query/ - GETGet a list of report schedules, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/report/ - GETGet a list of dashboards, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/dashboard/ - GETGet a list of report schedule logs, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/report/{pk}/log/ - GETGet a list of saved queries, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/saved_query/ - GETGet a list of CSS templates, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/css_template/ - GETGet a list of Annotation layers, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/annotation_layer/ - GETGet a list of models
/log/ - GETGet a list of models
/dataset/ - GETGet a list of models
/database/ - GETGet a list of Annotation layers, use Rison or JSON query parameters for filtering, sorting, pagination and for selecting specific columns and metadata.
/annotation_layer/{pk}/annotation/ - GETExports multiple charts and downloads them as YAML files
/chart/export/ - GETExports multiple datasets and downloads them as YAML files
/dataset/export/ - GETDownload database(s) and associated dataset(s) as a zip file
/database/export/ - GETExports multiple Dashboards and downloads them as YAML files.
/dashboard/export/ - GETExports multiple saved queries and downloads them as YAML files
/saved_query/export/ - GETCheck favorited dashboards for current user
/chart/favorite_status/ - GETGet an item model
/log/{pk} - GETGet query detail information.
/query/{pk} - GETCheck favorited dashboards for current user
/dashboard/favorite_status/ - GETGet a report schedule
/report/{pk} - GETGet an item model
/dataset/{pk} - GETGet an item model
/database/{pk} - GETGet a saved query
/saved_query/{pk} - GETGet the menu data structure.
/menu/ - GETTakes a chart ID and uses the query context stored when the chart was saved to return payload data response.
/chart/{pk}/data/ - GETTakes a query context cache key and returns payload data response for the given query.
/chart/data/{cache_key} - GETGet a list of all possible owners for a chart.
/chart/related/{column_name} - GETReturns a list of a dashboard's datasets.
/dashboard/{id_or_slug}/datasets - GETGet a list of all possible owners for a dashboard.
/dashboard/related/{column_name} - GETSeveral metadata information about chart API endpoints.
/chart/_info - GETGet metadata information about this API resource
/report/_info - GETGet metadata information about this API resource
/dataset/_info - GETGet metadata information about this API resource
/database/_info - GETSeveral metadata information about dashboard API endpoints.
/dashboard/_info - GETGet metadata information about this API resource
/saved_query/_info - GETGet metadata information about this API resource
/css_template/_info - GETGet names of databases currently available
/database/available/ - GETFetch the CSRF token
/security/csrf_token/ - GETGet metadata information about this API resource
/annotation_layer/_info - GETGet a chart detail information.
/chart/{pk} - GETGet a CSS template
/css_template/{pk} - GETGet a report schedule log
/report/{pk}/log/{log_id} - GETGet an Annotation layer
/annotation_layer/{pk} - GETGet a dashboard detail information.
/dashboard/{id_or_slug} - GETGet all schemas from a database
/database/{pk}/schemas/ - GETGet the OpenAPI spec for a specific API version
/openapi/{version}/_openapi - GETCompute and cache a screenshot.
/chart/{pk}/cache_screenshot/ - GETGet charts and dashboards count associated to a dataset
/dataset/{pk}/related_objects - GETGet the chart definitions for a given dashboard
/dashboard/{id_or_slug}/charts - GETGet function names supported by a database
/database/{pk}/function_names/ - GETGet charts and dashboards count associated to a database
/database/{pk}/related_objects/ - GETCompute or get already computed chart thumbnail from cache.
/chart/{pk}/thumbnail/{digest}/ - GETGet a computed screenshot from cache.
/chart/{pk}/screenshot/{digest}/
How automating Apache Superset works
- Describe the outcome. Say what you want to happen, in your own words. No node graphs, no field mapping.
- Approve the contract. HumDay writes down exactly what it will do, what it will touch, and what it will never do. You approve it before anything is built.
- See it proven. The program runs and shows you the result before it is allowed near your live Apache Superset account.
- Grant access, then go live. You approve the specific Apache Superset operations it may use — and only those.
Automate Apache Superset with these
- NetBox844 operations
- Mist768 operations
- Loket.nl641 operations
- DocuSign414 operations
- Osisoft PI 2018 SP1 Swagger Spec413 operations
- Meraki Dashboard263 operations
- Pipedrive196 operations
- Akeneo PIM140 operations
- ID4i106 operations
- Neblio Suite50 operations
- TYK Gateway18 operations
- Personio Personnel Data13 operations
Categories
Questions about Apache Superset automation
- Can HumDay connect to Apache Superset?
- Yes. HumDay reads Apache Superset's own published API description and derives the operations from it, so there is no hand-built connector to wait for. 120 operations are documented.
- Do I need to write code to automate Apache Superset?
- No. You describe the outcome you want in plain words. HumDay agrees a contract with you, writes the program, and shows you a test run before anything touches your Apache Superset account.
- What can HumDay do in Apache Superset?
- 50 of the 120 documented operations change something in Apache Superset, and 70 read from it. HumDay only ever uses the specific operations your approved contract needs.
- Is my Apache Superset account safe?
- Your credentials are stored encrypted and are never shown in chat, code, or logs. Every run is limited to the operations you explicitly approved, and anything that writes to Apache Superset is held behind that approval.
Where this came from
The operations above are read from a published API description for Apache Superset at raw.githubusercontent.com/apache/superset/master/docs/src/resources/openapi.json. Descriptions are the provider’s own words, not ours. Last published 2021-08-09.