Repository navigation
Google sheet API v4 - batchUpdate provide error : Invalid JSON. Unknown name "data". #588
Description
I got an error by executing the batchUpdate function :
var options = var options = {
auth: auth,
spreadsheetId: spreadSheetId,
valueInputOption: "RAW",
data: [
{
range: "MyRange",
majorDimension: majorDimension,
values: [0,0,0,1,2,3]
}
]
};
spreadsheets.batchUpdate(options, function(err, res) {
console.log(res);
console.log(err);
})
The error is the following :
{ [Error: Invalid JSON payload received. Unknown name "data": Cannot bind query parameter. 'data' is a message type. Parameters can only be bound to primitive types.]
code: 400,
errors:
[ { message: 'Invalid JSON payload received. Unknown name "data": Cannot bind query parameter. \'data\' is a message type. Parameters can only be bound to primitive types.',
domain: 'global',
reason: 'badRequest' } ] }
Im using Google sheet API v4.
'data' should exist in request following the documentation :
https://developers.google.com/sheets/samples/writing#write_to_multiple_ranges
Reacted by Dan Dascalescu
Activity
ehgoodenough commentedon Jun 8, 2016
Yup, I had the same problem. Check what API call you're making; you're calling
spreadsheets.batchUpdateinstead ofspreadsheets.values.batchUpdate.jmdobry commentedon Jun 9, 2016
@marcantoineTrehin Like @ehgoodenough said, you probably mean to be calling
spreadsheets.values.batchUpdate, but in the code you posted you're actually callingspreadsheets.batchUpdate.dannongruver commentedon Aug 27, 2016
Getting the same error. Same code above but using
spreadsheets.values.batchUpdate. Anyone have a working example of theoptionsargument?jmdobry commentedon Aug 30, 2016
The payload of the request (not the parameters) need to be nested under a
resourceproperty:grant commentedon Apr 13, 2018
Here are more examples of how to call
batchUpdate:https://github.com/gsuitedevs/node-samples/blob/master/sheets/snippets/snippets.js#L74
Feel free to file an issue on our Spreadsheets examples if you find problems there.
strarsis commentedon Jul 7, 2019
@jmdobry: Thank you!! I use the nodejs Google API library and using
resourcesfinally made the API call possible!dandv commentedon Jun 12, 2023
I got this error by using UrlFetchApp (i.e. the REST API). Turns out I had forgotten to
JSON.stringify()the payload.