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
