Element Details: FTP.Directory

Available in: Logi Info Source code name: FTP.Directory

Connects to an FTP site and retrieves a list of files or directories that match the FtpFileName filter. The list of files is saved as an XML DataLayer and can be accessed by any element that supports the EtlElementID attribute.

Columns Returned:
Name = Name of the file.
Date = File date.
Type = File or Directory.
URI = Full URI to the file.
Extension = 3 digit extension associated with the file.
NameOnly = Name of the file without the extension.
Size = Size of the file in bytes.

Runs a SQL statement that returns a rowset and populates a DataTable. There will be one DataTable row for each row returned by the SQL statement. Inside the DataTable, you reference each field with the @Data token, such as "@Data.fieldname~".


Click attribute Name to drill down for more information.

NamePossible ValuesDescription
Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.
The directory name on the FTP server. If the value is left blank, the system will use the default directory.
The name of the file. Wildcards (* and ?) can be used with FTP.Directory and FTP.Download. For example to list all files in a directory leave this blank or use "*.*". To download only XML files that start with an S, use "S*.xml".
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.


Click element to drill down for more information.

Etl Job
If ETL Error If File Exists If Folder Exists


Click element to drill down for more information.

 Back to top