Identify Corrupt PDFs

[HunterH]

Hi Everyone. I am trying to figure out a way to feed Alteryx a file path full of PDFs and for it to return back a list of which PDF's are corrupt. I don't have intelligence suite. I've seen some possible solutions using the Python tool, but none of them have been for PDFs and I am not proficient enough in Python to adapt those solutions to PDFs. Has anyone been able to accomplish something like this? 

[Qiu]

@gawa 

Maybe you can help? 😂

[caltang]

Perhaps you can ride on this code: https://stackoverflow.com/questions/58807673/best-way-to-check-the-pdf-file-is-corrupt-using-python 

[gawa · Accepted solution]

hi @HunterH 

Here is the WF to detect the corrupt PDF by using Python tool. This WF utilizes PyPDF2 Python library, so please execute this WF as "ADMIN" first to install the library to your computer.(From 2nd time, you don't need to run as ADMIN any longer)

 @Qiu  Thank you for addressing me.

[Qiu]

@gawa 
You are awesome as usual 🤣

[HunterH]

Thank you! This works great. Of my test files, one of them has redacted info and it flags that one as corrupt. Is that because of the redactions? It seems to run as expected on any of the other files I throw at it. Thanks again.