Digital Exchange Community

DX_Community_Banner.png
Expand all | Collapse all

SFTP

  • 1.  SFTP

    Posted 11 days ago
    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
    ------------------------------


  • 2.  RE: SFTP

    Posted 11 days ago
    Hi

    You could launch command prompt from Blueprism process. Install WinSCP on the robot VDI and pass a script to perform operations from your SFTP location.

    The following link has more details about how to script SFTP operations. https://winscp.net/eng/docs/scripting

    ------------------------------
    GANESHRAJ JEEVARAJ
    Automation Developer
    Aviva
    Europe/London
    ------------------------------



  • 3.  RE: SFTP

    Posted 10 days ago
    Thanks, Ganeshraj..i am using the python script which is easier than this process, so I am asking the BP whether they have any integration or not? Thanks

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



  • 4.  RE: SFTP

    Posted 5 days ago
    Hi Pavani,

    I'm not aware of an existing SFTP integration. At least there aren't any on the DX. I have kicked around the idea of building one on top of WinSCP. Just haven't had the time.

    ------------------------------
    Eric Wilson
    Director, Partner Integrations for Digital Exchange
    Blue Prism
    ------------------------------



  • 5.  RE: SFTP

    Posted 5 days ago
    Edited by Ami Barrett 5 days ago
      |   view attached
    Way ahead of you on that. I'm attaching a file - rename the extension from .txt to .bprelease.

    This is built off of WinSCP and Renci SSHNet. The VBO expects the following files to reside within c:\bp (A general-use directory we have on our bots, you can change this as-needed):
    -Renci.SshNet.dll
    -Renci.SshNet.xml
    -WinSCP.exe
    -WinSCPnet.dll

    Edit:
    Looking back on this, I'm recalling that this was abandoned mid-development. Everything should work fine, save for the rsa 2048 stages. Those have most of the groundwork done, and just need the host key to be integrated.

    Edit2:
    It looks like to get the host key to work, you'll need to add the following to the sessionOptions section of the code stages
    .SshHostKeyFingerprint = "ssh-rsa "+hostKey

    ------------------------------
    Ami Barrett
    Lead RPA Software Developer
    Solai & Cameron
    Richardson, TX
    ------------------------------

    Attachment(s)

    txt
    FTP_12_2_2019.txt   52K 1 version