topic Re: Use Run Command tool to call outside application to decrypt a PGP file in Alteryx Designer Desktop Discussions

Use Run Command tool to call outside application to decrypt a PGP file

pmarzano — Wed, 07 Aug 2019 20:19:12 GMT

Hello,

Here's what I'm trying to do:

Use a Text Input tool to move an encrypted PGP file from an FTP site to local machine. (I figured this part out)
Use the Run Command tool to call an outside application to decrypt the PGP file and save it to local machine.

The problem I'm having is the Run Command tool will not recognize the PGP file. I'm not asking Alteryx to do anything with the PGP file; I only want it to recognize the file in the Run Command tool so I can point the outside application to it and decrypt it.

Can anyone help me with this?

Thank you!

Re: Use Run Command tool to call outside application to decrypt a PGP file

DiganP — Wed, 07 Aug 2019 22:10:01 GMT

@pmarzano have you tried bringing the file as a .csv with \0 delimiter? Alteryx is not going to be able to read the encrypted file, but you can use the run command tool to create a script. Are you able to share a sample workflow as well?

Re: Use Run Command tool to call outside application to decrypt a PGP file

pmarzano — Thu, 08 Aug 2019 13:57:31 GMT

@DiganP That worked! I'm not sure why it worked, though. Can you explain a little further if you have a moment?

Thank you! This just made my life a lot less stressful.

Re: Use Run Command tool to call outside application to decrypt a PGP file

DiganP — Thu, 08 Aug 2019 18:03:28 GMT

@pmarzano By default, the input tool is going to try to parse the dataset based on a delimiter or the file type. Usually, this is a tab (\t), comma (,) or space (\s). For some files, this is not going to work (PGP file in this instance). So if you just bring in the file (any file) as a .csv with \0 delimiter it will bring the 'raw' format. Hope this helps 🙂

Re: Use Run Command tool to call outside application to decrypt a PGP file

pmarzano — Thu, 08 Aug 2019 18:05:28 GMT

I truly appreciate all of your help. Thanks again!

Re: Use Run Command tool to call outside application to decrypt a PGP file

jmandalia — Thu, 12 Sep 2019 15:43:22 GMT

hi @pmarzano

We have a similar requirement of decrypting a PGP file and import the data in DB.

Any help to achieve this would be highly appreciated.

Thanks

Jatin

Re: Use Run Command tool to call outside application to decrypt a PGP file

Mahadeva — Tue, 08 Mar 2022 06:04:01 GMT

Hi,

I have similar requirement of decrypting a PGP file and reading the data.

Any help or supporting links would be appreciated.