Root

The root table. This table will always be available. Other tables are automatically detected by the TableDepth connection property.

Table Specific Information

Retrieve all files and directories inside a directory.

SELECT * FROM Root

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)

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 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


Name	Type	ReadOnly	Description
FilePath [KEY]	String	True	The current path in the FTP/SFTP server.
Filename	String	False	The name of the file or directory.
FileSize	Long	True	The size of the file. 0 in case of a directory.
LastModified	Datetime	True	The last modification time of the file.
IsDirectory	Boolean	True	The file name of the attachment.
LocalFile	String	True	The path of a file to upload. This column is used for insert statements only.
Permissions	String	True	Permissions of a directory or a file.
Owner	String	True	User name for the owner of a directory or a file.
OwnerId	String	True	User ID for the owner of a directory or a file.
Group	String	True	Group name assigned to a directory or a file.
GroupId	String	True	Group ID assigned to a directory or a file.