- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-21 10:27 AM
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"
}
}
Answered! Go to Answer.
Helpful Answers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-09-21 10:11 AM
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-03-21 04:23 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-08-21 08:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-08-21 08:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-09-21 10:11 AM
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)