title: Coinmarketcap Authenticated API error: 400 "\"value\" must contain at least one of [id, symbol, slug]",
body: <p>Using Google Sheets Script I am Attempting to run this function and it does not seem to be recognizing my "qs: {'id': '1'}," Line</p>
  
  <p>Getting result </p>
  
  <pre><code>{
      "status": {
          "timestamp": "2019-07-15T06:41:31.753Z",
          "error_code": 400,
          "error_message": "\"value\" must contain at least one of [id, symbol, slug]",
          "elapsed": 0,
          "credit_count": 0
      }
  }
  </code></pre>
  
  <p>My API Key is in </p>
  
  <p>sheet ="Config" </p>
  
  <p>Cell ="B35"</p>
  
  <p>This is not the problem because if I remove the API key it gives an "invalid API error" so I know the address and API are correct.</p>
  
  <p>Im expecting a result as described in the documentation here 
  <a href="https://coinmarketcap.com/api/documentation/v1/#operation/getV1CryptocurrencyQuotesLatest" rel="nofollow noreferrer">https://coinmarketcap.com/api/documentation/v1/#operation/getV1CryptocurrencyQuotesLatest</a></p>
  
  <pre><code>function test() {
      var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Config");
      var key = sheet.getRange("B35").getValue()
      var options = {
          muteHttpExceptions: true,
          headers : {'X-CMC_PRO_API_KEY': key},
          qs: {'id': '1'},
          json: true,
          gzip: true
      }
  
      var url = "https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest";
  
      var response = UrlFetchApp.fetch(url, options);
  
      SpreadsheetApp.getActiveSpreadsheet().getSheetByName("workingArea01").getRange('!F2').setValue(response);
  }
  </code></pre>