FTP

Overview

The FTP connector can be used to load CSV or JSON files from FTP and SFTP locations.

This connector is commonly used when files are exported from another system and placed in a shared folder for xpna to import.

Connection Requirements

The following details are required:

• Hostname
• Connection type, such as FTP or SFTP
• Port
• Username
• Password

Note:

Credentials are stored encrypted in xpna.

A dedicated read-only account should be used where possible.

Source Items

Each file pattern or uploaded file can be configured as a source item.

CSV and JSON files can be sampled so that columns can be reviewed, typed, and mapped before the configuration is saved.

Refreshing Data

Data can be refreshed manually from the Connections page or by using the configured schedule.

If files are replaced on the FTP server, the next refresh will load the currently available file content.