Match original filenames to document IDs

[Nkateko_GlenNgu]

Please assist, I have a process I am building that requires me to match the input file names to the Decipher work items (or Document IDs) on Blue Prism.

So using the Document IDs from getting Next Completed Batch, I wanted to pull the original filenames by querying the Decipher Server DB directly.

I have tried doing it manually first on the DB server but the filename I get is the name Decipher created instead of the original filename.

If this possible? To get the original filename and if so which table has this information?

[zdenek.kabatek · Accepted solution]

Hi,

here is the link https://portal.blueprism.com/products/developer-jumpstart where you can find Decipher Templates and Decipher Instructions. It contains description how to NOT OBFUSCATE filenames and then there is an sql query which extracts filenames together with Document ID and batch id. If you need more help write me PM.

Regards,

Zdenek

[Nkateko_GlenNgu]

Hi Zdenek,

Thank you so much for the direction, it resolved my problem.

I used the Decipher Process Template 2 and it updated the work items with the right metadata, which includes the original input file names.

Now I can get the file name together with the data extracted within the same work item.

Regards,
NK