Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Extract data from PDF with Password using R Tool (pdftools)

RichardAlt
8 - Asteroid

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)
1 REPLY 1
BrandonB
Alteryx
Alteryx

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 

 

BrandonB_0-1634137151118.png

 

Labels