ODBC Driver for SFTP

Build 24.0.9060

Download

Download a file from the remote FTP server.

Input

Name Type Required Description
RemoteFile String False Specify the remote file path to be downloaded. This property takes priority towards the RemotePath.
RemotePath String False Specify the remote folder path. If IncludeSubFolders is set to true, all the files and folders in this folder will be downloaded.
LocalPath String False The local path to store the downloaded files.
LocalFile String False The local name of the downloaded file. Not used when downloading remotely all the contents of a folder.
Overwrite Boolean False Whether to overwrite Local Files.

The default value is true.

TransferMode String False The mode to be used to transfer the file.

The allowed values are DEFAULT, ASCII, BINARY.

The default value is DEFAULT.

IncludeSubFolders Boolean False An indicator to decide if the files inside the subfolders should be downloaded.

The default value is false.

DownloadDepth Integer False Download depth of the folder from the Remote path.This will be used if IncludeSubFolders set to true.

The default value is 0.

ContinueOnError Boolean False An indicator to decide if the operation should continue if there is a problem with any of the files.

The default value is false.

MaxDownloadBytes Long False If greater than 0, it will limit all downloads to at most this number of bytes.

The default value is 0.

StartByte Long False The offset in bytes relative to the beginning of the file from where to start reading

The default value is 0.

Result Set Columns

Name Type Description
FileName String This parameter sets the file name.
Success String This parameter sets whether the operation was successful or not for a specific file.
FileData String The downloaded file BASE64 encoded content. Only returned if LocalPath and FileStream is not set.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060