UploadFile
Uploads a file from a local system to a designated destination, such as a cloud-storage service or remote data repository. This procedure supports data publishing, synchronization, and integration workflows.
Procedure-Specific Information
The DestinationPath input accepts paths relative to the URI provided in the connection string.If URI is set to: gs://test-bucket/folder2 and DestinationPath='file1.txt', the file will be uploaded to /folder2/file1.txt.
The procedure is executed as below:
EXEC UploadFile LocalPath='C:/temp/test.txt', DestinationPath='/hello-cdata.txt'
EXEC UploadFile InputData='eGN2eGN2eGN2eHp6IGRzZmFzZGZkZmc=', DestinationPath='CData/hello-cdata.txt'
Input
| Name | Type | Description |
| DestinationPath | String | Specifies the full directory path where the uploaded file is stored. The path is relative to the directory that is defined in the URI connection property. |
| LocalPath | String | Specifies the full path of the local file that is uploaded from the system. |
| InputData | String | Provides the Base64-encoded string representation of the file content. This input is used only when both the LocalPath and InputStream inputs are not set. |
Result Set Columns
| Name | Type | Description |
| Success | Bool | Indicates whether the file upload operation completed successfully. The Success output returns a value of 'true' when the file is uploaded without error and a value of 'false' when a failure occurs, in which case the Details output provides additional information. |
| Details | String | Provides detailed information about any execution failure that occurs during the upload operation. The Details output returns a NULL value when the Success output is true. |