Overview
Configuration is provided for establishing connections with Tableau Server via its REST API. The configuration is used in the REST Connection Manager.
Demonstration
Quick Start
In this guide, we will show you how to create a connection to Tableau service using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio".
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 manager" and click "Add..."
Step 4. From Configuration combo box select "Tableau".
Step 5. Enter server host parameter.
Step 6. Enter user name parameter.
Step 7. Enter password parameter.
- site - If you are connecting to "Tableau Online", the site parameter is mandatory. For on-premise server it is optional and when empty the result is identical to specifying the Default site.
- impersonateId - The LUID of a user to sign in as. For impersonation when a system administrator signs in with user name and password.
Step 7. Click "Test Connection" to test your connection.
Congratulations! You have now established a connection to your Tableau instance.
In this guide, we will show how to read data from the Tableau service resource using COZYROC REST Source component.
Step 1. Select existing "Data Flow task" or create new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.
Step 3. Double click on "REST Source" component and select Tableau connection from the combo. Select from available Tableau resources listed in the second combo below.
Optionally you can include extra parameters in the grid below if needed.
Step 4. Click on "Columns tab" and select Tableau resource columns you want to read.
Step 5. Click Preview to make sure all necessary resource columns are included.
Bravo! You have now learned how to read data from Tableau service.
In this guide, we will show how to write data to Tableau service resource using COZYROC REST Destination component.
Step 1. Select existing "Data Flow task" or create new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.
Step 3. Double click on "REST Destination" component and select Tableau connection from the combo. Also, select resource action and the Tableau resource you want to work on.
Step 4. Click on "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 a Tableau resource.
In this guide, we will provide steps to upload a Tableau TDE file to a server. For novice users, we recommend you first review "Push data to service" guide.
You can upload a Tableau TDE file either to a "Data Source" or "Workbook" resource. This guide will show the "Data Source" use and the process will be similar for the other resource.
Step 1. You have to provide input for the following required columns:
- name - name of the data source.
- project.id - project identifier.
- content - the TDE file content. Use the standard "Import Column" transformation to load the file content into a data flow column. Here you can find one reference how to configure the "Import Column" transformation.
Step 2. Set the Tableau connection.
Step 3. Set the resource to "Data Source".
Step 4. Set the action to Create.
Step 5. Set batch size to 1.
Step 6. Click on the "Mapping" tab and connect the required input columns.
Configuration
Base URL address: https://[pod].online.tableau.com/api/3.4.
-
The authentication uses a session token.
The authentication has the following user-defined parameters:
- name: Required. Specify user name.
- password: Required. Specify password.
- site:
- impersonateId:
- expiration: Session token expiration in minutes.
The following request parameters will be automatically processed during the authentication process:
-
X-Tableau-Auth:
{{=token.Access}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#sign_in.
- [Read] action
-
Endpoint URL address:
/sites.
The result is extracted from:{{=response.sites.site}}.
The result is paginated.The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_sites.
-
pageSize:
- [Create] action
-
Endpoint URL address:
/sites.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ site: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_site.
-
_includeUserParameters:
- [Update] action
-
Endpoint URL address:
/sites/{{=item.id}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ site: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_site.
-
_includeUserParameters:
- [Delete] action
-
Endpoint URL address:
/sites/{{=item.id}}.
The action uses DELETE method.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_site.
- id
A key field. Template: Id.
- name
Template: ShortText.
- contentUrl
Template: ShortText.
- adminMode
Template: ShortText.
- disableSubscriptions
Data type: DT_BOOL
- state
Template: ShortText.
- revisionHistoryEnabled
Data type: DT_BOOL
- revisionLimit
Data type: DT_I4
- subscribeOthersEnabled
Data type: DT_BOOL
- guestAccessEnabled
Data type: DT_BOOL
- cacheWarmupEnabled
Data type: DT_BOOL
- commentingEnabled
Data type: DT_BOOL
- flowsEnabled
Data type: DT_BOOL
- userQuota
Data type: DT_I4
- storageQuota
Data type: DT_I4
- [Read site] action
-
Endpoint URL address:
/sites/{{=parameters.site}}/views.
The result is extracted from:{{=response.views.view}}.
The result is paginated.The action has the following user-defined parameters:
- site: Required. Specifies site identifier.
The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_views_for_site.
- [Read workbook] action
-
Endpoint URL address:
/sites/{{=parameters.site}}/workbooks/{{=parameters.workbook}}/views.
The result is extracted from:{{=response.views.view}}.
The result is paginated.The action has the following user-defined parameters:
- site: Required. Specifies site identifier.
- workbook: Required. Specifies workbook identifier.
The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_views_for_workbook.
- id
Template: Id.
- name
Template: ShortText.
- contentUrl
Template: ShortText.
- workbook
Template: Reference.
- owner
Template: Reference.
- usage
Field components:
- Contains the following components: totalViewCount.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/dataAlerts.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data-driven_alerts.
- [Update] action
-
Endpoint URL address:
/dataAlerts/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_data-driven_alert.
- [Delete] action
-
Endpoint URL address:
/dataAlerts/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_data-driven_alert.
- id
A key field. Template: Id.
- subject
Template: ShortText.
- creatorId
Template: Id. A read-only field.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- frequency
Template: ShortText.
- public
Data type: DT_BOOL
- owner
Template: Reference.
- view
Template: Reference. A read-only field. Field components:
-
Uses template:
Reference. - Contains the following components: workbook, project.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/projects.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_projects.
- [Create] action
-
Endpoint URL address:
/projects.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_project.
- [Update] action
-
Endpoint URL address:
/projects/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_project.
- [Delete] action
-
Endpoint URL address:
/projects/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_project.
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: LongText.
- contentPermissions
Template: ShortText.
- owner
Template: Reference. A read-only field.
- parentProjectId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workbooks.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbooks_for_site.
- [Read user] action
-
Endpoint URL address:
{{=connection.serverHost}}/users/{{=parameters.user}}/workbooks.The action has the following user-defined parameters:
- user: Required. Specifies user identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbooks_for_user.
- [Create] action
-
Endpoint URL address:
/workbooks.The following request parameters will be automatically processed:
-
uploadSessionId:
{{=Tableau.uploadFile(item.content)}} -
workbookType:
{{=item.type || 'twb'}} -
multipart/mixed;boundary={{=Tableau.BoundId}}:
{{=Tableau.getRequestBody({ workbook: item })}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#publish_workbook.
-
uploadSessionId:
- [Update] action
-
Endpoint URL address:
/workbooks/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_workbook.
- [Delete] action
-
Endpoint URL address:
/workbooks/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_workbook.
- id
A key field. Template: Id.
- name
Template: ShortText.
- description
Template: LongText.
- webpageurl
Template: ShortText. A read-only field.
- contentUrl
Template: ShortText. A read-only field.
- showTabs
Data type: DT_BOOL
- size
Data type: DT_I4 A read-only field.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- project
Template: Reference.
- owner
Template: Reference.
- tags
Field components:
- An array.
- content
Data type: DT_IMAGE The value is gathered from
/workbooks/{{=item.id}}/contentaddress.Data type: DT_IMAGE A read-only field. The value is gathered from
/workbooks/{{=item.id}}/pdfaddress.- type
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workbooks/{{=parameters.workbook}}/connections.The action has the following user-defined parameters:
- workbook: Required. Specifies workbook identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbook_connections.
- [Update] action
-
Endpoint URL address:
/workbooks/{{=item.workbookId}}/connections.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_workbook_connection.
- id
A key field. Template: Id.
- type
Template: ShortText.
- serverAddress
Template: ShortText.
- serverPort
Template: ShortText.
- userName
Template: ShortText.
- password
Template: ShortText.
- embedPassword
Data type: DT_BOOL
- workbookId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/datasources.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data_sources.
- [Create] action
-
Endpoint URL address:
/datasources.The following request parameters will be automatically processed:
-
uploadSessionId:
{{=Tableau.uploadFile(item.content)}} -
datasourceType:
{{=item.type || 'tde'}} -
multipart/mixed;boundary={{=Tableau.BoundId}}:
{{=Tableau.getRequestBody({ datasource: item })}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#publish_data_source.
-
uploadSessionId:
- [Update] action
-
Endpoint URL address:
/datasources/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_data_source.
- [Delete] action
-
Endpoint URL address:
/datasources/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_data_source.
- id
A key field. Template: Id.
- name
Template: ShortText.
- contentUrl
Template: ShortText.
- type
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- project
Template: Reference.
- owner
Template: Reference.
- tags
Field components:
- An array.
- isCertified
Data type: DT_BOOL
- certificationNote
Template: ShortText.
- content
Data type: DT_IMAGE The value is gathered from
/datasources/{{=item.id}}/contentaddress.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/datasources/{{=parameters.datasource}}/connections.The action has the following user-defined parameters:
- datasource: Required. Specifies data source identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data_source_connections.
- [Update] action
-
Endpoint URL address:
/datasources/{{item.datasourceId}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_data_source_connection.
- id
A key field. Template: Id.
- type
Template: ShortText.
- serverAddress
Template: ShortText.
- serverPort
Template: ShortText.
- userName
Template: ShortText.
- password
Template: ShortText.
- embedPassword
Data type: DT_BOOL
- datasourceId
Template: Id.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_groups.
- [Create] action
-
Endpoint URL address:
/groups.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_group.
- [Update] action
-
Endpoint URL address:
/groups/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_group.
- [Delete] action
-
Endpoint URL address:
/groups/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_group.
- id
A key field. Template: Id.
- name
Template: ShortText.
- domain
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: name.
-
Uses template:
- import
Field components:
-
Uses template:
ShortText. - Contains the following components: source, domainName, siteRole.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_users_on_site.
- [Read group] action
-
Endpoint URL address:
/groups/{{=parameters.group}}/users.The action has the following user-defined parameters:
- group: Required. Specifies group identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_users_in_group.
- [Create] action
-
Endpoint URL address:
/users.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#add_user_to_site.
- [Update] action
-
Endpoint URL address:
/users/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_user.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#remove_user_from_site.
- id
A key field. Template: Id.
- name
Template: ShortText.
- siteRole
Template: ShortText.
- lastLogin
Template: DateTime. A read-only field.
- externalAuthUserId
Template: Id.
- authSetting
Template: ShortText.
- fullName
Template: ShortText.
Template: ShortText.
- password
Template: ShortText.
Based on resource template Base.
- [Read datasource] action
-
Endpoint URL address:
/datasources/{{=parameters.datasource}}/revisions.The action has the following user-defined parameters:
- datasource: Required. Specifies data source identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_data_source_revisions.
- [Read workbook] action
-
Endpoint URL address:
/workbooks/{{=parameters.workbook}}/revisions.The action has the following user-defined parameters:
- workbook: Required. Specifies workbook identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_workbook_revisions.
- [Delete] action
-
Endpoint URL address:
{{=(parameters.resource == 'datasource') ? '/datasources/' + item.resourceId + '/revisions/' + item.revisionNumber : '/workbooks/' + item.resourceId + '/revisions/' + item.revisionNumber}}.The action has the following user-defined parameters:
- resource: Required. Specifies resource type - datasource, workbook.
- revisionNumber
A key field. Data type: DT_I4
- createdAt
Template: DateTime.
- isDeleted
Data type: DT_BOOL
- user
Template: Reference.
- resource
Template: ShortText. The gathered value is processed with
{{=parameters.get('datasource') ? 'datasource' : 'workbook'}}expression.- resourceId
Template: Id.
- content
Data type: DT_IMAGE The value is gathered from
{{=parameters.get('datasource') ? '/datasources/' + parameters.datasource + '/revisions/' + item.revisionNumber + '/content' : '/workbooks/' + parameters.workbook + '/revisions/' + item.revisionNumber + '/content'}}address.
Based on resource template Base.
- [Read datasource] action
-
Endpoint URL address:
/datasources/{{=parameters.datasource}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- datasource: Required. Specifies data source identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_data_source_permissions.
- [Read project] action
-
Endpoint URL address:
/projects/{{=parameters.project}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- project: Required. Specifies project identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_project_permissions.
- [Read] action
-
Endpoint URL address:
/projects/{{=parameters.project}}/default-permissions/{{=parameters.resource}}.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- project: Required. Specifies project identifier.
- resource: Required. Specifies resource type - datasources, workbooks, flows
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_default_permissions.
- [Read view] action
-
Endpoint URL address:
/views/{{=parameters.view}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- view: Required. Specifies view identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_view_permissions.
- [Read workbook] action
-
Endpoint URL address:
/workbooks/{{=parameters.workbook}}/permissions.
The result is extracted from:{{=response.permissions.granteeCapabilities}}.The action has the following user-defined parameters:
- workbook: Required. Specifies workbook identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_workbook_permissions.
- user
Template: Reference.
- group
Template: Reference.
- capabilities
Field components:
- An array.
- Contains the following components: name, mode.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/jobs.
The result is extracted from:{{=response.backgroundJobs}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_jobs.
- [Delete] action
-
Endpoint URL address:
/jobs/{{=item.id}}.
The action uses PUT method.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#cancel_job.
- id
A key field. Template: Id.
- status
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- startedAt
Template: DateTime. A read-only field.
- endedAt
Template: DateTime. A read-only field.
- priority
Template: ShortText.
- jobType
Template: ShortText.
- [Read] action
-
Endpoint URL address:
/schedules.
The result is extracted from:{{=response.schedules.schedule}}.
The result is paginated.The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_schedules.
-
pageSize:
- [Create] action
-
Endpoint URL address:
/schedules.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ schedule: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_schedule.
-
_includeUserParameters:
- [Update] action
-
Endpoint URL address:
/schedules/{{=item.id}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{={ schedule: item } }}
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_schedule.
-
_includeUserParameters:
- [Delete] action
-
Endpoint URL address:
/schedules/{{=item.id}}.
The action uses DELETE method.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_schedule.
- id
A key field. Template: Id.
- name
Template: ShortText.
- state
Template: ShortText.
- priority
Template: ShortText.
- createdAt
Template: DateTime. A read-only field.
- updatedAt
Template: DateTime. A read-only field.
- type
Template: ShortText.
- frequency
Template: ShortText.
- nextRunAt
Template: DateTime.
- endScheduleAt
Template: DateTime.
- executionOrder
Template: ShortText.
- frequencyDetails
Field components:
-
Uses template:
ShortText. - Contains the following components: start, end, intervals.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/subscriptions.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#query_subscriptions.
- [Create] action
-
Endpoint URL address:
/subscriptions.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#create_subscription.
- [Update] action
-
Endpoint URL address:
/subscriptions/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#update_subscription.
- [Delete] action
-
Endpoint URL address:
/subscriptions/{{=item.id}}.Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#delete_subscription.
- id
A key field. Template: Id.
- subject
Template: ShortText.
- content
Field components:
-
Uses template:
Id. - Contains the following components: id, type.
-
Uses template:
- schedule
Template: Reference.
- user
Template: Reference.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/favorites/{{=parameters.user}}.The action has the following user-defined parameters:
- user: Required. Specifies user identifier.
Documentation: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref.htm#get_favorites_for_user.
- [Create] action
-
Endpoint URL address:
/favorites/{{=item.userId}}.
- [Delete] action
-
Endpoint URL address:
/favorites/{{=item.userId}}/{{= (item.datasource && 'datasources/' + item.datasource.id) || (item.project && 'projects/' + item.project.id) || (item.view && 'views/' + item.view.id) || (item.workbook && 'workbooks/' + item.workbook.id) }}.
- label
Template: ShortText.
- project
Template: Reference.
- workbook
Template: Reference.
- view
Template: Reference.
- datasource
Template: Reference.
- userId
Template: Id.
- [Read] action
-
The result is extracted from:{{=response[resource.objects][resource.object]}}.
The result is paginated.The following request parameters will be automatically processed:
-
pageSize:
{{=parameters.batchSize}} -
pageNumber:
{{=parameters.iterator}} -
_includeUserParameters:
{{=parameters}}
-
pageSize:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=function() { var result = {}; result[resource.object] = item; return result; }()}}
-
_includeUserParameters:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=function() { var result = {}; result[resource.object] = item; return result; }()}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- Id
Data type: DT_GUID
- DateTime
Data type: DT_DBTIMESTAMP
- Reference
Field components:
-
Uses template:
Id. - Contains the following components: id, name.
-
Uses template:
Knowledge Base
- Where can I find the documentation for the Tableau Connection?
- How to install the Legacy Extract API for .tde files.
What's New
- Fixed: Incorrect pagination definition (Thank you, Leo).
- New: Introduced connection.
Related documentation
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.