Extracting PDF Table Data with Start Process & Use Application Activities

[Thobile_Bengane]

I am trying to read data from a table in a pdf file.

The workflow allows the user to type-in their required invoice number, so the correct pdf file can be selected.

When using the Start Process activity, I am able to open the correct pdf file.

I am unable to use the Table Extraction wizard outside of a Use Application activity.

How do I get the correct pdf file’s url, so I can use it in the Use Application activity? How do I create a dynamic Use Application activity URL?

[Krishna_Raj]

@Thobile_Bengane

Extracting Datatable in a PDF

I have done this by using python in the past. from tabula import read_pdf import pandas as pd import os # Path to your PDF file pdf_path = 'INPUT' # Define your static output folder output_folder = 'OUTPUTFOLDER' # Check if the output folder exists, create it if it doesn't if not os.path.exists(output_folder): os.makedirs(output_folder) # Use read_pdf function with pages="all" to extract tables from all pages tables = read_pdf(pdf_path, pages="all", multiple_tables=True) # Iterate over…

check this thread as reference