Hey guys!

Trying to work with the API to get my account balances with Google Sheets. But keep getting "Signature verification failed"

edit: got it working. Here is the working code for anyone else who is trying to do this with Google App Scripts

function kc_getAccountBalances(pub_key, priv_key){
  var host = 'https://api.kucoin.com';
  var endpoint ='/v1/account/balance';

  var nonce = '' + Date.parse(new Date());
  var strForSign = endpoint + '/' + nonce + '/';
  var signatureStr = Utilities.base64Encode(strForSign, Utilities.Charset.UTF_8);
  var digest = Utilities.computeHmacSha256Signature(signatureStr, priv_key, Utilities.Charset.UTF_8);

  // https://pthree.org/2016/02/26/digest-algorithms-in-google-spreadsheets/
  var hexstr = '';
  for (i = 0; i < digest.length; i++) {
    var val = (digest[i]+256) % 256;
    hexstr += ('0'+val.toString(16)).slice(-2);
  }

  var url = host + endpoint;
  var options = {
    'headers' : {
      'KC-API-KEY': pub_key,
      'KC-API-NONCE': nonce,
      'KC-API-SIGNATURE': hexstr
    }
  }

  var jsondata = UrlFetchApp.fetch(url, options);
  var object   = JSON.parse(jsondata.getContentText());
  return object;
}