Google sheets Api append

[RonaldBeltrán]

Hi everyone,

I am trying to append data to a spreadsheet by using Google Sheets Api, but I cannot configure the input "values" . According to documentation that input must be defined as follows:

So, I am writing the information in a nested collection and  use an action that becomes it in json format, but when the action is executed this error is generated:

I am defining the others inputs as you can see:

And this is the text in the data item JSON

 
Thank you in advance

------------------------------
Ronald Beltrán
------------------------------

[ewilson · Accepted solution]

Hi @RonaldBeltrán,

Have you tried using the Google Sheets VBO that ships with Blue Prism and is also available on the DX?

Regarding the API connector, it looks like Google has made the valueInputOption mandatory. I don't believe that was the case when this connector was built. With that said, you can edit the Web API definition associated with the skill to apply it. Below is a screenshot of the change:

Just go to System -> Objects -> Web API Services and look for the Google Sheets API v4 entry. Double-click and scroll down to the sheets.spreadsheets.values.append entry. Next, click on the Request topic and enter the following value at the end of the URL Path entry:

&valueInputOption=USER_ENTERED

That should take care of you.

Cheers,
​

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------