Hi All,
How to extract data from PDF file with password. I've installed PDFInput Tool on my designer I have no problem when the PDF file is not password protected.
This is the default R Code in PDF Input.
# read in the PDF file location which must
# be in a field called FullPath
File <- read.Alteryx("#1", mode="data.frame")
# Use pdf_text() function to return a character vector
# containing the text for each page of the PDF
Data <- pdftools::pdf_text(file.path(File$FullPath))
# convert the character vector to a data frame
df_Data <- data.frame(Data)
# output the data frame in steam 1
write.Alteryx(df_Data, 1)
That tool from the gallery uses the pdftools R package. If you look at their documentation you will see that you can pass owner/user passwords in the command: https://cran.r-project.org/web/packages/pdftools/pdftools.pdf