topic Re: How to add download button while hiding the result s of the panel in Splunk Cloud Platform

How to add download button while hiding the result s of the panel

Splunkerninja — Tue, 23 Apr 2024 14:10:26 GMT

I want to add a download/export button which I am able to do so but the issue is the result of the csv is also visible in the panel like below. I want to show only the download button while hiding the results panel which I am not able to do.

<row> <panel> <table> <search> <done> <eval token="date">strftime(now(), "%d-%m-%Y")</eval> <set token="sid">$job.sid$</set> </done> <query>index=test</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">20</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> <html> <a href="/api/search/jobs/$sid$/results?isDownload=true&timeFormat=%25FT%25T.%25Q%25%3Az&maxLines=0&count=0&filename=test_$date$.csv&outputMode=csv" class="button js-button">Download</a> <style> .button { background-color: steelblue; border-radius: 5px; color: white; padding: .5em; text-decoration: none; } .button:focus, .button:hover { background-color: #2A4E6C; color: White; } </style> </html> </panel> </row>

Re: How to add download button while hiding the result s of the panel

renjith_nair — Tue, 23 Apr 2024 13:39:20 GMT

@Splunkerninja ,

Can we add another row only for the html panel and hide the result row/panel with a "depends" token?

Something like

<row> <panel depends="$hide_this_always$"> <table> <search> <done> <eval token="date">strftime(now(), "%d-%m-%Y")</eval> <set token="sid">$job.sid$</set> </done> <query>index=test</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">20</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <html> <a href="/api/search/jobs/$sid$/results?isDownload=true&timeFormat=%25FT%25T.%25Q%25%3Az&maxLines=0&count=0&filename=test_$date$.csv&outputMode=csv" class="button js-button">Download</a> <style> .button { background-color: steelblue; border-radius: 5px; color: white; padding: .5em; text-decoration: none; } .button:focus, .button:hover { background-color: #2A4E6C; color: White; } </style> </html> </row>

Re: How to add download button while hiding the result s of the panel

Splunkerninja — Wed, 24 Apr 2024 08:11:10 GMT

I get this error if i add in different row as you mentioned above

@ITWhisperer Any suggestions pls?

Re: How to add download button while hiding the result s of the panel

Splunkerninja — Thu, 25 Apr 2024 07:06:51 GMT

@ITWhisperer++++ Any suggestions pls?

Re: How to add download button while hiding the result s of the panel

ITWhisperer — Thu, 25 Apr 2024 07:27:51 GMT

Rest assured, if I had any suggestions, I would have given them by now.

Re: How to add download button while hiding the result s of the panel

renjith_nair — Thu, 25 Apr 2024 09:42:17 GMT

@Splunkerninja, this is clearly not due to the row separation but the formation of the URL for getting the search results.

So if the current dashboard is working for you with the search result URL, just make the first change by closing the </row> after the table panel and open another <row> element before the html element. This will ensure that the existing dashboard is working as expected.

As a second step, change the visibility of the row where table is listed and set a "depends" clause with non existing token.

Re: How to add download button while hiding the result s of the panel

Splunkerninja — Thu, 25 Apr 2024 13:12:44 GMT

@renjith_nair Thank You for the response. I keep getting check "network internet connection" when I click on download button and it is failing to download. I was able to download the report once but later I keep getting this error? I know for a fact it is not internet issue because I able to download the other panels data directly when i click the default export button which is there in Splunk. Is it something related to my code?

<row depends="$hide_this_always$"> <panel> <table> <search> <done> <eval token="date">strftime(now(), "%d-%m-%Y")</eval> <set token="sid">$job.sid$</set> </done> <query>index=_internal</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">20</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <panel> <html> <a href="/api/search/jobs/$sid$/results?isDownload=true&maxLines=0&count=0&filename=Vulnerability_$date$.csv&outputMode=csv" class="button js-button">Download</a> <style> .button { background-color: steelblue; border-radius: 5px; color: white; padding: .5em; text-decoration: none; } .button:focus, .button:hover { background-color: #2A4E6C; color: White; } </style> </html> </panel> </row>

Re: How to add download button while hiding the result s of the panel

renjith_nair — Thu, 25 Apr 2024 13:30:39 GMT

Ok, lets check if the results are available by just removing below from the dashboard

depends="$hide_this_always$"

We need to confirm the sid is available since its part of the download path. So either in the title of the panel or somewhere just display the token.

If the result is available and sid is present, try using the URL directly in the browser to make sure that the result is fetched.

Here is a sample dashboard created using the same logic and it works

<dashboard version="1.1" theme="light"> <label>Download</label> <row>  <panel depends="$hide_always$"> <title>$sid$</title> <table> <search> <query>index=_*|stats count by sourcetype</query> <earliest>-15m</earliest> <latest>now</latest> <done> <eval token="date">strftime(now(), "%d-%m-%Y %H:%M:%S")</eval> <set token="sid">$job.sid$</set> </done> </search> <option name="drilldown">none</option> <option name="refresh.display">progressbar</option> </table> </panel> </row> <row> <panel>  <title>Job Id is : $sid$, Time is : $date$</title> <html> <a href="/api/search/jobs/$sid$/results?isDownload=true&timeFormat=%25FT%25T.%25Q%25%3Az&maxLines=0&count=0&filename=test_$date$.csv&outputMode=csv" class="button js-button">Download</a> <style> .button { background-color: steelblue; border-radius: 5px; color: white; padding: .5em; text-decoration: none; } .button:focus, .button:hover { background-color: #2A4E6C; color: White; } </style> </html> </panel> </row> </dashboard>