NEW: Check our new hosted service COZYROC Cloud ...
Typeform Connection
Overview
Configuration is provided for establishing connections with Typeform 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 guide, we will show how to read data from the Typeform service resource using the COZYROC REST Source component.
In this guide, we will show how to write data to the Typeform service resource using the COZYROC REST Destination component.
Configuration
Base URL address: https://api.typeform.com
.
- OAuth 2
-
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: https://developer.typeform.com/get-started/scopes/
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
- Date
Data type: DT_DBDATE
- TypeValue
Field components:
-
Uses template:
ShortText
. - Contains the following components: type, value.
-
Uses template:
- formAttachmentT
Field components:
-
Uses template:
ShortText
. - Contains the following components: type, href, scale, properties.
-
Uses template:
- formLayoutT
Field components:
-
Uses template:
ShortText
. - Contains the following components: type, placement, attachment.
-
Uses template:
- WebhookT
Field components:
-
Uses template:
ShortText
. - Contains the following components: id, form_id, tag, url, enabled, verify_ssl, created_at, updated_at.
-
Uses template:
- [Read] action
-
The result is extracted from:{{=response.items}}
.
The result is paginated.The following request parameters will be automatically processed:
-
page:
{{=parameters.iterator}}
-
page_size:
{{=parameters.batchSize}}
-
_includeUserParameters:
{{=parameters}}
-
page:
- [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.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/images
.For further information check here.
- [Read single] action
-
Endpoint URL address:
/images/{{=parameters.id}}
.
The result is extracted from:{{=[response]}}
.The action has the following user-defined parameters:
- id: Required. Specify the image_id.
For further information check here.
- [Read Image By Size] action
-
Endpoint URL address:
/images/{{=parameters.id}}/{{=parameters.size}}
.
The result is extracted from:{{=[response]}}
.The action has the following user-defined parameters:
- id: Required. Specify the image_id.
- size: Required. Specify the size.
For further information check here.
- [Read Background By Size] action
-
Endpoint URL address:
/images/{{=parameters.id}}/background/{{=parameters.size}}
.
The result is extracted from:{{=[response]}}
.The action has the following user-defined parameters:
- id: Required. Specify the image_id.
- size: Required. Specify the size.
For further information check here.
- [Read Choice Image By Size] action
-
Endpoint URL address:
/images/{{=parameters.id}}/choice/{{=parameters.size}}
.
The result is extracted from:{{=[response]}}
.The action has the following user-defined parameters:
- id: Required. Specify the image_id.
- size: Required. Specify the size.
For further information check here.
- [Create] action
-
Endpoint URL address:
/images
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/images/{{=item.id}}
.For further information check here.
- id
A key field. Template: ShortText.
- src
Template: ShortText.
- file_name
Template: ShortText.
- width
Data type: DT_I4
- height
Data type: DT_I4
- media_type
Template: ShortText.
- has_alpha
Data type: DT_BOOL
- avg_color
Template: ShortText.
- url
Template: ShortText.
- image
Data type: DT_IMAGE The value is gathered from
/images/{{=item.id}}
address. Before setting, the value is processed with{{=getClrType('System.Convert').ToBase64String(value.readAll())}}
expression.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/forms
.For further information check here.
- [Read single] action
-
Endpoint URL address:
/forms/{{=parameters.form_id}}
.
The result is extracted from:{{= [response] }}
.The action has the following user-defined parameters:
- form_id: Required. Specify the form_id.
For further information check here.
- [Create] action
-
Endpoint URL address:
/forms
.For further information check here.
- [Update] action
-
Endpoint URL address:
/forms/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/forms/{{=item.id}}
.For further information check here.
- id
A key field. Template: ShortText.
- title
Template: ShortText.
- type
Template: ShortText.
- last_updated_at
Template: DateTime. A read-only field.
- self
Field components:
-
Uses template:
ShortText
. - Contains the following components: href.
-
Uses template:
- _links
Field components:
-
Uses template:
ShortText
. - Contains the following components: display.
-
Uses template:
- theme
Field components:
-
Uses template:
ShortText
. - Contains the following components: href.
-
Uses template:
- webhook
The gathered value is processed with
{{=connection.resourceManager['Webhook'].getData({ parameters: ['id=' + item.id] })}}
expression. Field components:- An array.
-
Uses template:
WebhookT
.
- insights
The value is gathered from
/insights/{{=item.id}}/summary
address. Field components:- Contains the following components: form, fields.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/themes
.For further information check here.
- [Read single] action
-
Endpoint URL address:
/themes/{{=parameters.id}}
.
The result is extracted from:{{=[response]}}
.The action has the following user-defined parameters:
- id: Required. Specify the theme_id.
For further information check here.
- [Create] action
-
Endpoint URL address:
/themes
.For further information check here.
- [Update] action
-
Endpoint URL address:
/themes/{{=item.id}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/themes/{{=item.id}}
.For further information check here.
- id
A key field. Template: ShortText.
- background
Field components:
-
Uses template:
ShortText
. - Contains the following components: brightness, image_id, layout, href.
-
Uses template:
- colors
Field components:
-
Uses template:
ShortText
. - Contains the following components: answer, background, button, question.
-
Uses template:
- font
Template: ShortText.
- screens
Field components:
-
Uses template:
ShortText
. - Contains the following components: font_size, alignment.
-
Uses template:
- fields
Field components:
-
Uses template:
ShortText
. - Contains the following components: font_size, alignment.
-
Uses template:
- has_transparent_button
Data type: DT_BOOL
- name
Template: ShortText.
- visibility
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workspaces
.For further information check here.
- [Read single] action
-
Endpoint URL address:
/workspaces/{{=parameters.id}}
.
The result is extracted from:{{=[response]}}
.The action has the following user-defined parameters:
- id: Required. Specify the workspace_id.
For further information check here.
- [Read account] action
-
Endpoint URL address:
/accounts/{{=parameters.id}}
.The action has the following user-defined parameters:
- id: Required. Specify the account_id.
For further information check here.
- [Create] action
-
Endpoint URL address:
/workspaces
.For further information check here.
- [Update] action
-
Endpoint URL address:
/workspaces/{{=item.id}}
.
The action uses PATCH method.The following request parameters will be automatically processed:
-
application/json:
{{= [item] }}
For further information check here.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/workspaces/{{=item.id}}
.For further information check here.
- id
A key field. Template: ShortText.
- name
Template: ShortText.
- account_id
Template: ShortText.
- shared
Data type: DT_BOOL
- forms
Field components:
- An array.
- Contains the following components: href, count.
- self
Field components:
- An array.
- members
Field components:
- An array.
- Contains the following components: name, email, role.
- op
Template: ShortText.
- path
Template: ShortText.
- value
Template: LongText. A composite field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/forms/{{=parameters.id}}/webhooks
.The action has the following user-defined parameters:
- id: Required. Specify the form_id.
For further information check here.
- [Read single] action
-
Endpoint URL address:
/forms/{{=parameters.id}}/webhooks/{{=parameters.tag}}
.
The result is extracted from:{{=[response]}}
.The action has the following user-defined parameters:
- id: Required. Specify the form_id.
- tag: Required. Specify the tag.
For further information check here.
- [Create] action
-
Endpoint URL address:
/forms/{{=item.form_id}}/webhooks/{{=item.tag}}
.
The action uses PUT method.For further information check here.
- [Delete] action
-
Endpoint URL address:
/forms/{(=item.form_id}}/webhooks/{{=item.tag}}
.For further information check here.
The resource includes the fields from the WebhookT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/forms/{{=parameters.form_id}}/responses
.The action has the following user-defined parameters:
- form_id: Required. Specify the form_id.
For further information check here.
- [Delete] action
-
Endpoint URL address:
/forms/{{=parameters.form_id}}/responses
.The action has the following user-defined parameters:
- form_id: Required. Specify the form_id.
The following request parameters will be automatically processed:
-
included_response_ids:
{{=_.pluck(batch, 'response_id').join()}}
For further information check here.
- response_id
A key field. Template: ShortText.
- landing_id
Template: ShortText.
- token
Template: ShortText.
- landed_at
Template: DateTime. A read-only field.
- submitted_at
Template: DateTime. A read-only field.
- metadata
Field components:
-
Uses template:
ShortText
. - Contains the following components: user_agent, platform, referer, network_id, browser.
-
Uses template:
- hidden
Template: LongText. A composite field.
- calculated
Field components:
- Contains the following components: score.
- [External]
-
The external fields URL address:
/forms/{{=parameters.form_id}}
. The external fields list is extracted from:{{=response.fields}}
.- answer.{{=external.ref}}
Data type: {{=Typeform.getDataType(external.type)}} ( length {{=255}} )
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.