topic SFTP in Product Forum

SFTP

pavanikoduri — Tue, 26 Nov 2019 13:27:00 GMT

Hi,

I would like to get/post a file from sftp server, so is there any object available from blue prism? or any best method.

Thanks Pavani

------------------------------
pavani koduri
RPA Consulatant
Pearson
Europe/London
------------------------------

RE: SFTP

EdGarabedian1 — Wed, 27 Nov 2019 16:13:00 GMT

Hi Pavani, I don't know if this is the best way but this blog post I wrote should give you some ideas to explore, https://rpasuccess.com/blog/2019/8/5/how-to-use-windows-built-in-ftp-with-blue-prism/

In the post I highlight how you can use these built-in VBO's to configure a command line ftp call.

Utility - File Management VBO - this is an excellent workhorse of utilities, providing actions to handle all sorts of local file and directory management.
Utility - Environment VBO - provides utilities actions for interacting with the environment - read screen resolution, determine OS type, etc.

But there are also a couple of Digital Exchange Assets available on the DX store that might be of interest. https://digitalexchange.blueprism.com/dx/search?keyword=FTP
Let us know what you come up with.
Thanks,
Ed

------------------------------
Ed Garabedian
Sr. Solutions Consultant
Blue Prism
------------------------------

RE: SFTP

AndreyKudinov — Thu, 28 Nov 2019 11:46:00 GMT

I'd make a simple VBO with SSH.NET library. MIT licensed.
Upload seems to be about 10 lines of code.
You would have to install something on the worker either way.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: SFTP

sushmaAchar — Tue, 13 Sep 2022 12:02:00 GMT

Hello @Ed Garabedian,

I am facing the same scenario, Need to perform SFTP functions using a .ppk file. I am trying to use this VBO available in dx:

https://digitalexchange.blueprism.com/dx/entry/9648/solution/sshnet-2

However it is giving me Invalid Private Key File error. Not sure if the .ppk is supported.

Thank you,
Sushma

------------------------------
sushma Achar
------------------------------

RE: SFTP

ewilson — Tue, 13 Sep 2022 14:13:00 GMT

Hello @sushma Achar,

I believe the underlying SSH.NET library, used by the VBO, requires key files to be in PEM format. If you search Google you'll find multiple articles that discuss converting an existing PPK format key file into a PEM format key file.

Cheers,

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

RE: SFTP

sushmaAchar — Tue, 13 Sep 2022 17:13:00 GMT

Hi @ewilson,

Yes I converted PPK to PEM format. Now the login is successful. I am trying "Download File" action. But I am getting "Access Denied" to download the file to my local machine. However with the same user and credentials I am able to download and upload file on to my local via WinScp.

Thanks,
Sushma Achar

------------------------------
sushma Achar
------------------------------

RE: SFTP

BhaskarGudiband — Wed, 16 Nov 2022 00:16:00 GMT

Hi @sushma Achar

I am receiving the same error when I download a file using SSH.NET VBO. Were you able to resolve this issue? I can delete and get the list files from SFTP, but I cannot download the file.

Thanks,
Bhaskar

------------------------------
Bhaskar Gudibandi
------------------------------

RE: SFTP

ewilson — Wed, 16 Nov 2022 01:01:00 GMT

@BhaskarGudiband,

I believe the "Access Denied" error is related to Blue Prism not being able to write files to the specified local folder. Have you verified that the digital worker has write permissions on the folder? If you're running into this problem while running the process in Debug mode you would want to verify that your user account has proper permissions on the folder.

Cheers,

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

RE: SFTP

BhaskarGudiband — Wed, 16 Nov 2022 01:10:00 GMT

Hi @ewilson,

I am running this in debug mode and I do have permission to that location. I tried bunch of locations but I am getting the same error message.

Thanks,
Bhaskar

------------------------------
Bhaskar Gudibandi
------------------------------

RE: SFTP

sushmaAchar — Wed, 16 Nov 2022 06:42:00 GMT

Hi @BhaskarGudiband,

Please give the absolute path for the local file path parameter.

Example: remotefilepath - /sftpserver/folder/abc.txt
localfilepath - C:\Users\xyz\Desktop\abc.txt

------------------------------
sushma Achar
------------------------------