FTP(S) Reader
[ | version 3.0]
Building a comprehensive content for you: A Work in Progress...
Connector
The connector is permitted for use of the platform background agent.
Connector processing type: Row by row!
Configuration
FTP connection configuration
Host
adresa serveru ftp
Port number
port (default: 21)
Username
uzivatelske jmeno
Password
heslo
Encryption mode
mod pripojeni k serveru
Explicit (FTPS) Implicit (FTPS) None (FTP)
FTP reader configuration
Working Mode
| Mode | Description |
|---|---|
Read single file |
Reads always the same file specified in Path. |
Read all files |
Reads always all files (which fit the Mask filter) from the directory specified in Path. |
Read only new files |
Not recommended! Reads only new files from the directory specified in Path. |
Read only modified files |
Reads only newly modified files from the directory specified in Path. |
Warning: Try to avoid using
Reads only new filesmode. This mode keeps a list of read files and transfers it to the agent and back each time a step is run. The higher the number of files processed, the higher the traffic and CPU usage. The preferred way for reading only new files isRead only modified filesmode, which stores only the name and modification date of the last file read.
Path
Based on selected Working mode:
| Working mode | Description |
|---|---|
Read single file |
Path to a file, e.g. C:\Directory\MyTextFile.txt. |
| Other | Directory from which the files will be read, e.g. C:\Directory. |
Path can also be taken directly from the input data by using a ${input.<input_column>} placeholder, e.g. ${input.Path}.
File mask
The search string to match against file names. This parameter can contain a combination of valid literal path and wildcard (* and ?) characters, but it doesn''t support regular expressions (e.g. *.txt for text files, *.log for log files, *.csv for files with comma separated values etc.).
Mask can also be taken directly from the input data by using a ${input.<input_column>} placeholder, e.g. ${input.Mask}.
Number of files to process
The maximum number of files loaded in a single task run.
| Batch size | Description |
|---|---|
0 |
Unlimited, all new files will be loaded. |
Greather than 0 |
Only specified number of files will be loaded at maximum. |
Input & Output Schema
Input
Data schema is optional
The connector does not expect a specific schema. The required data structure can be achieved by correct configuration. Although the selected connector doesn't require a schema generally, the individual integration task step may need to match the output data structure of the preceding task step and use a data schema selected from the repository or create a new input schema.
Output
FTP File (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Name | string | No | nazev souboru |
| Directory | string | No | adresar |
| FullPath | string | No | cela cesta souboru vcetne adresare |
| Extension | string | No | pripona |
| Data | Base64 | No | obsah souboru |
| Size | integer | Yes | velikost souboru |
| Created | DateTime | Yes | datum vytvoreni |
| Modified | DateTime | Yes | datum posledni modifikace |
Release notes
3.0.3
- Fixed shared nuget package versions.