如何使用 Google Apps 脚本中的 UrlFetchApp 发出 Drive API 批量请求

问题描述

我想知道如何在 Google Apps 脚本中使用 UrlFetchApp 发出 Drive API 批量请求.我已经阅读了谷歌文档，但我仍然不清楚.我想将下面的代码转换为接受多个文件 ID 的批处理请求.

I would like to know how to make a Drive API batch request with UrlFetchApp in Google Apps Script. I've read the google documentation but it still isn't clear to me. I want to convert the code below into a batch request accepting multiple file IDs.

var url = 'https://www.googleapis.com/drive/v2/files/FILEID/permissions';

var data = {
    "role":"owner",
    "type":"user",
    "value": NEWOWNER
  };

var response = UrlFetchApp.fetch(url, {
  headers: {
    Authorization: 'Bearer ' + AUTHORIZATIONTOKEN
  },
  method: 'post',
  contentType: 'application/json',
  payload: JSON.stringify(data),
});
var result = JSON.parse(response.getContentText());

我尝试使用 https://www.googleapis.com/drive/v2/files?id=FILEID1&id=FILEID2/permissions 但它似乎不起作用.我刚刚看到将每个文件请求嵌套到批处理请求的描述，但到目前为止我还没有找到正确执行此操作的语法示例.

I tried using https://www.googleapis.com/drive/v2/files?id=FILEID1&id=FILEID2/permissionsbut it seemed to be not working. I just saw description of nesting each file request to a batch request, but so far I have not found a syntax example for doing it correctly.

一些见解会有所帮助.谢谢！

Some insight would be helpful. Thanks!

推荐答案

这个示例脚本怎么样?当我看到这份文档时，我发现你想要调用的API使用 multipart/mixed 发送批处理请求.这样，我可以为 Google Apps 脚本创建一个示例脚本，如下所示.

How about this sample script? When I saw this document, I could find that the API calls you want to do batch request are sent using multipart/mixed. By this, I could create a sample script for Google Apps Script as follows.

function myFunction() {
  var body = [
    {
      method: "POST",
      endpoint: "https://www.googleapis.com/drive/v3/files/### fileId 1 ###/permissions",
      requestBody: {
       "role": "owner",
       "type": "user",
       "emailAddress": NEWOWNER
      }
    },
    {
      method: "POST",
      endpoint: "https://www.googleapis.com/drive/v3/files/### fileId 2 ###/permissions",
      requestBody: {
       "role": "owner",
       "type": "user",
       "emailAddress": NEWOWNER
      }
    }
  ];

  var boundary = "xxxxxxxxxx";
  var contentId = 0;
  var data = "--" + boundary + "
";
  for (var i in body) {
        data += "Content-Type: application/http
";
        data += "Content-ID: " + ++contentId + "

";
        data += body[i].method + " " + body[i].endpoint + "
";
        data += body[i].requestBody ? "Content-Type: application/json; charset=utf-8

" : "
";
        data += body[i].requestBody ? JSON.stringify(body[i].requestBody) + "
" : "";
        data += "--" + boundary + "
";
  }
  var payload = Utilities.newBlob(data).getBytes();
  var options = {
    method: "post",
    contentType: "multipart/mixed; boundary=" + boundary,
    payload: payload,
    headers: {'Authorization': 'Bearer ' + ScriptApp.getOAuthToken()},
    muteHttpExceptions: true,
  };
  var res = UrlFetchApp.fetch("https://www.googleapis.com/batch", options).getContentText();
  Logger.log(res);
}

注意:

• 请根据您的环境修改此示例脚本.
• 如果您需要更多 API，请将元素添加到body"数组中.
• 假设您已启用 Drive API.
• Drive API 在一个批处理请求中最多可以使用 100 次调用.这是一个限制.
• 对于批量请求，每个 API 调用不保证顺序.

在我的环境中，我确认这有效.但是，如果这在您的环境中不起作用，请告诉我.我要修改.

In my environment, I confirmed that this works. But if this didn't work in your environment, please tell me. I would like to modify.

这篇关于如何使用 Google Apps 脚本中的 UrlFetchApp 发出 Drive API 批量请求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！