Zaimでは外部のサービスと連携するためにAPIを公開している。
認証はoAuth1.0aに対応しているのだが、GoogleAppsScriptと相性が悪いのか、
oAuthエラーというエラーが発生し認証に失敗する。
丸1日費やしたが失敗の原因がわからないのでひとまず撤収。
もし「できる！知ってるよ！」という方がいたら教えてください。
私が書いたコードを一応のせておきます。
var oAuthConfig = function(serviceName,accessTokenURL,requestTokenUrl,authorizationUrl){
var m_methods = {};
var m_oAuthConfig = UrlFetchApp.addOAuthService(serviceName);
m_oAuthConfig.setAccessTokenUrl( accessTokenURL );
m_oAuthConfig.setRequestTokenUrl( requestTokenUrl );
m_oAuthConfig.setAuthorizationUrl( authorizationUrl );
var setConsumerKeyAndSecret = function(key,secret){
ScriptProperties.setProperty('consumerKey', key);
ScriptProperties.setProperty('consumerSecret', secret);
m_oAuthConfig.setConsumerKey(ScriptProperties.getProperty('consumerKey'));
m_oAuthConfig.setConsumerSecret(ScriptProperties.getProperty('consumerSecret'));
}
m_methods.setConsumerKeyAndSecret = setConsumerKeyAndSecret;
var getConfig = function(){ return m_oAuthConfig; }
m_methods.getConfig = getConfig;
var authConfigDump = function(){
Logger.log('AccessTokenURL->' + m_oAuthConfig.getAccessTokenUrl());
Logger.log('AuthorizationUrl->'+ m_oAuthConfig.getAuthorizationUrl());
Logger.log('Method->' + m_oAuthConfig.getMethod());
Logger.log('ParameterLocation->' + m_oAuthConfig.getParamLocation());
Logger.log('RequestTokenURL->' + m_oAuthConfig.getRequestTokenUrl());
Logger.log('ServiceName->' + m_oAuthConfig.getServiceName());
}
m_methods.authConfigDump = authConfigDump;
//create nonce from SHA-1 Digest
var getNonce = function(){
var now = new Date();
var nonce = Utilities.computeDigest(Utilities.DigestAlgorithm.SHA_1,now.getTime(),Utilities.Charset.US_ASCII);
var strNonce = bytes2StringDigest(nonce);
Logger.log('nonce(bytes2StringDigest)->' + strNonce);
return strNonce;
}
m_methods.getNonce = getNonce;
return m_methods;
}
var urlString = function(url){
var m_methods = {};
var m_response = UrlFetchApp.getRequest(url);
var m_methodName = m_response.method;
var m_url = m_response.url;
var getMethod = function(){return m_methodName;}
m_methods.getMethod = getMethod;
var getUrl = function(){ return encodeURIComponent( m_url.split('?')[0] );}
m_methods.getUrl = getUrl;
var getQueryStrings = function(){ return encodeURIComponent( m_url.split('?')[1] ); }
m_methods.getQueryStrings = getQueryStrings;
var dump = function(){
for(var i in m_response) {
Logger.log(i + ": " + m_response[i]);
}
}
m_methods.dump = dump;
return m_methods;
}
var getOAuthSignature = function(url,common_param_oauth){
//HASHMAC Signature
var urlStr = urlString(url);
var sign_url = encodeURIComponent(urlStr.getUrl());
var sign_param = encodeURIComponent(urlStr.getQueryStrings());
var sign_source = 'GET' + '&'+ sign_url + '&' +
// 'oauth_body_hash' + encodeURIComponent('=') + common_param_oauth.oauth_body_hash + '&' +
'oauth_consumer_key' + encodeURIComponent('=') + common_param_oauth.oauth_consumer_key + '&' +
'oauth_nonce' + encodeURIComponent('=') + common_param_oauth.oauth_nonce +'&' +
'oauth_signature_method' + encodeURIComponent('=') + common_param_oauth.oauth_signature_method +'&' +
'oauth_timestamp' + encodeURIComponent('=') + common_param_oauth.oauth_timestamp + '&' +
'oauth_version' + encodeURIComponent('=') + '1.0';
//if (sign_param != undefined){ sign_source = sign_source + '&' + sign_param }
Logger.log('SIGN_SOURCE->' + sign_source);
//create Signature(HMAC SHA-1) and encode BASE64.
var tmpSignature = Utilities.computeHmacSignature(Utilities.MacAlgorithm.HMAC_SHA_1,sign_source,common_param_oauth.oauth_consumer_key);
common_param_oauth.oauth_signature = Utilities.base64Encode(tmpSignature);
Logger.log('Signature(bytecode)->' + tmpSignature );
Logger.log('Signature(base64)->' + common_param_oauth.oauth_signature );
return common_param_oauth.oauth_signature;
}
/////////////////////
//MAIN
/////////////////////
function main(){
var serviceName = 'Zaim';
var accessTokenUrl = "https://api.zaim.net/v2/auth/access";
var requestTokenUrl = "https://api.zaim.net/v2/auth/request";
var authorizationUrl = "https://www.zaim.net/users/auth";
var key = '
Your consumerKey';
var secret = '
Your consumerSecret';
var methodName = 'get'; //default get
var paramLocation = 'auth-header'; //Allowed values are 'post-body', 'uri-query' and 'auth-header'.
var tergetUrl = 'https://api.zaim.net/v2/home/user/verify';
var response='';
try{
var oAuthConf = oAuthConfig(serviceName,accessTokenUrl,requestTokenUrl,authorizationUrl);
oAuthConf.setConsumerKeyAndSecret(key,secret);
oAuthConf.authConfigDump();
oAuthConf.getConfig().setMethod( methodName );
oAuthConf.getConfig().setParamLocation( paramLocation );
oAuthConf.authConfigDump();
Logger.log('key->' + ScriptProperties.getProperty('consumerKey'));
Logger.log('secret->' + ScriptProperties.getProperty('consumerSecret'));
var now = new Date();
var common_param_oauth =
{
'oauth_consumer_key' : ScriptProperties.getProperty('consumerKey'),
'oauth_signature' : '', //see after code.
'oauth_signature_method' : 'HMAC-SHA1',
'oauth_token' : '',
//'oauth_timestamp' : now.getTime(),
//'oauth_nonce' : oAuthConf.getNonce(),
'oauth_timestamp' : '',
'oauth_nonce' : '',
'oauth_version' : '1.0'
//'oauth_body_hash' : ''
};
getOAuthSignature(tergetUrl,common_param_oauth );
Logger.log('COMMON_PARAM_OAUTH->' + Utilities.jsonStringify(common_param_oauth));
var options =
{
"oAuthServiceName" : serviceName,
"oAuthUseToken" : "always",
"method" : methodName,
//"headers" : '',
//"payload" : common_param_oauth,
"muteHttpExceptions" : true
};
Logger.log('options->' + Utilities.jsonStringify(options));
//var response = UrlFetchApp.fetch( tergetUrl );
response = UrlFetchApp.fetch( tergetUrl , options );
}catch(e){
Logger.log('main failure.' + e.message);
}
}
2013/11/27
再チャレンジしたが認証エラーでやはりNG。
上のソースコードはかなり間違いがあるのだが、再度oauth_signatureの作成方法(アルゴリズム、パラメータのソート、URIエンコード・・・)などを
oauth1.0の仕様書に基づきトライしてもダメ。
ということでGoogle Apps Scriptとの連携は一旦あきらめる。
