Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

API to get a list of LookML dashboards

  • 28 May 2020
  • 8 replies
  • 1167 views
gsvitak

Hi there…


Can someone point me in the direction of how to get a list of LookML Dashboards?


Thanks

Greg

8 replies

Cyril_MTL_Analytics
Userlevel 5
Badge

Hello @gsvitak,


Have you tried the GET all_dashboards?


From there, you can filter on dashboards that have those attributes:


“user_id”: null,

“space”: {

“name”: “LookML Dashboards”,

“parent_id”: null,

“id”: “lookml”,

“content_metadata_id”: null,

“created_at”: null,

“creator_id”: null,

…

gsvitak

thank you!

noah-bytecode

Hi,

 

The GET /dashboards endpoint is only for regular dashboards. LookML Dashboards are entirely different. They are dashboards defined by a LookML file.

 

I am attempting to create new dashboards by importing an existing LookML Dashboard.
 

POST /dashboards/{lookml_dashboard_id}/import/{space_id}

 

I can’t find the LookML Dashboards anywhere though outside of the projects in the looker UI. The Looker UI doesn’t show you the ID of the LookML Dashboards.


Is there any way to find LookML Dashboards and their respective ids?

kbollG

Did you find the answer to this?

“Is there any way to find LookML Dashboards and their respective ids?”

Arnaud de T

Looking for that one too!

kbollG

Hi, 

 

I was able to use the all_dashboards GET endpoint as Cyril suggested above, thank you.

 

Here’s the location in the Python SDK I’m using: https://github.com/looker-open-source/sdk-codegen/blob/main/python/looker_sdk/sdk/api31/methods.py#L2248

and a snippet of my usage:

    all_dashboards = sdk.all_dashboards()

    for d in all_dashboards:
        space = d.get('space')
        space_name = space.get('name')

        if space_name == 'LookML Dashboards':

            dash_title = d.get('title')

            dashboard_id = d.get('id')

 

masutaka
Userlevel 3

The alternative solution, Looker CLI “Gazer”:

https://github.com/looker-open-source/gzr

Lan
Rank
Userlevel 4

@kbollG - your solution is clever as all LookML dashboards are currently stored inside the “LookML Dashboards” folder (previously known as “spaces”). I like it

Reply


Terms of Service