topic How to populate dropdown values from csv file using javascript? in Dashboards & Visualizations

How to populate dropdown values from csv file using javascript?

kevshah — Mon, 15 Feb 2016 16:46:00 GMT

I've input lookup table csv file in splunk envrinoment where I want to pull dropdown values from. Since I am new to HTML dashboarding in splunk, I don't know how to search inputlook up table using javascript.

This is how I am doing in Advanced xml, any idea how to achieve this in HTML dashboard?

 <module name="Search" autoRun="True">
      <param name="search"><![CDATA[
| inputlookup xvz.csv | fillnull value=* | fields Index, sourcetype, env, jvm_name]]></param>


       <module name="Pulldown">
          <param name="postProcess">dedup sourcetype | sort sourcetype</param>
          <param name="cssClass">dropBox</param>
          <param name="size">6</param>
          <param name="valueField">sourcetype</param>
          <param name="staticOptions"/>
          <param name="name">sourcetype</param>
          <param name="template">sourcetype=$value$</param>
          <param name="label">Sourcetype</param>

</module>
</module>

Re: How to populate dropdown values from csv file using javascript?

asimagu — Tue, 16 Feb 2016 15:15:29 GMT

I suggest that you build this dashboard in Simple XML and then use the built-in feature of converting to HTML. You will have your dashboard working plus you will learn how it is done in HTML 😉

Re: How to populate dropdown values from csv file using javascript?

kevshah — Tue, 16 Feb 2016 16:35:11 GMT

I tried that and it works but it creates a default splunk dropdown view, my requirement is to create more customized view. Any idea on how to create custom view?

Re: How to populate dropdown values from csv file using javascript?

asimagu — Wed, 02 Mar 2016 12:37:30 GMT

what about using the Javascript sdk for Splunk?