Solved: Re: pass quotes inside of tokens for dashboard

johnmvang · ‎11-07-2018

Hello,

I'm looking to pass a token in a dashboard where the value may have quotes, since the token is going into an eval, anyone know how to get that to work? Right now i'm running into eval malformed errors. with quadruple quotes or more depending on how many quotes the user inputs.

Thanks.

kamlesh_vaghela · ‎11-27-2018

@johnmvang
You can escape quote by replacing " to \" on change of input. Just try to insert "ABC" in below provided sample dashboard XML.

<form>
  <label>Quotes</label>
  <fieldset submitButton="false">
    <input type="text" token="field1">
      <label>field1</label>
      <change>
        <eval token="txtValue">replace('value',"\"","\\\"")</eval>
      </change>
    </input>
  </fieldset>
  <row>
    <panel>
      <title>
        $txtValue$
      </title>
      <table>
        <search>
          <query>| stats count | eval A="$txtValue$"</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
      </table>
    </panel>
  </row>
</form>

View solution in original post

kamlesh_vaghela · ‎11-27-2018

@johnmvang
You can escape quote by replacing " to \" on change of input. Just try to insert "ABC" in below provided sample dashboard XML.

<form>
  <label>Quotes</label>
  <fieldset submitButton="false">
    <input type="text" token="field1">
      <label>field1</label>
      <change>
        <eval token="txtValue">replace('value',"\"","\\\"")</eval>
      </change>
    </input>
  </fieldset>
  <row>
    <panel>
      <title>
        $txtValue$
      </title>
      <table>
        <search>
          <query>| stats count | eval A="$txtValue$"</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
      </table>
    </panel>
  </row>
</form>

vasanthi77 · ‎06-27-2019

Hi Kamlesh ,
I had the same problem, was trying the solution provided by you here.
I could see only first occurence is getting replaced.
Can Please you help me here

johnmvang · ‎11-28-2018

Hi Kamlesh, that did it for me. Thanks works great.

kamlesh_vaghela · ‎11-28-2018

Glad to help you @johnmvang
Can you please accept the answer to help the community?

Vijeta · ‎11-26-2018

Can you post some example values for tokens and the code which is giving error

johnmvang · ‎11-26-2018

sure,

i've got a dashboard, where users can fill out 3 forms:

they can input:

'My Title' for input1 - which is a title input.
index="my_index" sourcetype="my_sourcetype" my_search - for the search
then choose a dropdown.

 <panel depends="$show_row2_tok$,$show_r2panel2_tok$">
      <title>Row 2 - Panel 2</title>
      <input type="text" token="r2p2_title">
        <label>Panel Title</label>
        <default></default>
      </input>
      <input type="text" token="r2p2_search">
        <label>Search String</label>
        <default></default>
      </input>
      <input type="dropdown" token="r2p2_viz">
        <label>Visualization Type</label>
        <choice value="column">Column Chart</choice>
        <choice value="line">Line Graph</choice>
        <choice value="stats">Stats Table</choice>
        <default></default>
      </input>
      <html>

    </html>
    </panel>

These will then populate values in a KVstore where i need to write them with an eval:

since i'm enabling users to add a search string into the second input, sometimes they will have quotes inside of their values which will break the search with this error:

Error in 'eval' command: The expression is malformed.

johnmvang · ‎11-26-2018

this all works as long as there are no quotes. just fyi.

pass quotes inside of tokens for dashboard

Adoption of RUM and APM at Splunk

Routing logs with Splunk OTel Collector for Kubernetes

Welcome to the Splunk Community!