Google Sheets API v4:batchGet无法正常工作 [英] Google Sheets API v4: batchGet not working

问题描述

无法使Google Sheets API v4使用batchGet返回多个范围值.它给出了以下错误(尽管文档说它需要valueRanges []，所有范围和电子表格ID都是正确的):额外的args块必须是javascript对象文字.(第2行，文件代码")"

Can't get Google Sheets API v4 to return multiple range values using batchGet. It is giving the following error (although the documentation says it needs valueRanges[], all the ranges and spreadsheetId are correct): "Extra args block must be a javascript object literal. (line 2, file "Code")"

您能帮忙解决一下吗?谢谢你.这是代码:

Could you please help sort it out? Thank you. Here is the code:

function readRange(spreadsheetId) {
  var response = Sheets.Spreadsheets.Values.batchGet("someSpreadSheetID", ["Sheet1!D7:F7", "Sheet1!J7:L7"]);
  Logger.log(response.values);
}

推荐答案

此修改后的脚本如何?为了使用此功能，请在API控制台上启用Sheet API v4，并在Advanced Google Services上启用Sheet API v4.

How about this modified script? In order to use this, please enable Sheet API v4 on API console and enable Sheet API v4 at Advanced Google Services.

function readRange(spreadsheetId) {
  var response = Sheets.Spreadsheets.Values.batchGet(
    "someSpreadSheetID",
    {ranges: ["Sheet1!D7:F7", "Sheet1!J7:L7"]}
  );
  Logger.log(response.valueRanges);
}

这篇关于Google Sheets API v4:batchGet无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！