无法通过节点中的云端硬盘 API 获取文件错误:超出未经身份验证使用的每日限制.继续使用需要注册

Question

这是完整的错误：

{
 "error": {
  "errors": [
   {
    "domain": "usageLimits",
    "reason": "dailyLimitExceededUnreg",
    "message": "Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup.",
    "extendedHelp": "https://code.google.com/apis/console"
   }
  ],
  "code": 403,
  "message": "Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup."
 }
}

我想做的是将特定Google表格的内容下载到我的桌面。我遵循了此处和此处概述的Google云端硬盘API文档，因此我不知道我哪里出错了。

以下是完整的代码：

var express = require('express');
var app = express();
var fs = require('fs');
var readline = require('readline');
var google = require('googleapis');
var googleAuth = require('google-auth-library');
var SCOPES = [
            'https://www.googleapis.com/auth/drive'
             ];
var TOKEN_DIR = (process.env.HOME || process.env.HOMEPATH ||
    process.env.USERPROFILE) + '/.credentials/';
var TOKEN_PATH = TOKEN_DIR + 'test-app-1.json';

fs.readFile('client_secret.json', function processClientSecrets(err, content) {
  if (err) {
    console.log('Error loading client secret file: ' + err);
    return;
  }
  authorize(JSON.parse(content), getFile);
});

function authorize(credentials, callback) {
  var clientSecret = credentials.installed.client_secret;
  var clientId = credentials.installed.client_id;
  var redirectUrl = credentials.installed.redirect_uris[0];
  var auth = new googleAuth();
   oauth2Client = new auth.OAuth2(clientId, clientSecret, redirectUrl);
  fs.readFile(TOKEN_PATH, function(err, token) {
    if (err) {
      getNewToken(oauth2Client, callback);
    } else {
       var token = token; 
      oauth2Client.credentials = JSON.parse(token);
      callback(oauth2Client);
    }
  });
}
function getNewToken(oauth2Client, callback) {
  var authUrl = oauth2Client.generateAuthUrl({
    access_type: 'offline',
    scope: SCOPES
  });
  console.log('Authorize this app by visiting this url: ', authUrl);
  var rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout
  });
  rl.question('Enter the code from that page here: ', function(code) {
    rl.close();
    oauth2Client.getToken(code, function(err, token) {
      if (err) {
        console.log('Error while trying to retrieve access token', err);
        return;
      }
      oauth2Client.credentials = token;
      storeToken(token);
      callback(oauth2Client);
    });
  });
}

function storeToken(token) {
  try {
    fs.mkdirSync(TOKEN_DIR);
  } catch (err) {
    if (err.code != 'EEXIST') {
      throw err;
    }
  }
  fs.writeFile(TOKEN_PATH, JSON.stringify(token));
  console.log('Token stored to ' + TOKEN_PATH);
}
function getFile(auth) {
    var drive = google.drive('v3');
    var fileId = '<FileId>';
    var dest = fs.createWriteStream('/desktop/test.xlsx');
    drive.files.get({
        fileId: fileId,
        mimeType: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
        })
        .on('end', function() {
            console.log('Done');
            })  
        .on('error', function(err) {
    console.log('Error during download', err);
    })  
        .pipe(dest);    
}

Answer 1

你不要在代码中使用auth。另外，你想要一种特殊的格式，我建议改用export。

function getFile(auth) {
    var drive = google.drive('v3');
    var fileId = '<FileId>';
    var dest = fs.createWriteStream('/desktop/test.xlsx');
    drive.files.export({
        auth: auth,
        fileId: fileId,
        mimeType: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
    })
    .on('end', function() {
        console.log('Done');
    })  
    .on('error', function(err) {
        console.log('Error during download', err);
    })  
    .pipe(dest);    
}