Hi Marc,
Exactly what type of request (operation) are you making? The error
indicates you are specifying a range that is larger that the sheet (grid)
currently is. If you use the AppendCellsRequest it should expand the size
of the sheet automatically as you append.
- Eric
On Sunday, November 6, 2016 at 3:33:20 PM UTC-5, Adwords Webmarketing wrote:
>
> Hi Google Sheets API Support team,
>
> We are automating our Adwords reporting by using the Adwords API and the
> Google Sheets API to display the extracted data.
>
> We are running into an error message when making a BatchUpdate to a
> dynamically created spreadsheet.
>
> The error message we are getting is:
>
> com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad
> Request
> {
> "code" : 400,
> "errors" : [ {
> "domain" : "global",
> "message" : "Invalid data[0]: Range (Sheet1!10001:20000) exceeds grid
> limits. Max rows: 10000, max columns: 26",
> "reason" : "badRequest"
> } ],
> "message" : "Invalid data[0]: Range (Sheet1!10001:20000) exceeds grid
> limits. Max rows: 10000, max columns: 26",
> "status" : "INVALID_ARGUMENT"
> }
>
> What we are doing is populating the spreadsheet in 10,000 rows of data
> each time. The first report data block goes well (Range: Sheet1!1:10000)
> however, when we get to the 2nd data block, this error is displayed.
>
> If we try to update the data in other quantities (for example 2000 or 5000
> rows per insertion), we get the same error message, however it says "Max
> rows: 2000, max columns: 26" and "Max rows: 5000, max columns: 26"
> respectively. If we try to update 20000 rows at once, another error message
> says that we are trying to update row 10001 when the limit is 10000
> (obiously because the Value Range data now contains more rows than the
> predefined range).
>
> There is no documentation anywhere regarding this error message and it is
> not really clear what it means. The range Sheet1!10001:20000 contains
> clearly less than 10000 rows (20000-10001 = 9999 rows) so there is not a
> clear reason as to why this message is displaying. If the problem is with
> the number of columns, then we'd like to know what exactly the problem
> would be as we have also tried to reduce the number of columns targeted (in
> A1 notation) and we still get the same error message.
>
> Thanks,
>
> Marc.
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-spreadsheets-api+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
