Overview
Configuration is provided for establishing connections with Google Cloud Storage service. The configuration is used in the REST Connection Manager.
Setup
Press icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
In this QS, we will show you step-by-step how to create a connection to a Google Cloud Storage REST API using COZYROC's REST Connection Manager.
Step 3.2. Provide authentication details for your Google account to "Log in".
Step 3.3. Allow the required access rights for the COZYROC app.
Step 5. Connect the newly created REST Source component to suitable Destination component and edit mapping.
Configuration
Base URL address: https://storage.googleapis.com/storage/v1
.
- OAuth
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}
.The authentication has the following user-defined parameters:
- Project:
- Scope:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
- Service Account
-
The authentication uses a session token.
The authentication has the following user-defined parameters:
- ClientEmail: Required. Specify service account email address.
- KeyFile: Required. Select private key file (p12).
- Project: Required. Specify project id or number.
- Scope: Specify a space-delimited list of the permissions.
- ActOnBehalf: Specify email address of user to act on behalf. Optional.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Bool
Data type: DT_BOOL
- Long
Data type: DT_I8
- ULong
Data type: DT_UI8
- Int
Data type: DT_I4
- Object
Field components:
-
Uses template:
ShortText
. - Contains the following components: id, selfLink, name, bucket, generation, metageneration, contentType, timeCreated, updated, customTime, timeDeleted, temporaryHold, eventBasedHold, retentionExpirationTime, storageClass, timeStorageClassUpdated, size, md5Hash, mediaLink, contentEncoding, contentDisposition, contentLanguage, cacheControl, metadata, acl, owner, crc32c, componentCount, customerEncryption, kmsKeyName.
-
Uses template:
- ObjectAccessControl
Template: AccessControl. Field components:
-
Uses template:
ShortText
. - Contains the following components: id, selfLink, bucket, object, generation.
-
Uses template:
- Bucket
Field components:
-
Uses template:
ShortText
. - Contains the following components: id, selfLink, projectNumber, name, timeCreated, updated, defaultEventBasedHold, retentionPolicy, metageneration, acl, defaultObjectAcl, iamConfiguration, encryption, owner, location, locationType, rpo, website, logging, versioning, cors, lifecycle, labels, storageClass, billing.
-
Uses template:
- BucketAccessControl
Template: AccessControl. Field components:
-
Uses template:
ShortText
. - Contains the following components: id, selfLink, bucket.
-
Uses template:
- AccessControl
Field components:
-
Uses template:
ShortText
. - Contains the following components: entity, role, email, entityId, domain, projectTeam.
-
Uses template:
- Notification
Field components:
-
Uses template:
ShortText
. - Contains the following components: id, topic, event_types, custom_attributes, payload_format, object_name_prefix, selfLink.
-
Uses template:
- [Read] action
-
The result is extracted from:{{=response.items}}
.
The result is paginated.The following request parameters will be automatically processed:
-
pageToken:
{{=parameters.iterator}}
-
maxResults:
{{=parameters.batchSize}}
-
_includeUserParameters:
{{=parameters}}
-
pageToken:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
application/json:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses PATCH method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
application/json:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
- kind
Template: ShortText. A read-only field.
- etag
Template: ShortText. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/b/{{=parameters.bucket}}/o
.The action has the following user-defined parameters:
- bucket: Required. Name of the bucket in which to look for objects.
For further information check here.
- [Create] action
-
Endpoint URL address:
https://storage.googleapis.com/upload/storage/v1/b/{{=item.bucket}}/o
.The following request parameters will be automatically processed:
-
uploadType:
multipart
-
content:
{{=item.content}}
For further information check here.
-
uploadType:
- [Update] action
-
Endpoint URL address:
/b/{{=item.bucket}}/o/{{=encodeURIComponent(item.name)}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/b/{{=item.bucket}}/o/{{=encodeURIComponent(item.name)}}
.For further information check here.
The resource includes the fields from the Object template.
- content
Data type: DT_IMAGE The value is gathered from
{{= item.size === 0 ? '' : '/b/' + item.bucket + '/o/' + encodeURIComponent(item.name) }}
address.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/b
.The action has the following user-defined parameters:
- project: Required. A valid API project identifier.
The following request parameters will be automatically processed:
-
project:
{{=parameters.project}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/b
.The following request parameters will be automatically processed:
-
project:
{{=item.project}}
For further information check here.
-
project:
- [Update] action
-
Endpoint URL address:
/b/{{=item.name}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/b/{{=item.name}}
.For further information check here.
The resource includes the fields from the Bucket template.
- project
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/b/{{=parameters.bucket}}/acl
.The action has the following user-defined parameters:
- bucket: Required. Name of a bucket.
For further information check here.
- [Create] action
-
Endpoint URL address:
/b/{{=item.bucket}}/acl
.For further information check here.
- [Update] action
-
Endpoint URL address:
/b/{{=item.bucket}}/acl{{=item.entity}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/b/{{=item.bucket}}/acl{{=item.entity}}
.For further information check here.
The resource includes the fields from the BucketAccessControl template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/b/{{=parameters.bucket}}/o/{{=encodeURIComponent(parameters.object)}}/acl
.The action has the following user-defined parameters:
- bucket: Required. Name of a bucket.
- object: Required. Name of the object.
For further information check here.
- [Create] action
-
Endpoint URL address:
/b/{{=item.bucket}}/o/{{=encodeURIComponent(item.object)}}/acl
.For further information check here.
- [Update] action
-
Endpoint URL address:
/b/{{=item.bucket}}/o/{{=encodeURIComponent(item.object)}}/acl/{{=item.entity}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/b/{{=item.bucket}}/o/{{=encodeURIComponent(item.object)}}/acl/{{=item.entity}}
.For further information check here.
The resource includes the fields from the ObjectAccessControl template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/b/{{=parameters.bucket}}/defaultObjectAcl
.The action has the following user-defined parameters:
- bucket: Required. Name of a bucket.
For further information check here.
- [Create] action
-
Endpoint URL address:
/b/{{=item.bucket}}/defaultObjectAcl
.For further information check here.
- [Update] action
-
Endpoint URL address:
/b/{{=item.bucket}}/defaultObjectAcl/{{=item.entity}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/b/{{=item.bucket}}/defaultObjectAcl/{{=item.entity}}
.For further information check here.
The resource includes the fields from the AccessControl template.
- bucket
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/b/{{=parameters.bucket}}/notificationConfigs
.The action has the following user-defined parameters:
- bucket: Required. Name of a bucket.
For further information check here.
- [Create] action
-
Endpoint URL address:
/b/{{=item.bucket}}/notificationConfigs
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/b/{{=item.bucket}}/notificationConfigs/{{=item.id}}
.For further information check here.
The resource includes the fields from the Notification template.
- bucket
Template: ShortText.
Related scripts
What's New
- New: Introduced connection.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.