cancel
Showing results for 
Search instead for 
Did you mean: 

Google Sheets - JSON Format

Hello everyone! I'm facing a problem, getting this message when I try to update my sheets, would anyone have any example of how the info need to be put for it to be correct with the JSON model needed, please ?

Error Message:

Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 400
HTTP Response Content: {
"error": {
"code": 400,
"message": "Invalid JSON payload received. Unexpected token.\n \"ROWS\",\r\n\"values\": Test,\r\n\"range\": \"A1\"\n ^",
"status": "INVALID_ARGUMENT"
}
}

35028.png
1 BEST ANSWER
4 REPLIES 4

ewilson
Staff
Staff
Hi @Gabriel Mendonça,

Google has a certain expectation for how to data will be presented as values. As an example, if I wanted to submit an update for the range "A1:B1" with a major dimension of "ROWS", my input values could be "[[3,15]]"​. So this would place the numer 3 in cell A1 and the number 15 in cell B1.

In your case, your input should be "[[Test]]". The first pair of brackets are the JSON array brackets for the overall "values" input. The next set of brackets are for the specific values of the row.

Does that make sense?

Cheers,
Eric

ErjolaMema
Level 5
Hi Gabriel ,can I ask you a question?

Hello @ErjolaMema!

How can I help you?​