Incubator-superset: Can we pass url parameters for dashboards

[Geetha-LMI]

I want to pass the parameters from the user to dashboard. According to the user inputs i want to visualize dashboard. Can you suggest how to do that.

[xiawang]

I have the similar question, I could not find a clear and easy way to programmatically generate an iframe from the superset, or at least there is no such tutorials yet. We could either hack the iframe by passing parameters or hack the source code to provide our own api?

[Ruiya]

+1.I have the same question to use superset to integrate in the web application.

[wangshihan513]

If my understanding is correct, you can do that via Flask RESTAPI
https://flask-appbuilder.readthedocs.io/en/latest/quickhowto.html#rest-api

[mistercrunch]

@graceguo-supercat @williaster ^

[Geetha-LMI]

@mistercrunch I want to trigger the query with the dashboard ui parameters. then want to visualize that query results.

[graceguo-supercat]

Hi @Geetha-LMI for url parameters for dashboard, can you elaborate a little bit, what's input and expected results? What kind of customization you are looking for dashboard?

[Geetha-LMI]

@graceguo-supercat I will give a example. when i pass parameters from the dashboard. Those parameters should pass to the sql lab query. it should execute with those parameters. and i want to visualize those query results in dashboard.

[graceguo-supercat]

@Geetha-LMI Superset dashboard holds a set of chart ids, in which each chart is a list of parameters for a sql lab query, as well as visualization type and some UI styling information. Dashboard can organize charts nicely (defined in position_json), add default filters, inline filters and immunes, add auto refresh functions (in dashboard metadata). Do you want to create related charts by API, then add them into dashboard?

[Geetha-LMI]

@graceguo-supercat I want to pass the parameters to the sql lab query from the ui

[graceguo-supercat]

Flow like: dashboard url parameters -> map to chart parameters -> generate sql lab query -> rendered by charts in dashboard?

[Geetha-LMI]

@graceguo-supercat Yes

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.