This action logs in to the FTP server and retrieves a list of files and directories, storing information about each (but not the file contents itself) in individual records in a local table.

Source

In the Source box, provide the location and user credentials needed to login. These can be entered explicitly, or the values taken from a table field or query.

If you are using SFTP, you can choose to validate the server against a previously stored fingerprint. To do this check the checkbox and select the source of the fingerprint

To import a directory you need to specify which directory on the server to import. Leave blank for the root directory. (Note, once the root directory is imported, this may identify further directories. You can then iterate through these using further calls of the "FTP - Import Directory" action to retrieve their contents.)

Destination

In the Destination box, select the Table where a set of record will be created, one for each item in the Directory.

With the Table selected, select the various fields within it to receive the information about each entry.

Select what action the system should take when the Table already contains a matching entry.

Optionally, select Events in the Table receiving the entries to be executed when an entry has been added, updated, or removed.

Diagnostics

In the Diagnostics box, optionally select from the local table a Checkbox field for "Completed OK" and a Text field for "Feedback". The action will save values to these fields to indicate its success or failure, and the reason why.