Hi Eric, Thanks for the reply. Because we need to generate reports with lots of data, multiple spreadsheets need to be created. However we are seeing this error on the same initial spreadsheet that is automatically created. I can share the code with you in a private message if it would help that you take a look into it.
Regards, Marc. On Monday, November 21, 2016 at 3:11:24 PM UTC-5, Eric Koleda wrote: > > I tried to replicate the problem, but I'm not able to. Are you seeing the > same problem on a new spreadsheet? > > - Eric > > On Fri, Nov 18, 2016 at 5:42 PM, Adwords Webmarketing < > [email protected] <javascript:>> wrote: > >> Hi Eric, >> >> Any updates to this? How can we correct this error using "BatchUpdate"? >> >> Thanks, >> >> Marc. >> >> On Wednesday, November 9, 2016 at 2:23:11 PM UTC-5, Eric Koleda wrote: >> >>> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
