We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
bbak91
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
Top Solution Authors