Overview
Configuration is provided for establishing connections with the Google Forms 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.
Demonstration
Quick Start
In this task, we will show you step-by-step how to create a connection to Google Form REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account".
Select "Data Flow task" tab and Click "Add new Data flow task"
Step 2. Right click on Connection managers Tab and Select New Connection
Step 3. In "Add SSIS Connection Manager" scroll down and select REST "Connection managers for REST Connection" and click "Add"
Step 4. From Configuration drop-down menu select "Google Form connection" and click New
Step 5. Click Next
Step 6. Provide your Email and click on Next
Step 7. Provide your Password and click on Next
Step 8. In the next wizard click on continue button
Step 9. Create and Save your password protected Google Form token file. Click OK
Step 9. Click Test to test your connection and click OK
In this guide, we will show how to read data from the Google Form service resource using the COZYROC REST Source component.
Step 1. Open the right side panel and Drag and Drop REST Source component
Step 2. Double click on it and select "Google Form Connection". Select from available Google Form resources listed in second drop-down menu.
Specify the parameters in the gird below if required. Optionally you can specify additional parameters accepted by the Google Form Rest service.
Step 3. Click on Columns tab and Select from Google From available columns.
Step 4. Click Preview to view the columns data. Click OK
Bravo! You have now learned how to read data from Google Form service.
In this guide, we will show how to write data to the Google Form service resource using the COZYROC REST Destination component.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.
Step 3. Double click on the "REST Destination" component and select Google Form connection from the combo. Also, select resource action and Google Form resource you want to work on.
Step 4. Click on the "Mapping" tab and map the input columns for the process you are configuring.
If you want to provide input for other resource composite objects, change the input above and map the columns.
Done. You have now learned how to write data into the Google Form resource.
Configuration
Base URL address: https://forms.googleapis.com.
- 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:
- Scope:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
Documentation: https://developers.google.com/workspace/guides/configure-oauth-consent.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/v1/forms/{{=Forms.getFileId(parameters.formPath)}}.
The result is extracted from:{{=[response]}}.The action has the following user-defined parameters:
- formPath: Required. Please select the form.
Documentation: https://developers.google.com/forms/api/reference/rest/v1/forms/get.
- [Create] action
-
Endpoint URL address:
/v1/forms.Documentation: https://developers.google.com/forms/api/reference/rest/v1/forms/create.
- [Update] action
-
Endpoint URL address:
/v1/forms/{{=item.formId}}:batchUpdate.
The action uses POST method.Documentation: https://developers.google.com/forms/api/reference/rest/v1/forms/batchUpdate.
- formId
Template: ShortText.
- info
Template: infoT.
- settings
Field components:
- Contains the following components: quizSettings.
- items
Field components:
- An array.
-
Uses template:
itemT.
- revisionId
Template: ShortText.
- responderUri
Template: ShortText.
- linkedSheetId
Template: ShortText.
- includeFormInResponse
Data type: DT_BOOL
- requests
Field components:
- An array.
- Contains the following components: updateFormInfo, updateSettings, createItem, moveItem, deleteItem, updateItem.
- writeControl
Field components:
-
Uses template:
ShortText. - Contains the following components: requiredRevisionId, targetRevisionId.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/v1/forms/{{=Forms.getFileId(parameters.formPath)}}/responses.
The result is extracted from:{{=Forms.getResponseData(resource.getFields(parameters), response.responses)}}.
The result is paginated.The action has the following user-defined parameters:
- formPath: Required. Please select the form.
The following request parameters will be automatically processed:
-
pageToken:
{{=parameters.iterator}} -
pageSize:
{{=parameters.batchSize}}
Documentation: https://developers.google.com/forms/api/reference/rest/v1/forms.responses/list.
- [Read single] action
-
Endpoint URL address:
/v1/forms/{{=Forms.getFileId(parameters.formPath)}}/responses/{{=parameters.responseId}}.
The result is extracted from:{{=[response]}}.The action has the following user-defined parameters:
- formPath: Required. Please select the form.
- responseId: Required. Please specify the response identifier.
Documentation: https://developers.google.com/forms/api/reference/rest/v1/forms.responses/get.
- formId
Template: ShortText.
- responseId
Template: ShortText.
- createTime
Template: ShortText.
- lastSubmittedTime
Template: ShortText.
- respondentEmail
Template: ShortText.
- totalScore
Data type: DT_R8
- [External]
-
The external fields URL address:
/v1/forms/{{=Forms.getFileId(parameters.formPath)}}. The external fields list is extracted from:{{=Forms.getResponseFields(response)}}.- {{=external.name}}
Template: {{=external.template}}.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/v1/forms/{{=Forms.getFileId(parameters.formPath)}}/watches.
The result is extracted from:{{=response.watches}}.The action has the following user-defined parameters:
- formPath: Required. Please select the form.
- [Create] action
-
Endpoint URL address:
/v1/forms/{{=item.formId}}/watches.The following request parameters will be automatically processed:
-
application/json:
{{={ watch: item, watchId: item.watchId } }}
Documentation: https://developers.google.com/forms/api/reference/rest/v1/forms.watches/create.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/v1/forms/{{=item.formId}}/watches/{{=item.id}}.Documentation: https://developers.google.com/forms/api/reference/rest/v1/forms.watches/delete.
- id
A key field. Template: ShortText.
- target
Template: TargetT.
- eventType
Template: ShortText.
- createTime
Template: DateTime.
- expireTime
Template: DateTime.
- errorType
Template: ShortText.
- state
Template: ShortText.
- watchId
Template: ShortText.
- formId
Template: ShortText.
- action
Template: ShortText. Field components:
- Contains the following components: renew.
- [Read] action
-
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
_includeUserParameters:
- [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 PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Date
Data type: DT_DBDATE
- infoT
Field components:
-
Uses template:
ShortText. - Contains the following components: title, documentTitle, description.
-
Uses template:
- TargetT
Field components:
- Contains the following components: topic.
- imageT
Field components:
-
Uses template:
ShortText. - Contains the following components: contentUri, altText, properties, sourceUri.
-
Uses template:
- IndexT
Field components:
- Contains the following components: index.
- ItemGeneralT
Field components:
-
Uses template:
ShortText. - Contains the following components: text, material.
-
Uses template:
- itemT
Field components:
-
Uses template:
ShortText. - Contains the following components: itemId, title, description, questionItem, questionGroupItem, pageBreakItem, textItem, imageItem, videoItem.
-
Uses template:
- fileAnswersT
Field components:
- An array.
- Contains the following components: fileId, fileName, mimeType.
Knowledge Base
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.