Root

The root reference table that is always present in the FTP schema. It serves as the anchor point for connection discovery, allowing other FTP-related tables to be detected automatically through the TableDepth property.

Table Specific Information

Select

Retrieve all files and directories inside a directory.

SELECT * FROM Root

Insert

To upload a file to the server you need to specify LocalFile and a Filename.

INSERT INTO Root (Localfile, Filename) VALUES ('D:\\\\ShareFolder\\\\Notes.txt', 'NewNotes.txt')

To create a new directory on the server you need to specify Filename and set IsDirectory to true.

INSERT INTO Root (Filename, IsDirectory) VALUES ('New Directory', true)

Update

Only the name of a file can be updated and FilePath must be specified in the WHERE clause.

UPDATE Root SET Filename = 'OldNotes.txt' WHERE FilePath = '/Documents/Test/NewNotes.txt'

Delete

Delete a file by providing the FilePath.

DELETE FROM Root WHERE FilePath = '/Documents/Test/OldNotes.txt'

Delete a directory by providing the FilePath and set IsDirectory to true.

DELETE FROM Root WHERE FilePath = '/Documents/Test' AND IsDirectory = true

Columns


Name	Type	ReadOnly	Description
FilePath [KEY]	String	True	Full path of the file or directory on the FTP/SFTP server, showing its exact location within the server's folder structure.
Filename	String	False	The name of the file or directory, excluding the full path, identifying the item within its parent folder.
FileSize	Long	True	Displays the size of the file in bytes, with directories always showing a size of 0.
LastModified	Datetime	True	A timestamp indicating the last time the file or directory was modified on the server.
IsDirectory	Boolean	True	Indicates whether the entry represents a directory (true) or a file (false).
LocalFile	String	True	The local system file path for uploading to the server. Applies only when inserting new files.
Permissions	String	True	The permission settings for a file or directory, typically shown in a format that uses r for read, w for write, and x for execute.
Owner	String	True	The username of the account that owns the file or directory on the server.
Group	String	True	The group name assigned to the file or directory, which can define shared access rights.