Google表格API V4 - 自动填充错误 - 没有ID为0的网格 [英] Google Sheets API V4 - Autofill Error - No grid with id: 0

问题描述

我正在尝试自动填写申请

I am trying to make an AutoFillRequest using a SourceAndDestination object to describe the area to autofill. I've tested autofill requests using a GridRange object and everything works fine, but can't seem to get the SourceAndDestination working. Here is an example where I'm trying to autofill down the first row for 2 more rows.

HTTP POST

https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate

请求正文

Request Body

{
  "requests": [
    {
      "autoFill": {
        "sourceAndDestination": {
          "dimension": "ROWS",
          "fillLength": 2,
          "source": {
            "sheetId": 1150108545,
            "endRowIndex": 1,
            "startRowIndex": 0
          }
        },
        "useAlternateSeries": false
      }
    }
  ]
}

响应的错误代码为400：

The response has an error code 400:

message =无效的请求[0]。 autoFill：没有网格，id：0status =
INVALID_ARGUMENT

message = "Invalid requests[0].autoFill: No grid with id: 0" status = "INVALID_ARGUMENT"

推荐答案

抱歉的是，这是在服务器上的一个错误。它现在已经修复，所以上面应该可以。

Sorry about that, this was a bug on the server. It's now fixed, so the above should work.

这篇关于Google表格API V4 - 自动填充错误 - 没有ID为0的网格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！