title: get values from JSON file by field name
body: <p>We want to store and retrieve variables from a JSON file within our Alteryx workflow. We are able to run it through the Input Data tool, and it previews the data like so:</p>
  <pre><code>  JSON_Name      Json_ValueString
  1 BaseUrl   {url}
  2 Api /api/download
  3 UserDirectory {directory}
  4 AccessToken {token}
  5 DatasetName {name}
  </code></pre>
  <p>So far, so good, but we would like to pull the values from here and use them in our formula.</p>
  <p>For example, using Formula tool to concatenate BaseUrl+Api, create the text of the Authorization header by doing &quot;Bearer &quot;+AccessToken, etc.</p>
  <p>We can do that with the TextInput tool pretty easily, just by selecting these values from dropdowns, or by using</p>
  <pre><code>%AccessToken%
  </code></pre>
  <p>However, that doesn't seem to work the same way with the Input Data.</p>
  <p>Is there a way to retrieve fields in a JSON by name?</p>