We are wanting to download a looker dashboard straight to a local machine. I have this code that I think I’m suppose to use, we are bit of a noob at python and I don’t really understand where I’m supposed to put my dashboard ID and filters at in this python script below. Can someone give me an example on where I’m suppose to put my information in?
“”"Given a dashboard title, search all dashboards to retrieve its id, render and export the dashboard to pdf.
$ python download_dashboard_pdf.py <dashboard_filters> <dashboard_style> <pdf_width> <pdf_height>
Note: dashboard_style defaults to “tiled”, pdf_width defaults to 545, pdf_height defaults to 842
Examples:
$ python download_dashboard_pdf.py “A Test Dashboard”
$ python download_dashboard_pdf.py “A Test Dashboard” ‘{“filter1”: “value1, value2”, “filter2”: “value3”}’
$ python download_dashboard_pdf.py “A Test Dashboard” {} “single_column”
Last modified: August 25, 2021
“”"
import json
import urllib
import sys
import textwrap
import time
from typing import cast, Dict, Optional
import looker_sdk
from looker_sdk import models
sdk = looker_sdk.init40(“lookers.ini”)
def main():
dashboard_title = sys.argv[1] if len(sys.argv) > 1 else “”
filters = json.loads(sys.argv[2]) if len(sys.argv) > 2 else None
pdf_style = sys.argv[3] if len(sys.argv) > 3 else “tiled”
pdf_width = int(sys.argv[4]) if len(sys.argv) > 4 else 545
pdf_height = int(sys.argv[5]) if len(sys.argv) > 5 else 842
if not dashboard_title:
raise Exception(
textwrap.dedent(
“”"
Please provide: <dashboard_title> [<dashboard_filters>] [<dashboard_style>] [<pdf_width>] [<pdf_height>]
dashboard_style defaults to “tiled”
pdf_width defaults to 545
pdf_height defaults to 842"“”
)
)
dashboard = cast(models.Dashboard, get_dashboard(dashboard_title))
download_dashboard(dashboard, pdf_style, pdf_width, pdf_height, filters)
def get_dashboard(title: str) → Optional[models.Dashboard]:
“”“Get a dashboard by title.”“”
title = title.lower()
dashboard = next(iter(sdk.search_dashboards(title=title)), None)
if not dashboard:
raise Exception(f’dashboard “{title}” not found’)
return dashboard
def download_dashboard(
dashboard: models.Dashboard,
style: str = “tiled”,
width: int = 545,
height: int = 842,
filters: Optional[Dict[str, str]] = None,
“”“Download specified dashboard as PDF”“”
id = dashboard.id
task = sdk.create_dashboard_render_task(
id,
“pdf”,
models.CreateDashboardRenderTask(
dashboard_style=style,
dashboard_filters=urllib.parse.urlencode(filters) if filters else None,
),
width,
height,
)
if not (task and task.id
raise Exception(
f’Could not create a render task for “{dashboard.title}”’
)
poll the render task until it completes
elapsed = 0.0
delay = 0.5 # wait .5 seconds
while True:
poll = sdk.render_task(task.id)
if poll.status == “failure”:
print(poll)
raise Exception(
f’Render failed for “{dashboard.title}”’
)
elif poll.status == “success”:
break
time.sleep(delay)
elapsed += delay
print(f"Render task completed in {elapsed} seconds")
result = sdk.render_task_results(task.id)
filename = f"{dashboard.title}.pdf"
with open(filename, “wb”) as f:
f.write(result)
print(f’Dashboard pdf saved to “{filename}”')
main()