"SFTP - Send File" node

You can use the SFTP - Send File node to transfer the files to your server using SFTP protocol.

Node configuration

1. In the Server field, enter the URL of the server.
2. In the Port field, set the port. The default value is the most commonly used SFTP port.
3. If your data are stored in a directory, in the Path to directory provide a path to a directory (for example: /home/file-directory/).
4. In the File name field, enter the name of the file under which it will be passed to your SFTP server.
5. From the File format dropdown list, select the format of the file:
   • JSON
   • JSON Lines
   • CSV - Provide the details on how to format the file for sending:

   1. From the Delimiter dropdown, select the character that splits the column.

   2. From the Quotation mark dropdown list, select the characters that contain the text or data type.

   3. From the Escape character dropdown lists, select the character changes the default interpretation of a character or a string followed by the character.

   4. From the Line ending dropdown list, select:

      • Line feed - This option shifts the cursor to the next line vertically.
      • Carriage return and line feed - This option points the cursor to the beginning of the line horizontally and shifts the cursor to the next line vertically.

   5. Optionally, select the following checkboxes:

      • No Byte Order Mark - This option is currently unused.
      • Quoting style only if required - This option wraps the values with characters selected in the Quotation mark field when the delimiter occurs in the value. For example, for the following values:
        • one
        • two,three,four

      The output with the enabled Quoting style only if required option will be as follows: one,"two,three,four"

6. In the Authentication section, select the authentication method.
   • Anonymous - No authorization is required.
   • Password - Authentication is based on a login and a password.
   • Public key - Authentication is based on a public SSH key which is issued for a selected integration (you can download such key from the pop-up and add it to the server configuration).
7. Confirm by clicking Apply.

Examples of use

In this example, you can launch a workflow which retrieves a Synerise catalog by means of HTTPS protocol and send it further to a SFTP server. If needed, the workflow can perform a transformation of data retrieved from the catalog in order to meet data structure requirements in the SFTP server.

1. Add the Scheduled run node.
2. In the configuration of the node, set it to immediately.
3. Add the HTTPS - Get File node.
4. In the configuration of the node:
   1. Leave the method at default (GET).
   2. In the URL, enter the address of the endpoint (you can get it here
   3. As a file format, from the dropdown list, select CSV file.
   4. Verify the following fields: Delimiter, Quotation mark, Escape character, Charset, Line ending.
   5. Configure settings for the Headers section.
   6. In the Authentication section, select the type of authentication.
   7. Confirm by clicking Apply.
5. Optionally, you can add the Data Transformation node to modify the data retrieved from the catalog to comply with the data structure standards in your SFTP.
6. Add the SFTP - Send File node.
7. In the configuration of the node:
   1. Enter the URL to the server.
   2. Enter the path to the directory.
   3. Enter the name of the file under which you want to send the data to the server.
   4. Select the format of the file.
   5. Select the authentication method.
   6. Confirm by clicking Apply.
8. Add the End node.