<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Google sheets API Append in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Google-sheets-API-Append/m-p/100231#M47585</link>
    <description>&lt;A href="https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&amp;amp;MessageKey=c33fda21-43ec-4a57-81fc-ec01a9034c7c&amp;amp;CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&amp;amp;tab=digestviewer#bmc33fda21-43ec-4a57-81fc-ec01a9034c7c" target="_blank" rel="noopener"&gt;https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&amp;amp;MessageKey=c33fda21-43ec-4a57-81fc-ec01a9034c7c&amp;amp;CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&amp;amp;tab=digestviewer#bmc33fda21-43ec-4a57-81fc-ec01a9034c7c&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;Cheers,</description>
    <pubDate>Wed, 20 Jan 2021 12:42:51 GMT</pubDate>
    <dc:creator>ewilson</dc:creator>
    <dc:date>2021-01-20T12:42:51Z</dc:date>
    <item>
      <title>Google sheets API Append</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Google-sheets-API-Append/m-p/100230#M47584</link>
      <description>Hi everyone,&lt;BR /&gt;&lt;BR /&gt;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:&lt;BR /&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="36423.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/36435i6BC24F1147A74E5E/image-size/large?v=v2&amp;amp;px=999" role="button" title="36423.png" alt="36423.png" /&gt;&lt;/span&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;BR /&gt;&lt;BR /&gt;So, I am writing the information in a nested collection and&amp;nbsp; use an action that becomes it in json format, but when the action is executed this error is generated:&lt;BR /&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="36424.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/36432iBF62881418C12F1C/image-size/large?v=v2&amp;amp;px=999" role="button" title="36424.png" alt="36424.png" /&gt;&lt;/span&gt;&lt;BR /&gt;I am defining the others inputs as you can see:&lt;/DIV&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="36425.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/36434i72C38A2772F79C39/image-size/large?v=v2&amp;amp;px=999" role="button" title="36425.png" alt="36425.png" /&gt;&lt;/span&gt;&lt;BR /&gt;And this is the text in the data item JSON&lt;BR /&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="36426.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/36437iD81F8B83BF40E7EE/image-size/large?v=v2&amp;amp;px=999" role="button" title="36426.png" alt="36426.png" /&gt;&lt;/span&gt;&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;BR /&gt;
&lt;DIV class="media" style="overflow: hidden"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="36427.png"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/36436iB84EE88ACBB1AD42/image-size/large?v=v2&amp;amp;px=999" role="button" title="36427.png" alt="36427.png" /&gt;&lt;/span&gt;&lt;/DIV&gt;
&lt;BR /&gt;&amp;nbsp;&lt;BR /&gt;Thank you in advance&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;</description>
      <pubDate>Fri, 15 Jan 2021 23:03:51 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Google-sheets-API-Append/m-p/100230#M47584</guid>
      <dc:creator>RonaldBeltrán</dc:creator>
      <dc:date>2021-01-15T23:03:51Z</dc:date>
    </item>
    <item>
      <title>Re: Google sheets API Append</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Google-sheets-API-Append/m-p/100231#M47585</link>
      <description>&lt;A href="https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&amp;amp;MessageKey=c33fda21-43ec-4a57-81fc-ec01a9034c7c&amp;amp;CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&amp;amp;tab=digestviewer#bmc33fda21-43ec-4a57-81fc-ec01a9034c7c" target="_blank" rel="noopener"&gt;https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&amp;amp;MessageKey=c33fda21-43ec-4a57-81fc-ec01a9034c7c&amp;amp;CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&amp;amp;tab=digestviewer#bmc33fda21-43ec-4a57-81fc-ec01a9034c7c&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;Cheers,</description>
      <pubDate>Wed, 20 Jan 2021 12:42:51 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Google-sheets-API-Append/m-p/100231#M47585</guid>
      <dc:creator>ewilson</dc:creator>
      <dc:date>2021-01-20T12:42:51Z</dc:date>
    </item>
  </channel>
</rss>

