topic Re: Google Sheets API - Spreadsheets.value.update in Product Forum

Google Sheets API - Spreadsheets.value.update

GabrielMendonça — Wed, 10 Mar 2021 16:18:20 GMT

Hello everyone!

I've started to use the Google API with BP recently, everything was fine, then I got this problem when I've tried to update the sheets I'm working with:

Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 400
HTTP Response Content: {
"error": {
"code": 400,
"message": "'valueInputOption' is required but not specified",
"status": "INVALID_ARGUMENT"
}
}

There is no parameters to uso this "valueInputOption".

Re: Google Sheets API - Spreadsheets.value.update

ewilson — Wed, 10 Mar 2021 18:15:04 GMT

Hi @Gabriel Mendonça,

This is a bug on the skill. You can actually make a change to your copy to address it though. In Blue Prism, go to System -> Objects -> Web API Services. Scroll down to the Google Sheets API v4 service definition and double-click it. This will open the actual definition.

In the list of actions on the left of dialog, scroll down to sheets.spreadsheets.values.update. Now click the Parameters option. Create a new input parameter called valueInputOption and make it type Text. You can also set an initial value if you like. The possible values for this input are either RAW or USER_ENTERED. I would probably set the initial value to USER_ENTERED. You can find out more about the meanings of each value here (if you're interested).

Now that we have the new input parameter, click on the Request entry (under Parameters) in the navigation tree on the left. You're going to edit the value of the URL Path field. Initially it looks something like this:

v4/spreadsheets/[spreadsheetId]/values/[range]?fields=[fields]

You'll want to change it to something like this:

v4/spreadsheets/[spreadsheetId]/values/[range]?fields=[fields]&valueInputOption=[valueInputoption]

When you're done, click OK in the bottom right of the dialog. You'll need to click the refresh button within your process if you left it open while making this change.

Cheers,
Eric

Re: Google Sheets API - Spreadsheets.value.update

GabrielMendonça — Thu, 11 Mar 2021 15:57:48 GMT

Hello! @ewilson! I did everything as you said, and this part is ok! Thank you! You're awesome!

Re: Google Sheets API - Spreadsheets.value.update

ErjolaMema — Thu, 05 Aug 2021 23:06:56 GMT

.ytytteyrh