Google Sheets - JSON Format

[GabrielMendonça]

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"
}
}

​

[ewilson]

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]

Hi Gabriel ,can I ask you a question?

[GabrielMendonça]

Hello @ErjolaMema!

How can I help you?​

[EVIPUTI · Accepted solution]

This is already discussed on this thread : https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&MessageKey=c33fda21-43ec-4a57-81fc-ec01a9034c7c&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=dig...

Also please find more info here :
https://bpdocs.blueprism.com/bp-7-0/en-us/Guides/google-sheets/sheets-vbo.htm#:~:text=The%20Google%20Sheets%20VBO%20enables,in%20those%20cell(s)