title: Google Sheets: ImportJSON with key/value pair in request header
body: <p>I'm trying to import a JSON payload into Google Sheets using the ImportJSON function from <a href="https://github.com/bradjasper/ImportJSON" rel="nofollow noreferrer">https://github.com/bradjasper/ImportJSON</a>.</p>
  
  <p>The service I'm trying to consume requires an "authorization" key/value pair supplied in the request header:
  <a href="https://groups.caremonkey.com/api/docs/" rel="nofollow noreferrer">https://groups.caremonkey.com/api/docs/</a></p>
  
  <p>I'm failing to work out how to send this header in the ImportJSON function.</p>
  
  <p>I've read through the documentation, tested the API with PostMan (success) and tried a few variations of the function call below. =importjson(<a href="https://groups.caremonkey.com/api/v2/organizations/_ORG_ID_/child_groups" rel="nofollow noreferrer">https://groups.caremonkey.com/api/v2/organizations/_ORG_ID_/child_groups</a>, "authorize=<em>tokenkey</em>")</p>
  
  <p>I've also tried the ImportJSONViaPost function (even though the operation is a GET), as well as changing Line 118 from 
    postOptions["method"] = "POST"; 
  to
    postOptions["method"] = "GET"; </p>
  
  <p>I just can't figure out a way to send a header as part of the request.</p>
  
  <p>Can anyone help me figure out what I've missed please?</p>
  
  <p>Cheers,
  Tim</p>