google-drive-api - 是否可以从 Google 文档内部发送 HTTP 请求？

Question

我想从 Google 驱动器电子表格向某些 REST 服务发送 HTTP 请求。

这可能吗？

Answer 1

使用 Google Apps 脚本，您可以向 external APIs 发出 HTTP 请求从谷歌文档/表格/等内部。使用 UrlFetchApp class :

var url = 'https://gdata.youtube.com/feeds/api/videos?'
    + 'q=skateboarding+dog'
    + '&start-index=21'
    + '&max-results=10'
    + '&v=2';
var response = UrlFetchApp.fetch(url);
Logger.log(response);

注意:

This service requires the https://www.googleapis.com/auth/script.external_request scope. In most cases Apps Script automatically detects and includes the scopes a script needs, but if you are setting your scopes explicitly you must manually add this scope to use UrlFetchApp.

引用: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app