Issue with Table Extraction from SAP CRM: Seeking Advice

[anil.mohapatra8888]

Hi Everyone,

I hope you’re all doing well.

I’m encountering a challenge with one of my bots that uses the "Get Table" function to extract data from a table (Name: Spendtype) in the SAP CRM browser application. The table originally contained 12 rows of data, and the bot was successfully extracting all rows for the past year. However, recently, the bot has started extracting only 5 rows, while the remaining rows, which are located below the scroll, are not being extracted.

I have verified that there have been no recent updates or patches to the browser or the SAP CRM application. Given this situation, I’m curious if anyone has faced a similar issue and might have insights on potential causes or solutions for this behavior.

Any suggestions or advice on how to resolve this would be greatly appreciated.

[faheemsd]

@anil.mohapatra8888 

Did you get a chance to debug the issue and finding the root cause?

I would suggest you to go with Xpath expression for reading the Entire table without any issues.

You can inspect the element in the web application and Hover the mouse on the application to select the entire table and do right click and copy element.

Copy element contain the HTML body of the table . From this you need to figure out the exact expression for Xpath.

For example \\table[@Summary='Employee Details']

Spy the table in the Browser Mode and copy the xpath into the Xpath attributes.

Add the Web element type attribute as TABLE.

And highlight the element then you're table gets highlighted.