Automate export of Kibana dashboard CSV

Hi All,

I need to download the CSV data that generated by Kibana dashboard.

image

I'm struggling with selenium to automate the manual download without much luck

But it seems like very not generic and robust way to do that, looking for css and class elements which probably change between versions and will probably break.

If i understood correctly there isn't formal API for that

How can i do that?

Any help would be appreciated
Regards

Hi,

there is no API to download CSV from a visualization on a dashboard. This export and generation of CSV is happening client-side in your browser for the data loaded, thus nothing that has a server side API.

You can though inspect the query that is send behind that chart and potentially just write your own script that sends that query to Elasticsearch directly and converts it into a CSV, but currently Kibana doesn't offer something for that.

Cheers,
Tim

Thanks for your answer!

So there's no official way for automated testing of the values the Kibanas' dashboard show?

How can I extract that ES query?

There is no API to extract those values from a dashboard panel, no. Except as you are doing by using an browser automation tool.

You can see the query by using the Inspector:

screenshot-20210709-141914

And then Select on the top "View: Request". This is not available though for all visualization types, e.g. TSVB visualizations don't have that option.