topic Re: Google Sheets - JSON Format in Product Forum

Google Sheets - JSON Format

GabrielMendonça — Mon, 15 Mar 2021 10:27:13 GMT

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

Re: Google Sheets - JSON Format

ewilson — Mon, 15 Mar 2021 16:23:02 GMT

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

Re: Google Sheets - JSON Format

ErjolaMema — Mon, 09 Aug 2021 07:26:54 GMT

Hi Gabriel ,can I ask you a question?

Re: Google Sheets - JSON Format

GabrielMendonça — Mon, 09 Aug 2021 07:33:25 GMT

Hello @ErjolaMema!

How can I help you?

Re: Google Sheets - JSON Format

EVIPUTI — Fri, 03 Sep 2021 09:11:35 GMT

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=digestviewer

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)