SignURL
Uploads objects in a single operation. Use the SimpleUploadLimit connection property to adjust the threshold in bytes in order to perform a multipart upload.
Note: You will need the following IAM roles to leverage this stored procedure:
- storage.objects.create (allows you to create a signedUrl to upload an object)
- storage.objects.get (allows you to create a signedUrl to download the object)
Input
| Name | Type | Required | Description |
| Bucket | String | True | The bucket name where the object resides. |
| Object | String | True | The name of the object to generate the SignedURL for. |
| RequestMethod | String | False | The method that the signed request will use.
The default value is GET. |
| Location | String | False | Location of the specified bucket.
The default value is auto. |
| ActiveDateTime | String | False | The dateTime when the SignedURL will become active. If not specified the current dateTime will be used. |
| Query | String | False | The query string that must be included when using the SignedURL,if not specified no query string will be used. |
| CustomHeaders | String | False | A comma separated list of name=value of the headers to use with the SignedURL, if not specified not custom headers will be used. |
| ExpiresIn | String | True | The expiration time for the SignedURL it should be in the format: 1d2h3m4s, the maximum value is 7d0h0m0s |
| HmacAccessKey | String | False | The Hmac access key. |
| HmacSecret | String | False | The Hmac secret. |
| Cert | String | False | The certificate in JSON or P12 format used for RSA signature. |
| Authorizer | String | False | The authorizer of the certificate in P12 format or private key generated from the service account for RSA signature. |
| CertPassword | String | False | The password for accessing the certificate that stores the private key when it requires a password for RSA signature. If a password is not required, leave this property blank. |
| Subject | String | False | The user subject for which the application is requesting delegated access to use for RSA signature. |
| PrivateKey | String | False | The private key generated from the service account. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicator if the stored procedure was successful or not. |
| SignedURL | String | Returns a signedUrl which can be used to download the resource. |