SFTP Smart Services

Overview

Contains multiple Smart Services for interacting with a remote file server via SFTP, FTP, or SCP.  Using these services, an Appian application can be configured to send and receive files, folders, and metadata in a process.  Features support for zlib compression.

Key Features & Functionality

Smart Services included:

  • SFTP:
    • Remove Directory Over SFTP (Basic Credentials)
    • Send File Over SFTP
    • Send File Over SFTP (Basic Credentials)
    • Receive File Over SFTP
    • Receive File Over SFTP (Basic Credentials)
    • Rename File Over SFTP
    • Get Remote Directory Contents Over SFTP
    • Get Remote Directory Contents Over SFTP (Basic Credentials)
    • Create Directory Over SFTP
    • Create Directory Over SFTP (Basic Credentials)
  • SCP:
    • Send File Over SCP
    • Receive File Over SCP
  • FTP:
    • Send File Over FTP
    • Receive File Over FTP
    • Receive Folder Over FTP
  • FTPS
    • Receive Folder Over FTPS
    • Send File Over FTPS (Basic Credentials)

All smart services in the package use Secure Credentials Store.

Anonymous
  • Hi Krishnan

    Thanks for looking into this.

    I have replicated the issue with a file of 6KB

    When duplicating some lines to enlarge the file >10KB, the issue did not occur;

    About the SFTP server, which is not managed by ourselves, I can see the following information;

    • FTP version: SFTP-3
    • Cryptographic protocol: SSH-2
    • SSH Implementation: AWS_SFTP_1.0

    Files I used:

    files.zip

  • Hi ,

    We tested the 'Receive File Over SFTP' with the file (CSV) less than 10 KB size. We can see the exact size of the file(metadata) is updated in the Appian. Also, the file size is updating without any issues while we tested it will the file size greater than 5 MB. Please provide the snapshot of the issue and sample file for testing.
    Please find the attachment while we tried to reproduce the issue.
  • Hi Mike

    We're using the Receive node with the External System Key (credential store), in combination with a private key file.

  • Please make sure that the remote filepath parameter ends in a "/" and that it does not include the filename. There was a fix provided in version 1.8.1 with naming files on remote hosts.

  • Which Receive node are you using? The one that you provide credentials in secure credentials store or directly in the node?

  • Hi Team

    We notice that the SFTP single file download appears to have some issues when downloading small files, we are using v2.0.0

    When downloading files (using 'receive File Over SFTP') it seems that the file size is set to 0 for some reason.
    In Appian, it shows as '<1kb' but the contents are still there (checked by downloading the file and opening outside of appian)

    With some trial & error I found out that this happens for files below ~10kb size. (CSV files in our case)

    In our setup, this impacts the process, because this file needs to be uploaded to a sharepoint, and that Smart Service depends on the filesize metadata, rendering the uploaded file corrupt.

    Please let me know if you need more information reproducing this issue.

  • - have already done that, this version is not supporting and also existing processes are failing.

  • Hi Lokesh,

    While we tried to resolve the issue, we found that the file path would be wrong in your case. You should include the '\' to denote the parent folder or you can include any folder location here. If you still have the issue, please forward the steps to reproduce with inputs.

  • can you please reply , how we can resolve this above issue, i am using send file over SFTP smart service, and after version updation to 2.0.0, it is failing

  • while using the latest version 2.0.0  for this plugin, my existing process is getting failed with the error message ---Error copying the Appian document to the remote server. See the application server log for more details. Error Message: No such file or directory and this working as expected on the 1.7.0 version.
    kindly, lets us know, how to resolve this kind of issue.