<?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 I am going through some… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/SAP-Get-Table-Data/m-p/48696#M4198</link>
    <description>I am going through some headaches to extract data off of a&amp;nbsp;SAP table grid as well. I thought this would be easier...</description>
    <pubDate>Wed, 02 May 2018 00:37:00 GMT</pubDate>
    <dc:creator>JosephGarro</dc:creator>
    <dc:date>2018-05-02T00:37:00Z</dc:date>
    <item>
      <title>SAP - Get Table Data</title>
      <link>https://community.blueprism.com/t5/Product-Forum/SAP-Get-Table-Data/m-p/48695#M4197</link>
      <description>Hello:

I am trying to grab table data out of SAP but I am given the following error:

Internal : Invalid collection data returned from action - are field names duplicated?

My assumption is that BP is unable to differentiate the table headers from one another&amp;nbsp;and are naming each field&amp;nbsp;based on the header data type. (i.e. text)

Have any of you folks found a way to grab the table data without using an incremental loop? I feel like this should be a fairly easy thing to do; if you can spy a table, you should be able to read it! Any advice or tips would be much appreciated.


Thank you kindly,

Christopher Connors

&amp;nbsp;</description>
      <pubDate>Thu, 26 Apr 2018 20:35:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/SAP-Get-Table-Data/m-p/48695#M4197</guid>
      <dc:creator>ChristopherConn</dc:creator>
      <dc:date>2018-04-26T20:35:00Z</dc:date>
    </item>
    <item>
      <title>I am going through some…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/SAP-Get-Table-Data/m-p/48696#M4198</link>
      <description>I am going through some headaches to extract data off of a&amp;nbsp;SAP table grid as well. I thought this would be easier...</description>
      <pubDate>Wed, 02 May 2018 00:37:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/SAP-Get-Table-Data/m-p/48696#M4198</guid>
      <dc:creator>JosephGarro</dc:creator>
      <dc:date>2018-05-02T00:37:00Z</dc:date>
    </item>
    <item>
      <title>Hey Joseph:
This might not…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/SAP-Get-Table-Data/m-p/48697#M4199</link>
      <description>Hey Joseph:
This might not be relevant anymore; however, I have a work around.
You can loop through an SAP tables contents by spying a table element and setting it as dynamic. Look for the items table ID (should be something like [ x, y ]) and use a loop to update the value via a numeric&amp;nbsp;Row Index data item and a [Row Index] + 1 calculation. This will update the data table item dynamically and will let you get text from each item. If your table has multiple pages, you can have BP use a global send key to scroll down the page 1 full iteration. You'll need to reset your loop once it has reached the maximum number of iterations visible in your table as after the {PGDN} is sent, the first element in the columns ID&amp;nbsp;will reset to [0, 0].
Hope this helps!
Christopher</description>
      <pubDate>Fri, 22 Jun 2018 21:36:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/SAP-Get-Table-Data/m-p/48697#M4199</guid>
      <dc:creator>ChristopherConn</dc:creator>
      <dc:date>2018-06-22T21:36:00Z</dc:date>
    </item>
  </channel>
</rss>

