Specifies whether to encode file and folder names in the object key when uploading or downloading files.

Data Type

bool

Default Value

true

Remarks

By default, special characters in file and folder names are URL-encoded to comply with Amazon S3 object naming rules. If this option is set to false, names will be used as they are, allowing for custom folder structures. However, this may necessitate additional handling for special characters. To utilize features such as CreateFoldersOnDownload, this property must be set to false. Determines whether the local file path in DownloadObjects Stored Procedure needs encoding.

For example:

EXECUTE DownloadObjects 
Object='SBatch100k_ORDERS_cdata_replicate_temporary_table/20201106023735184_0.csv', 
Bucket='actiantest', 
LocalFolderPath='C:\Users\User\Desktop\amazons3test'

The final destination of the file will be C:/Users/User/Desktop/amazons3test/SBatch100k_ORDERS_cdata_replicate_temporary_table%2F20201106023735184_0.csv if EncodeFilename=true and C:/Users/User/Desktop/amazons3test/SBatch100k_ORDERS_cdata_replicate_temporary_table/20201106023735184_0.csv if EncodeFilename=false. In addition you can use CreateFoldersOnDownload connection property if and only if EncodeFilename=false. If CreateFoldersOnDownload is set to true it will automatically create the folder in which the file is going to be downloaded.