topic RE: Saving PDF file from database in Product Forum

Saving PDF file from database

Tak.Kwok — Thu, 18 Nov 2021 15:43:00 GMT

Hi:

Instead of going to the internal website to download the PDF needed, I wanted to extracted the actual file from the database directly. The actual PDF file, when running the SQL in Blue Prism to pull it store the result (data item) with the data type of Binary. Does anyone know how I can now take that (the PDF file) and save it to my local machine?

Appreciate any guidance.

Thanks,

Tak

------------------------------
Tak Kwok
Sr. Data Associate
SP Global
America/New_York
------------------------------

RE: Saving PDF file from database

ewilson — Thu, 18 Nov 2021 17:53:00 GMT

@Tak Kwok,

Take a look at the Utility - File Management VBO. It has an actions called Write Binary Data andWrite Text File. You can use these to write data out to a file. In the case of a PDF you'll probably want to use Write Binary Data assuming you have the contents of the file in a Binary data item.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Saving PDF file from database

Tak.Kwok — Thu, 18 Nov 2021 18:54:00 GMT

Thanks Eric. It worked perfectly. Much appreciate it.

Tak

------------------------------
Tak Kwok
Sr. Data Associate
SP Global
America/New_York
------------------------------