How to Obtain a Dashboard's Data Sources in Bold BI
This article will guide you on how to get the linked data sources of a dashboard in Bold BI Application.
Using Web Application
-
Go to the data source listing page.
{domain_name}/bi/site/{site_identifier}/data-sources
-
In the search box, enter the following search query to get the list of data sources used in that dashboard:
dashboard:{dashboard-name}
.{dashboard-name}
should be provided as the exact name of the dashboard because this will filter the dashboards which matches the provided name and then lists their data sources.
-
Click the Context menu of the data source and select the Info option, this will provide the details about the data source.
Using REST API
Using Bold BI REST API, you can get the dashboard’s data source details.
Authentication:
Users who have Read/Write access to the data sources and dashboards can get the data sources details of a dashboard. When the user signs into the Bold BI, an authentication token is provided that should be attached in the request header (Authorization) for all subsequent API calls to authenticate the requests.
Generate access token using password or embed secret authentication
Get Data sources of dashboard:
URL : {domain_name}/bi/api/site/{site_identifier}/v4.0/dashboards/shared-datasources
Method: Get
Content Type: application/json
AUTHORIZATIONS: bearer token
Request Body Schema
{
"DashboardId":"GUID"
}
Example:
{
"DashboardId":"178d231e-32b2-46db-b4a0-f0df2fb60fac"
}
Response Schema:
[
{
"DataSourceName": "Northwind Traders Sales Analysis",
"DataSourcePath": "69a3ac5a-2059-4b9b-b638-238dc518bc47/1",
"DataSourceId": "69a3ac5a-2059-4b9b-b638-238dc518bc47",
"IsEmbeded": false,
"CanRead": true,
"CanWrite": true,
"CanDelete": true
},
{
"DataSourceName": "ext",
"DataSourcePath": "341090a2-5775-43de-a932-a47f93e0da22/2",
"DataSourceId": "341090a2-5775-43de-a932-a47f93e0da22",
"IsEmbeded": false,
"CanRead": true,
"CanWrite": true,
"CanDelete": true
}
]
Note: This is an internal API, and we didn’t expose this API public.