I believe theres an issue with the current Spreadsheet API parameters where they might be incorrect at the moment. My app can insert or edit a new row in a sheet, but the given A1 range seems be incorrect.
It only takes the first column (A) from the row, but fails to insert the values when more columns need to be adressed.
Example error from API response from the AppSheet app:
ErrorDescription: โUnable to add/edit/delete row in table โKeywords: productsโ. โ Google.Apis.Requests.RequestError\r\nInvalid data[0]: Requested writing within range [โKeywords: productsโ!A14087], but tried writing to column [C] [400]\r\nErrors [\r\n\tMessage[Invalid data[0]: Requested writing within range [โKeywords: productsโ!A14087], but tried writing to column [C]] Location[ - ] Reason[badRequest] Domain[global]\r\n]\r\n: Message[Invalid data[0]: Requested writing within range [โKeywords: productsโ!A14087], but tried writing to column [C]] Location[ - ] Reason[badRequest] Domain[global]โ
For instance when editing 5 columns on a single row, the range Keywords: products'!A14087
should actually be Keywords: products'!A14087:E14087
.
Cheers
Please contact Support for help with this.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |