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 [email protected].
For more options, visit https://groups.google.com/d/optout.
