Forum Discussion

oceanBlue's avatar
oceanBlue
Data Storage
10-24-2023
Solved

What's the best way to monitor dashboards automatically?

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 Reply

Replies have been turned off for this discussion
  • HamzaJ's avatar
    HamzaJ
    Data Integration
    10-25-2023

    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:

    Hamza