cancel
Showing results for 
Search instead for 
Did you mean: 

Google Sheets API - Spreadsheets.value.update

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

1 BEST ANSWER

Best Answers

ewilson
Staff
Staff
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

View answer in original post

3 REPLIES 3

ewilson
Staff
Staff
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

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

ErjolaMema
Level 5
.ytytteyrh