SFTP

Question

Hi all, I have a requirement to send a Excel file generated in Appian to an external system via SFTP (Send File) Plug in. Current Implementation: 1. I am using the export data store entity to excel smart service to generate an excel. 2. The generated Excel file is successfully created in Appian Documents and stored in a process variable. 3. In the next node I am using SFTP send file plugin to transfer the file to an external system. 4. The SFTP connection details(hostname, port, authentication details) were provided by the external team. SFTP Plugin Configuration: 
 I have added this in a expression rule for file transfer configuration input. 
 type!FT_config( 
 serverHostName: "typ-test-abc.com", 
 serverport:0000, 
 timeout:20000, 
 usePerUserCredentials:false(), 
 scsExternalSystemKey:null() 
 ) 
 Document to send: process variable containing the excel document generated by the export data store entity to Excel smart service. 
 Remote File Path : Currently left Blank 
 Issue: 
 The process model completes successfully without any errors. The excel file is generated correctly in appian, and the SFTP node also completes successfully. However the external system team confirms that they are not receiving the file on their end . 
 Questions: 
 1. Is the Remote File Path mandatory in the SFTP send file plugin? If yes , what value should be provided? 
 2. How can I verify whether the file was actually transferred to the SFTP server? 
 3. Are there any plugin logs , reports or appian server logs that can hep validate the file transfer ? 
 4. Has anyone faced a similar issue where the process completes successfully but the file is not available on the destination server? 
 Any guidance would be appreciated. 
 
 Thanks, Kavya

Mike Schmitt · Answer

The Remote File Path value is required and should contain not only the Remote Path but also the Filename . 
 
 The remote path should end in "/" (forward slash) - if uploading to the root directory for your sFTP login, then provide a remote path of simply "/", and (as far as i know) if uploading to a remote subdirectory, the directory path should also end in "/". 
 Following the path, in the same string, you will need to include the full filename , including extension. 
 Therefore if you're trying to upload "export.xlsx" to the root directory of your sFTP login, you will need to make the whole string, "/export.xlsx".

Mike Schmitt · Answer

tubatik441187 said: 2. How can I verify whether the file was actually transferred to the SFTP server? 
 In my sFTP process framework, I configured a special subprocess that gets the remote directory contents right after an upload. This just requires the remote folder path to be passed, and returns a list of file and subdirectory contents of the remote path. This allows pretty easily to validate whether the file you just sent was uploaded successfully.