cancel
Showing results for 
Search instead for 
Did you mean: 

What's the best way to monitor dashboards automatically?

oceanBlue
7 - Data Storage
7 - Data Storage

I have a bunch of dashboards with widgets and filters, and need to compare the values on the dashboards (after applying the filters, etc) with the results of  hive queries run against the data warehouse.  Currently it's done manually and human labor intensive, so needs to be automated.

There was a proposal to scrape the dashboards using Beautiful Soup (or similar tools) + Selenium.  But I'm wondering whether it can be done through API, which will be more reliable and with lower maintenance.  Thanks a lot for sharing your opinion.

 

1 ACCEPTED SOLUTION

HamzaJ
12 - Data Integration
12 - Data Integration

Hello @oceanBlue ,

Essentially every widget in every dashboard gets its result by doing an API-call to the Elasticube and displaying the result. This API-call contains all fields used plus all filters applied to get the result shown in the dashboard. You could fire of a couple of api-calls and then compare them. 

Easiest way to get the required API-request is to open the developers console , load the dashboard and copy the api request.

URL will be something like: https://DOMAIN/api/datasources/CUBENAME/jaql

Request will be something like:

HamzaJ_0-1698220577904.png

Hamza

 

 

 

View solution in original post

1 REPLY 1

HamzaJ
12 - Data Integration
12 - Data Integration

Hello @oceanBlue ,

Essentially every widget in every dashboard gets its result by doing an API-call to the Elasticube and displaying the result. This API-call contains all fields used plus all filters applied to get the result shown in the dashboard. You could fire of a couple of api-calls and then compare them. 

Easiest way to get the required API-request is to open the developers console , load the dashboard and copy the api request.

URL will be something like: https://DOMAIN/api/datasources/CUBENAME/jaql

Request will be something like:

HamzaJ_0-1698220577904.png

Hamza

 

 

 

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]