Downloading multiple CSV files from grafanna

Help IT Automation
1

Hi All,
Can you please help me How can we download multiple csv files from Grafanna webpage.

Thanks in Advance.

2

@Kumari_Neha

Welcome to fourms

Can you share the screenshot how the CSV files are arranged in the webpage?

Thanks,
Srini

3

Thanks for your response.

Screenshot
Screenshot1804×429 78.1 KB

this is how it arranged and it needs to be downloaded on current date.

4

Hi @Kumari_Neha

You can try this approach

  1. Use Data scrapping option to scrape all values under View report column, also extract URL along with their names while data scrapping.

  2. Loop through each value in datatable obtained as output of step 1, then use navigate to to go the link for every iteration and downloads it by saving with file name

Another way to try is ,

extract only names /values under View Report and loop through it, by fine tuning selectors, click on report name value and save it :slight_smile:

Hope this helps :slight_smile:

Thanks & Regards,
Nived N
Happy Automation

5

A workaround to work only in background is to get report file from /opt/influx/ex… path using SFTP
Official FTP Package suports not only FTP and FTPS but also SFTP that uses SSH to connect natively to linux based systems.

image

Hope it helps!