download_dashboard.sql

download_dashboard.sql

INSTALL http_client FROM community;
LOAD http_client;

-- Generate key with `dashboard:read` permission in Admin UI
SET VARIABLE shaperkey = 'myshaperkey';

-- Returns file as BLOB
CREATE TEMP MACRO download_dashboard(id, ext) AS
  (SELECT content FROM read_blob(concat('http://localhost:5454', http_get(
    concat('http://localhost:5454/api/dashboards/', id, '/download/result.', ext, '?mode=url'),
    headers => MAP {
      'Authorization': concat('Bearer ', getvariable('shaperkey')),
      'Accept': 'application/json'
    },
    MAP {}
  )->>'body'->>'url')));

SELECT download_dashboard('mydashboardid', 'pdf');
SELECT download_dashboard('mydashboardid', 'png');
SELECT download_dashboard('mydashboardid', 'xlsx');
SELECT download_dashboard('mydashboardid', 'csv');
SELECT download_dashboard('mydashboardid', 'json');