cancel
Showing results for 
Search instead for 
Did you mean: 

Get all data models (ECs and live) used in a dashboard, for all dashboards

daniel_guerra
7 - Data Storage
7 - Data Storage

Hello, community!!

We are wondering if there is a way we can extract all the data sources in a dashboard, for all dashboards...
The goal is to cleanse all those orphan data models. (Not related to any dashboard).

Regards.

1 REPLY 1

HamzaJ
12 - Data Integration
12 - Data Integration

Hey @daniel_guerra 

As an admin you could use the rest-api to get this info. Log in and go to the following URL:

https://XXXX/api/v1/dashboards/admin?dashboardType=owner&asObject=false&fields=_id%2Coid%2Ctitle%2Cd...

This will generate a JSON of all dashboards with their ID, title and datasource. Import this into Excel and you will have a nice overview. 

If you have a lot of dashboards in your system, you could also use SKIP and LIMIT to page through them. Go to Admin > RESTAPI > V1 > Admin > Get all dashboards

Hamza