Question
Accenture
NL
Last activity: 23 Aug 2018 19:03 EDT
interrogating table with pagination.
Hi,
How can I get data from table which has multiple pages(table with pagination).
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
US
Generally, that error is benign. You can acknowledge it (it may appear multiple times) and continue.
I don't understand what you mean by this won't work. The idea is that you record the data on the current page, then navigate to the next set of records (presumably on the same page but requiring a re-load of the data) and store them as well, until you have completed extraction of the data from all of the pages.
I would break this apart into two separate automations;
- An automation to control the pagination (i.e. it figures out how to get the next set of records loaded and waits until they are loaded before continuing)
- An automation to extract the data from the page
Pegasystems Inc.
US
Pega Robotics will only match items that are on the page, so once you leave a page, those items are unmatched. If you need to collect data from the table as you iterate through it, then you'd need to store it somewhere (a LookupTable object on the Advanced tab of the Toolbox would work perfect here). Generally, you'd iterate through the rows on your table, storing them wherever you like, and then clicking the next page link or button while waiting for the next page of results. Be careful to use the WaitForEvent for the Destroyed event for the page when navigating as you are essentially navigating back to the current page and a WaitForCreate will return true immediately before the page you are leaving has had a chance to get unmatched.
Accenture
NL
The above solution will only work for static tables with limited number of pages.
But what if I had dynamic table(like number of pages may change depending on what I search for).
And more over while interrogating the table I am an error(ref screenshorts).
Accepted Solution
Pegasystems Inc.
US
Generally, that error is benign. You can acknowledge it (it may appear multiple times) and continue.
I don't understand what you mean by this won't work. The idea is that you record the data on the current page, then navigate to the next set of records (presumably on the same page but requiring a re-load of the data) and store them as well, until you have completed extraction of the data from all of the pages.
I would break this apart into two separate automations;
- An automation to control the pagination (i.e. it figures out how to get the next set of records loaded and waits until they are loaded before continuing)
- An automation to extract the data from the page