Downloading PDFs from a table

Frameworks
1

Hi everyone,

I’m attempting to extract and download pdfs from a table: Here is the table with 11 pages.

chrome_In2mrDpj4q (2)
chrome_In2mrDpj4q (2)1335×715 42 KB

I’d like to specifically extract the rows with the Type: WI3, then click the icon next to the trash icon.

chrome_In2mrDpj4q (3)
chrome_In2mrDpj4q (3)1053×106 5.3 KB

When I click the icon - it takes me to this window

chrome_0qOQN6r0oB
chrome_0qOQN6r0oB1244×460 18.8 KB

Which I then click download pdf - the window opens with the pdf, I’d then like to download it then search for the next Type: WI3 in the table until the 11 pages are done.

What would be the best way to approach this?

2

Hi @Mpumi_Setshedi

In that case, I suggest you use a DOM to access these page elements. Using BotCity this approach is possible, see the documentation https://documentation.dev/frameworks/web/dom/

I reproduced the walkthrough you mentioned locally, using the same website that appears in the print screen above.

And I solved it this way:

# self.find_element("page-item", By.CLASS_NAME) == next page button
while self.find_element("page-item", By.CLASS_NAME) != None:
    # Find the table element on the page
    table = self.find_element("table", By.CLASS_NAME)
    # Finds all elements with tag "tr" inside table element
    lines = table.find_elements_by_tag_name('tr')[1:]
    # tr refers to each row in the table
    # Starts at 2 because the first row is the header
    tr = 2
    for line in lines:
        # Finds the element that contains the type of the table
        type = self.find_element(f"/html/body/div/div[2]/div/table/tbody/tr{[tr]}/td[4]", By.XPATH)
        # Finds the element that contains WIID of the table
        WIID = self.find_element(f"/html/body/div/div[2]/div/table/tbody/tr{[tr]}/td[2]", By.XPATH)
        tr = tr + 1
        if (type.text) == "WI3":    
            # Go to the download link
            self.navigate_to(f"https://acme-test.uipath.com/work-items/{WIID.text}")
            # Click on donwload
            self.find_element("/html/body/div/div[2]/div/div[2]/div/div/div[1]/p/a/button", By.XPATH).click()
            # backs to table page
            self.back()
    # Click next page button
    self.find_element("page-item", By.CLASS_NAME).click()

Where:

self.find_element(“page-item”, By.CLASS_NAME) is the html element referring to the button to move to the next page, as shown in the image below, that is, while this button exists on the screen, the loop will continue to occur.

next

tr = 2, because each tr is a row of the table. It starts at 2 because the first line is the header.

type = self.find_element(f"/html/body/div/div[2]/div/table/tbody/tr{[tr]}/td[4]", By.XPATH) is the element that contains the Type of the table.

WIID = self.find_element(f"/html/body/div/div[2]/div/table/tbody/tr{[tr]}/td[2]", By.XPATH) is the element that has the WIID from the table.

Finally, I just check if the element type is the element I want to download the file, if it is, I navigate to the download page passing the WIID in the url, and click download.

I use self.back() to go back to the page with the table and when the loop is finished I click on the next page to continue this process until the last active page.

3

Hi @livia-macon

Than you for the response. I haven’t had access to a computer since I posted this, I do now. I will explore the information you have shared and revert any feedback.