Skip to main content
Question

Get Table is producing strange results

  • December 19, 2022
  • 9 replies
  • 164 views

Forum|alt.badge.img+4

Hello-

 

When I use the Get Table command for a table using the Recorder > Capture option in an application called Success Factors I get results that are not visible.  For example, If I have the below one record (my record) in the search results…

 

I see this one record on the Webpage:

 

However, the table returned to Automation Anywhere has a bunch of data for employees that are not visible on the webpage.  I realize that the webpage is probably suppressing these in the background but how do I only access the results that are visible?  Seems a little odd…..

 

 

Is there some type of property I am missing or can set to only see visible records?

 

 

9 replies

Pradeep Kintali
Most Valuable Pathfinder
Forum|alt.badge.img+6
  • Most Valuable Pathfinder
  • December 19, 2022

@Matt 7768  - Recorder > Capture → Get Table will give all records in the table. 

if you have any input / id to search specific record from table then use DataTable Filter Action.

 

 

 


Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Premier Pathfinder | Tier 7
  • December 20, 2022

Hi @Matt 7768 ,

It seems to be a bit weird issue.

Try after changing the Object capturing technology within the capture action.


Forum|alt.badge.img+22
  • Most Valuable Pathfinder
  • December 20, 2022

Hi @Matt 7768 

I’d recommend recapturing the element again, if this is not helping you as @Padmakumar said you can try different technologies and check which is working.

Checkout below documentation to know more,

 

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/capture-using-specific-technology.html

 


Forum|alt.badge.img+4
  • Author
  • Navigator | Tier 3
  • December 20, 2022

Hey @Pradeep Kintali , @Padmakumar , @ChanduMohammad -

 

Thank you for your insight.  I will work through these different options today and report back my results.  I very much appreciate the insight.  Thank you for taking the time to review my inquiry.


Forum|alt.badge.img+22
  • Most Valuable Pathfinder
  • December 20, 2022

Welcome @Matt 7768 


Forum|alt.badge.img+4
  • Author
  • Navigator | Tier 3
  • December 20, 2022

So I was unable to get the table to behave properly.  However, I found a small results label that I was able to capture and then subsequently Split to identify if there was a result or not.  i.e……

 

Found 1 out of X users

 

 

Thanks so much for the suggestions.  I look forward to participating in this community more in the future, especially once I have a little bit more experience with the software.

 

@Pradeep Kintali - I will definitely use the DataTable Filter option in the future.  Thanks for this useful bit of information.


Forum|alt.badge.img
  • Cadet | Tier 2
  • June 2, 2025

this is 2 yo chain, but just in case, if anyone can help: as a result of my DelayedOrderReport I have a csv file, but only one result, the last record of the original table. it works properly, I checked all the lines, details, attributes, variables etc. and still it gives me back only one record, and this is the last record on the table. 

what should I do with this?

 


Pradeep Kintali
Most Valuable Pathfinder
Forum|alt.badge.img+6
  • Most Valuable Pathfinder
  • June 2, 2025

@MilaTka -  are you using any loop and assigning csv values to variable. if so last record values will be assigned to variables. Can you share the code snippet how you are using csv data / orignal table data.


Forum|alt.badge.img
  • Cadet | Tier 2
  • June 3, 2025

Oh, Oh, Oh, thank you for response ! I was checking myself, this is my first automation, first homework DelayedOrderReport, so I checked once again details and realized I made a mistake with one little detail: i should have chosen “append to existing log file”, once corrected - all good now !

but thank you for your eyes and willingnes to help :-)!!