How to find all dashboards using particular query? (via API or another way)

[vladislav-finogeev]

Hi everyone!
How to find all dashboards using a particular query?
I don't see such functionality in the web interface; maybe there is a way by API?
ChatGPT suggested this command:
curl -X GET -H "Authorization: Key <your_api_key>" http://your-redash-instance/api/queries/<query_id>/visualizations
But the current API doesn't support 'visualization' for query_id.

[masayuki038]

Hi @vladislav-finogeev,

Can you do that by calling /api/dashboards and /api/dashboards/(dashboard_id)? The later one returns queries in a dashboard like this:

(...snip...)
      "updated_at": "2023-12-30T11:22:53.153Z",
      "created_at": "2023-12-30T11:22:50.287Z",
      "visualization": {
        "id": 1,
        "type": "TABLE",
        "name": "Table",
        "description": "",
        "options": {},
        "updated_at": "2023-12-30T11:22:50.287Z",
        "created_at": "2023-12-30T09:48:33.471Z",
        "query": {
          "id": 1,
          "latest_query_data_id": 5,
          "name": "Test",
          "description": null,
          "query": "select count(*) from query_results",
          "query_hash": "9f0af7f4fc6a8b0ff0c9233cee34d579",
          "schedule": null,
          "api_key": "ZUe3m2494Pt7kapVhQKPLmeRXghODDWdOPlgwv7Q",
          "is_archived": false,
          "is_draft": false,
          "updated_at": "2023-12-30T09:49:25.763Z",
          "created_at": "2023-12-30T09:48:33.471Z",
(...snip...)

[gaecoli]

https://github.com/getredash/redash-toolbelt/tree/master/redash_toolbelt

You can use this doc.

[gaecoli]

And you can connect redash pg to run sql:

select
q.id
, q.name
from public.dashboards d
left join public.widgets w on w.dashboard_id = d.id
left join public.visualizations v on v.id = w.visualization_id
left join public.queries q on q.id = v.query_id
where d.id = 1 -- change you dashboard id