title: Converting Google Visualization Query result into JSON
body: <p>I am a beginner trying to read a Google Sheet in a Javascript app using: <a href="https://docs.google.com/spreadsheets/d/mySheetID/gviz/tq?tq=Select%20*%20where%20A%20=%20%22Nan%22&amp;tqx=out:JSON" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/mySheetID/gviz/tq?tq=Select%20*%20where%20A%20=%20%22Nan%22&amp;tqx=out:JSON</a></p>
  <p>I can access that row in my sheet and save it as JSON giving me a file with the content headed &quot;/O_o/
  google.visualization.Query.setResponse...&quot; This is the file I cannot further process in javascript.</p>
  <p>I see in: <a href="https://stackoverflow.com/questions/31765773/converting-google-visualization-query-result-into-javascript-array/64377070#64377070">converting Google Visualization Query result into javascript array</a>
  that the solution appears to be: &quot;If you add a header named X-DataSource-Auth in your request, the Visualization API will respond in JSON format&quot;. After a day of googling I am quite unable to find where I am supposed to put such a header and what its syntax should be.</p>
  <p>But then I'm 82 years old and this stuff gets more difficult with each passing year... Can someone point me in the right direction?</p>