Root

Represents the root directory on the remote SFTP server. This table is always available, and additional directory tables are discovered dynamically based on the TableDepth connection 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	The full path to the current file or directory on the FTP/SFTP server.
Filename	String	False	The name of the file or directory at the specified path.
FileSize	Long	True	The size of the file in bytes; for directories, this value is always 0.
LastModified	Datetime	True	The timestamp of the most recent modification to the file or directory.
IsDirectory	Boolean	True	Specifies whether the entry represents a directory (true) or a file (false).
LocalFile	String	True	The local file path used when uploading to the FTP/SFTP server; applicable only in insert operations.
Permissions	String	True	The permission string that defines read, write, and execute rights for the file or directory.
Owner	String	True	The username of the account that owns the file or directory.
OwnerId	String	True	The system-assigned identifier for the owner of the file or directory.
Group	String	True	The group name associated with the file or directory.
GroupId	String	True	The system-assigned identifier for the group associated with the file or directory.