Excel Add-In for Google Cloud Storage

Build 24.0.9063

UploadObject

Uploads objects in a single operation. Use the SimpleUploadLimit connection property to adjust the threshold in bytes in order to perform a multipart upload.

Execute

The Driver Uses #TEMP tables as fields for aggregate information entered

You must include in your query:

INSERT INTO ObjectInformationAggregate#TEMP (LocalFilePath) VALUES ('C:/amazons3/test/testfile.txt')

If specifying a list of files, you can additionally set the value of ContentType:

INSERT INTO ObjectInformationAggregate#TEMP (LocalFilePath, ContentType) VALUES ('C:/amazons3/test/testfile.txt', 'text/plain')

Then you execute the procedure by specifying the value of ObjectInformationAggregate with the name of #TEMP table used ObjectInformationAggregate#TEMP.

EXEC UploadObject ObjectInformationAggregate = 'ObjectInformationAggregate#TEMP'

Note: When setting the GetSignedUrl input to true, you need to authenticate with a service account which has the storage.objects.get IAM role.

Input

Name Type Required Description
Bucket String True Bucket name where the object will be uploaded.
ObjectName String False The name of the uploaded object. It should be specified only when uploading the content as InputStream.
FolderPath String False The path to the folder that will receive the data of the object.
LocalFilePath String False The path to the file that will be uploaded in the bucket. If this is a path to a folder, then all the files in the folder will be uploaded in the bucket.
ContentType String False Content-Type of the object data.
ObjectInformationAggregate String False An aggregate representing the object information. Can be in the form of XML, JSON or a #TEMP table.
GetSignedUrl Boolean False Whether to return a signedURL. Only available when OAuthJWTCert is set.

デフォルト値はfalseです。

ExpiresIn String False The expiration time for the SignedURL it should be in the format: 1d2h3m4s, the maximum value is 7d0h0m0s

Result Set Columns

Name Type Description
Object String Object name for the object that is uploaded.
Success String Indicator if the stored procedure was successful or not.
SignedURL String Returns a signedUrl which can be used to download the resource.

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