Saving PDF file from database

[Tak.Kwok]

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
------------------------------

[ewilson]

@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
------------------------------

[Tak.Kwok]

Thanks Eric. It worked perfectly. Much appreciate it.

Tak

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