Overview
Configuration is provided for establishing connections with Wrike 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 task, we will show you step-by-step how to create a connection to Wrike REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop-down menu Configuration select Wrike. Then click New in the Token File parameter to create a new token file.
Step 3: In the Next Wizard you can add further scopes space separated to the list of default scopes or removed scopes from the default list of scopes that are not as per desired. Then click on Next button to initiate the authorization process.
Step 4: Provide your email and then click on Next button.
Step 5: Provide your password and then click on Login button.
Step 6: Save generated access token to file. Specify token protection password. Click OK.
Step 7. Click "Test Connection" to test your connection.
Congratulations! You have now established a connection to your Wrike instance.
In this guide, we will show how to read data from the Wrike service resource using the COZYROC REST Source component.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.
Step 3. Double click on the "REST Source" component and select Wrik connection from the combo. Select from available Wrike resources listed in the second combo below.
Optionally you can include extra parameters in the grid below if needed.
Step 4. Click on the "Columns tab" and select Wrik 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 Wrike service.
In this guide, we will show how to write data to the Wrike 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 Wrike connection from the combo. Also, select resource action and Wrike resource you want to work on.
Specify the parameters in the grid below if needed.
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 Wrike resource.
Configuration
Base URL address: https://www.wrike.com/api/v4.
- 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:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
bearer {{=token.Access}}
Documentation: https://developers.wrike.com/oauth-20-authorization/.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/contacts.The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/contacts/#query-contacts.
-
fields:
- [Read single] action
-
Endpoint URL address:
/users/{{=Wrike.UI.ContactEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- id: Required. Specify user identifier.
Documentation: https://developers.wrike.com/api/v4/users/#query-user.
- [Read list] action
-
Endpoint URL address:
/contacts/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma-separated list of contacts identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/users/#query-user.
- [Update] action
-
Endpoint URL address:
/contacts/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/contacts/#modify-contact.
- id
A key field. Template: ShortText.
- firstName
Template: ShortText.
- lastName
Template: ShortText.
- type
Template: ShortText.
- profiles
Field components:
- An array.
-
Uses template:
ProfileT.
- avatarUrl
Template: ShortText.
- timezone
Template: ShortText.
- locale
Template: ShortText.
- deleted
Data type: DT_BOOL
- me
Data type: DT_BOOL
- title
Template: LongText.
- companyName
Template: ShortText.
- phone
Template: ShortText.
- myTeam
Data type: DT_BOOL
- location
Template: ShortText.
- memberIds
Template: LongText. A composite field.
- metadata
Template: MetadataT.
- workScheduleId
Template: ShortText.
- currentBillRate
Data type: DT_R8
- currentCostRate
Data type: DT_R8
- billRateHistory
Field components:
- An array.
-
Uses template:
RateHistoryT.
- costRateHistory
Field components:
- An array.
-
Uses template:
RateHistoryT.
- timelog
A read-only field. The value is gathered from
/contacts/{{=item.id}}/timelogsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
TimeLogT.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups.The following request parameters will be automatically processed:
-
fields:
['metadata']
Documentation: https://developers.wrike.com/api/v4/groups/#query-groups.
-
fields:
- [Read single] action
-
Endpoint URL address:
/groups/{{=Wrike.UI.SingleEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- id: Required. Specify group identifiers.
The following request parameters will be automatically processed:
-
fields:
['metadata'] -
pageSize:
{{=undefined}}
Documentation: https://developers.wrike.com/api/v4/users/#query-user.
- [Create] action
-
Endpoint URL address:
/groups.Documentation: https://developers.wrike.com/api/v4/groups/#create-groups.
- [Update] action
-
Endpoint URL address:
/groups/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/groups/#modify-groups.
- [Delete] action
-
Endpoint URL address:
/groups/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/groups/#delete-groups.
- id
A key field. Template: ShortText.
- accountId
Template: ShortText. A read-only field.
- title
Template: LongText.
- memberIds
Template: MultiStringJoin. A read-only field.
- members
Template: MultiStringJoin.
- childIds
Template: MultiStringJoin. A read-only field.
- parentIds
Template: MultiStringJoin. A read-only field.
- avatarUrl
Template: ShortText. A read-only field.
- myTeam
Data type: DT_BOOL
- metadata
Template: MetadataT.
- parent
Template: ShortText.
- addMember
Template: MultiStringJoin.
- removeMembers
Template: MultiStringJoin.
- avatar
Field components:
-
Uses template:
ShortText. - Contains the following components: letters, color.
-
Uses template:
- addInvitations
Template: MultiStringJoin.
- removeInvitations
Template: MultiStringJoin.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/invitations.Documentation: https://developers.wrike.com/api/v4/invitations/#query-invitations.
- [Create] action
-
Endpoint URL address:
/invitations.Documentation: https://developers.wrike.com/api/v4/invitations/#create-invitation.
- [Update] action
-
Endpoint URL address:
/invitations/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/invitations/#update-invitation.
- [Delete] action
-
Endpoint URL address:
/invitations/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/invitations/#delete-invitation.
- id
A key field. Template: ShortText.
- accountId
Template: ShortText. A read-only field.
- firstName
Template: ShortText.
- lastName
Template: ShortText.
Template: ShortText.
- status
Template: ShortText. A read-only field.
- inviterUserId
Template: ShortText. A read-only field.
- invitationDate
Template: DateTime. A read-only field.
- resolvedDate
Template: DateTime. A read-only field.
- role
Template: ShortText.
- subject
Template: LongText.
- external
Data type: DT_BOOL
- resend
Data type: DT_BOOL
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/account.The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/account/#query-accounts.
-
fields:
- id
A key field. Template: ShortText.
- name
Template: ShortText.
- dateFormat
Template: ShortText.
- firstDayOfWeek
Template: ShortText.
- workDays
Template: MultiStringJoin.
- rootFolderId
Template: ShortText.
- recycleBinId
Template: ShortText.
- createdDate
Template: DateTime. A read-only field.
- subscription
Field components:
-
Uses template:
ShortText. - Contains the following components: type, suspended, paid, userLimit.
-
Uses template:
- metadata
Template: MetadataT.
- customFields
Field components:
- An array.
-
Uses template:
CustomFieldT.
- joinedDate
Template: DateTime. A read-only field.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/workflows.Documentation: https://developers.wrike.com/api/v4/workflows/#query-workflows.
- [Create] action
-
Endpoint URL address:
/workflows.Documentation: https://developers.wrike.com/api/v4/workflows/#create-workflow.
- [Update] action
-
Endpoint URL address:
/workflows/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/workflows/#modify-workflow.
- id
A key field. Template: ShortText.
- name
Template: ShortText.
- standard
Data type: DT_BOOL A read-only field.
- hidden
Data type: DT_BOOL
- customStatuses
Field components:
- An array.
- Contains the following components: id, name, standardName, color, standard, group, hidden.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/customfields.Documentation: https://developers.wrike.com/api/v4/custom-fields/#query-custom-fields.
- [Read list] action
-
Endpoint URL address:
/customfields/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma-separated list of cusatom field identifiers.
Documentation: https://developers.wrike.com/api/v4/users/#query-user.
- [Create] action
-
Endpoint URL address:
/customfields.Documentation: https://developers.wrike.com/api/v4/custom-fields/#create-custom-field.
- [Update] action
-
Endpoint URL address:
/customfields/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/custom-fields/#modify-custom-field.
The resource includes the fields from the CustomFieldT template.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/folders.
The result is extracted from:{{=response.data}}.The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/folders-projects/#get-folder-tree.
-
fields:
- [Read list] action
-
Endpoint URL address:
/folders/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of folder identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/folders-projects/#get-folder.
- [Read children] action
-
Endpoint URL address:
/folders/{{=Wrike.UI.SingleEditor.getValue(parameters)}}/folders.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- id: Required. Specify folder identifier to retreive the list of tree entries for subtree of this folder.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/folders-projects/#get-folder-tree.
- [Read space] action
-
Endpoint URL address:
/spaces/{{=Wrike.UI.SpaceEditor.getValue(parameters)}}/folders.The action has the following user-defined parameters:
- space_id: Required. Specify space identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/folders-projects/#get-folder-tree.
- [Create] action
-
Endpoint URL address:
/folders/{{=item.parent_id}}/folders.Documentation: https://developers.wrike.com/api/v4/folders-projects/#create-folder.
- [Update] action
-
Endpoint URL address:
/folders/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/folders-projects/#modify-folder.
- [Delete] action
-
Endpoint URL address:
/folders/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/folders-projects/#delete-folder.
The resource includes the fields from the FolderT template.
- accountId
Template: ShortText. A read-only field.
- children
Template: MultiStringJoin. A read-only field.
- shareds
Template: LongText. A read-only field. A composite field.
- customColumns
Template: LongText. A composite field.
- addParents
Template: LongText. A composite field.
- removeParents
Template: LongText. A composite field.
- addShareds
Template: LongText. A composite field.
- removeShareds
Template: LongText. A composite field.
- restore
Data type: DT_BOOL
- clearCustomColumns
Data type: DT_BOOL
- metadata
Template: MetadataT.
- contractType
Template: ShortText. A read-only field.
- finance
Template: FinanceT.
- superParentIds
Template: MultiStringJoin. A read-only field.
- customColumnIds
Template: MultiStringJoin. A read-only field.
- parentIds
Template: MultiStringJoin. A read-only field.
- sharedIds
Template: MultiStringJoin. A read-only field.
- childIds
Template: MultiStringJoin. A read-only field.
- createdDate
Template: DateTime. A read-only field.
- updatedDate
Template: DateTime. A read-only field.
- briefDescription
Template: LongText. A read-only field.
- description
Template: LongText.
- permalink
Template: ShortText. A read-only field.
- workflowId
Template: ShortText. A read-only field.
- workflattachmentCountowId
Template: ShortText.
- hasAttachments
Data type: DT_BOOL A read-only field.
- customFields
Field components:
- An array.
-
Uses template:
CustomFieldT.
- parent_id
A key field. Template: ShortText.
- tasks
A read-only field. The value is gathered from
/folders/{{=item.id}}/tasksaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
TaskT.
- comments
A read-only field. The value is gathered from
/folders/{{=item.id}}/commentsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
CommentT.
- timelog
A read-only field. The value is gathered from
/folders/{{=item.id}}/timelogsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
TimeLogT.
- attachments
A read-only field. The value is gathered from
/folders/{{=item.id}}/attachmentsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
AttachmentT.
- action
Template: ShortText. Field components:
-
Uses template:
ActionT. - Contains the following components: copyFolder, copyFolderAsync.
-
Uses template:
- [External]
-
The external fields URL address:
/customfields. The external fields list is extracted from:{{=Wrike.getCustomFields(response.data)}}.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/tasks.The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/tasks/#query-tasks.
-
fields:
- [Read list] action
-
Endpoint URL address:
/tasks/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of task identifiers.
The following request parameters will be automatically processed:
-
pageSize:
{{=undefined}} -
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/tasks/#query-tasks.
- [Read folder] action
-
Endpoint URL address:
/folders/{{=Wrike.UI.FolderEditor.getValue(parameters)}}/tasks.The action has the following user-defined parameters:
- folder_id: Required. Specify a folder identifier.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/tasks/#query-tasks.
- [Read space] action
-
Endpoint URL address:
/spaces/{{=Wrike.UI.SpaceEditor.getValue(parameters)}}/tasks.The action has the following user-defined parameters:
- space_id: Required. Specify space identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/tasks/#query-tasks.
- [Create] action
-
Endpoint URL address:
/folders/{{=item.folder_id}}/tasks.The following request parameters will be automatically processed:
-
item:
{{=_.omit(item, 'custom')}}
Documentation: https://developers.wrike.com/api/v4/tasks/#create-task.
-
item:
- [Update] action
-
Endpoint URL address:
/tasks/{{=item.id}}.The following request parameters will be automatically processed:
-
item:
{{=_.omit(item, 'custom')}}
Documentation: https://developers.wrike.com/api/v4/tasks/#modify-tasks.
-
item:
- [Delete] action
-
Endpoint URL address:
/tasks/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/tasks/#delete-tasks.
The resource includes the fields from the TaskT template.
- superTasks
Template: LongText. A composite field.
- followers
Template: LongText. A composite field.
- follow
Data type: DT_BOOL
- responsibles
Template: LongText. A composite field.
- addParents
Template: LongText. A composite field.
- removeParents
Template: LongText. A composite field.
- addShareds
Template: LongText. A composite field.
- removeShareds
Template: LongText. A composite field.
- addResponsibles
Template: LongText. A composite field.
- removeResponsibles
Template: LongText. A composite field.
- addResponsiblePlaceholders
Template: LongText. A composite field.
- removeResponsiblePlaceholders
Template: LongText. A composite field.
- addFollowers
Template: LongText. A composite field.
- addSuperTasks
Template: LongText. A composite field.
- removeSuperTasks
Template: LongText. A composite field.
- folder_id
A key field. Template: ShortText.
- comments
A read-only field. The value is gathered from
/tasks/{{=item.id}}/commentsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
CommentT.
- timelog
A read-only field. The value is gathered from
/contacts/{{=item.id}}/timelogsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
TimeLogT.
- attachments
A read-only field. The value is gathered from
/tasks/{{=item.id}}/attachmentsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
AttachmentT.
- [External]
-
The external fields URL address:
/customfields. The external fields list is extracted from:{{=Wrike.getCustomFields(response.data)}}.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/spaces.The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/spaces/#get-spaces.
-
fields:
- [Read single] action
-
Endpoint URL address:
/spaces/{{=Wrike.UI.SingleEditor.getValue(parameters)}}.The action has the following user-defined parameters:
- id: Required. Specify space identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}} -
pageSize:
{{=undefined}}
Documentation: https://developers.wrike.com/api/v4/spaces/#get-space.
- [Create] action
-
Endpoint URL address:
/spaces.Documentation: https://developers.wrike.com/api/v4/spaces/#create-space.
- [Update] action
-
Endpoint URL address:
/spaces/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/spaces/#update-space.
- [Delete] action
-
Endpoint URL address:
/spaces/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/spaces/#delete-space.
- id
A key field. Template: ShortText.
- title
Template: LongText.
- description
Template: LongText.
- avatarUrl
Template: ShortText. A read-only field.
- accessType
Template: ShortText.
- archived
Data type: DT_BOOL A read-only field.
- members
Field components:
- An array.
- Contains the following components: id, accessRoleId, isManager.
- guestRoleId
Template: ShortText.
- defaultProjectWorkflowId
Template: ShortText.
- defaultTaskWorkflowId
Template: ShortText.
- suggestedProjectWorkflowIds
Template: MultiStringJoin.
- suggestedTaskWorkflowIds
Template: MultiStringJoin.
- membersAdd
Template: LongText. A composite field.
- membersUpdate
Template: LongText. A composite field.
- membersRemove
Template: LongText. A composite field.
- tasks
A read-only field. The value is gathered from
/spaces/{{=item.id}}/tasksaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
TaskT.
- folders
A read-only field. The value is gathered from
/spaces/{{=item.id}}/foldersaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
FolderT.
- customItemTypes
A read-only field. The value is gathered from
/spaces/{{=item.id}}/custom_item_typesaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
CustomItemTypeT.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/comments.The following request parameters will be automatically processed:
-
fields:
['type']
Documentation: https://developers.wrike.com/api/v4/comments/#get-comments.
-
fields:
- [Read list] action
-
Endpoint URL address:
/comments/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of comment identifiers.
Documentation: https://developers.wrike.com/api/v4/spaces/#get-space.
- [Create] action
-
Endpoint URL address:
{{=item.owner}}/comments.Documentation: https://developers.wrike.com/api/v4/comments/#create-comment.
- [Update] action
-
Endpoint URL address:
/comments/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/comments/#update-comment.
- [Delete] action
-
Endpoint URL address:
/comments/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/comments/#delete-comment.
The resource includes the fields from the CommentT template.
- owner
A key field. Template: ShortText.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/tasks/{{=Wrike.UI.TaskEditor.getValue(parameters)}}/dependencies.The action has the following user-defined parameters:
- task_id: Required. Specify task identifier.
Documentation: https://developers.wrike.com/api/v4/dependencies/#query-dependencies.
- [Read list] action
-
Endpoint URL address:
/dependencies/{{=parameters.ids}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of dependencies identifier.
Documentation: https://developers.wrike.com/api/v4/dependencies/#query-dependencies.
- [Create] action
-
Endpoint URL address:
/tasks/{{=item.task_id}}/dependencies.Documentation: https://developers.wrike.com/api/v4/dependencies/#create-dependency.
- [Update] action
-
Endpoint URL address:
/dependencies/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/dependencies/#modify-dependency.
- [Delete] action
-
Endpoint URL address:
/dependencies/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/dependencies/#delete-dependency.
- id
A key field. Template: ShortText.
- predecessorId
Template: ShortText.
- successorId
Template: ShortText.
- relationType
Template: ShortText.
- task_id
A key field. Template: ShortText.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/timelogs.The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/timelogs/#query-timelogs.
-
fields:
- [Read list] action
-
Endpoint URL address:
/timelogs/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of time logs identifiers.
Documentation: https://developers.wrike.com/api/v4/timelogs/#query-timelogs.
- [Create] action
-
Endpoint URL address:
/tasks/{{=item.taskId}}/timelogs.Documentation: https://developers.wrike.com/api/v4/timelogs/#create-timelog.
- [Update] action
-
Endpoint URL address:
/timelogs/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/timelogs/#modify-timelog.
- [Delete] action
-
Endpoint URL address:
/timelogs/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/timelogs/#delete-timelog.
The resource includes the fields from the TimeLogT template.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/timelog_categories.Documentation: https://developers.wrike.com/api/v4/timelog-categories/#query-timelog-categories.
- id
Template: ShortText.
- name
Template: ShortText.
- order
Data type: DT_I4
- hidden
Data type: DT_BOOL
- timelog
A read-only field. The value is gathered from
/timelog_categories/{{=item.id}}/timelogsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
TimeLogT.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/attachments.Documentation: https://developers.wrike.com/api/v4/attachments/#get-attachments.
- [Read list] action
-
Endpoint URL address:
/attachments/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of attachments identifiers.
Documentation: https://developers.wrike.com/api/v4/attachments/#get-attachments.
- [Read folder] action
-
Endpoint URL address:
/folders/{{=Wrike.UI.FolderEditor.getValue(parameters)}}/attachments.The action has the following user-defined parameters:
- folder_id: Required. Specify folder identifier.
Documentation: https://developers.wrike.com/api/v4/attachments/#get-attachments.
- [Read task] action
-
Endpoint URL address:
/tasks/{{=Wrike.UI.TaskEditor.getValue(parameters)}}/attachments.The action has the following user-defined parameters:
- task_id: Required. Specify folder identifier.
Documentation: https://developers.wrike.com/api/v4/attachments/#get-attachments.
- [Create] action
-
Endpoint URL address:
{{=item.owner}}/attachments.The following request parameters will be automatically processed:
-
X-File-Name:
{{=item.attachmentContent}}
Documentation: https://developers.wrike.com/api/v4/attachments/#create-wrike-attachment.
-
X-File-Name:
- [Update] action
-
Endpoint URL address:
/attachments/{{=item.id}}.The following request parameters will be automatically processed:
-
X-File-Name:
{{=item.attachmentContent}}
Documentation: https://developers.wrike.com/api/v4/attachments/#update-attachment.
-
X-File-Name:
- [Delete] action
-
Endpoint URL address:
/attachments/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/attachments/#delete-attachment.
The resource includes the fields from the AttachmentT template.
- filename
Template: ShortText.
- owner
A key field. Template: ShortText.
- attachmentContent
Data type: DT_IMAGE The value is gathered from
/attachments/{{=item.id}}/downloadaddress.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/data_export.Documentation: https://developers.wrike.com/api/v4/data-export/#get-data-export.
- [Read single] action
-
Endpoint URL address:
/data_export/{{=parameters.id}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- id: Required. Specify data export identifier.
Documentation: https://developers.wrike.com/api/v4/data-export/#get-data-export.
- id
A key field. Template: ShortText.
- completedDate
Template: DateTime. A read-only field.
- status
Template: ShortText.
- resources
Field components:
- An array.
- Contains the following components: name, url.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/audit_log.Documentation: https://developers.wrike.com/api/v4/audit-log/#get-audit-log.
- id
A key field. Template: ShortText.
- operation
Template: ShortText.
- userId
Template: ShortText.
- userEmail
Template: ShortText.
- eventDate
Template: DateTime.
- ipAddress
Template: ShortText.
- objectType
Template: ShortText.
- objectName
Template: ShortText.
- objectId
Template: ShortText.
- details
Field components:
-
Uses template:
ShortText. - Contains the following components: User Role.
-
Uses template:
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/access_roles.Documentation: https://developers.wrike.com/api/v4/access-roles/#get-access-roles.
- id
A key field. Template: ShortText.
- title
Template: LongText.
- description
Template: LongText.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/async_job/{{=parameters.async_jobId}}.The action has the following user-defined parameters:
- async_jobId: Required. Specify async job identifier.
Documentation: https://developers.wrike.com/api/v4/async-job/#get-async-job.
- id
Template: ShortText.
- status
Template: ShortText.
- progressPercent
Data type: DT_I4
- totalCount
Data type: DT_I4
- processedCount
Data type: DT_I4
- type
Template: ShortText.
- errorMessage
Template: LongText.
- result
Field components:
-
Uses template:
ShortText. - Contains the following components: folderId.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/approvals.Documentation: https://developers.wrike.com/api/v4/approvals/#get-approvals.
- [Read list] action
-
Endpoint URL address:
/approvals/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of approvals identifiers.
Documentation: https://developers.wrike.com/api/v4/approvals/#get-approvals.
- [Read folder] action
-
Endpoint URL address:
/folders/{{=Wrike.UI.FolderEditor.getValue(parameters)}}/approvals.The action has the following user-defined parameters:
- folder_id: Required. Specify folder identifier.
Documentation: https://developers.wrike.com/api/v4/approvals/#get-approvals.
- [Read task] action
-
Endpoint URL address:
/tasks/{{=Wrike.UI.TaskEditor.getValue(parameters)}}/approvals.The action has the following user-defined parameters:
- task_id: Required. Specify task identifier.
Documentation: https://developers.wrike.com/api/v4/approvals/#get-approvals.
- [Create] action
-
Endpoint URL address:
{{=item.owner}}/approvals.Documentation: https://developers.wrike.com/api/v4/approvals/#create-approval.
- [Update] action
-
Endpoint URL address:
/approvals/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/approvals/#update-approval.
- [Delete] action
-
Endpoint URL address:
/approvals/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/approvals/#cancel-approval.
- id
A key field. Template: ShortText.
- taskId
Template: ShortText.
- folderId
Template: ShortText.
- authorId
Template: ShortText.
- title
Template: LongText.
- description
Template: LongText.
- updatedDate
Template: DateTime. A read-only field.
- dueDate
Template: DateTime.
- decisions
Field components:
- An array.
- Contains the following components: approverId, comment, status, updatedDate.
- reviewId
Template: ShortText.
- attachmentIds
Template: LongText. A composite field.
- addApprovers
Template: LongText. A composite field.
- removeApprovers
Template: LongText. A composite field.
- addAttachments
Template: LongText. A composite field.
- removeAttachments
Template: LongText. A composite field.
- type
Template: ShortText.
- autoFinishOnApprove
Template: ShortText.
- autoFinishOnReject
Template: ShortText.
- autoFinishOnApprove
Data type: DT_BOOL
- autoFinishOnReject
Data type: DT_BOOL
- finished
Data type: DT_BOOL
- status
Template: ShortText.
- finisherId
Template: ShortText.
- owner
A key field. Template: ShortText.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/workschedules.The following request parameters will be automatically processed:
-
fields:
['userIds']
Documentation: https://developers.wrike.com/api/v4/work-schedules/#query-work-schedules.
-
fields:
- [Read single] action
-
Endpoint URL address:
/workschedules/{{=Wrike.UI.SingleEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- id: Required. Specify work schedule identifier.
Documentation: https://developers.wrike.com/api/v4/work-schedules/#query-work-schedules.
- [Create] action
-
Endpoint URL address:
/workschedules.Documentation: https://developers.wrike.com/api/v4/work-schedules/#create-work-schedule.
- [Update] action
-
Endpoint URL address:
/workschedules/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/work-schedules/#update-work-schedule.
- [Delete] action
-
Endpoint URL address:
/workschedules/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/work-schedules/#delete-work-schedule.
- id
A key field. Template: ShortText.
- scheduleType
Template: ShortText.
- title
Template: LongText.
- workweek
Field components:
- An array.
- Contains the following components: workDays, capacityMinutes.
- userIds
Template: MultiStringJoin.
- addUsers
Template: MultiStringJoin.
- capacityMinutes
Data type: DT_I4
- exceptions
A read-only field. The value is gathered from
/workschedules/{{=item.id}}/workschedule_exclusionsaddress. The gathered value is processed with{{=response.data}}expression. Field components:- An array.
-
Uses template:
ExceptionT.
- action
Template: ShortText. Field components:
-
Uses template:
ActionT. - Contains the following components: copyWorkSchedule.
-
Uses template:
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/workschedules/{{=Wrike.UI.WorkScheduleEditor.getValue(parameters)}}/workschedule_exclusions.The action has the following user-defined parameters:
- workschedule_id: Required. Specify work schedule identifier.
Documentation: https://developers.wrike.com/api/v4/work-schedule-exceptions/#query-work-schedule-exceptions.
- [Read single] action
-
Endpoint URL address:
/workschedule_exclusions/{{=Wrike.UI.WorkExceptionEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- workschedule_id: Required. Specify work schedule identifier.
- id: Required. Specify work schedule exclusion identifier.
Documentation: https://developers.wrike.com/api/v4/work-schedule-exceptions/#query-work-schedule-exceptions.
- [Create] action
-
Endpoint URL address:
/workschedules/{{=item.workschedule_id}}/workschedule_exclusions.Documentation: https://developers.wrike.com/api/v4/work-schedule-exceptions/#create-work-schedule-exception.
- [Update] action
-
Endpoint URL address:
/workschedule_exclusions/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/work-schedule-exceptions/#update-work-schedule-exception.
- [Delete] action
-
Endpoint URL address:
/workschedule_exclusions/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/work-schedule-exceptions/#delete-work-schedule-exception.
The resource includes the fields from the ExceptionT template.
- workschedule_id
A key field. Template: ShortText.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/user_schedule_exclusions.Documentation: https://developers.wrike.com/api/v4/user-schedule-exceptions/#query-user-schedule-exception.
- [Read single] action
-
Endpoint URL address:
/workschedules/{{=Wrike.UI.UserExceptionEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- id: Required. Specify user schedule exclusion identifier.
Documentation: https://developers.wrike.com/api/v4/work-schedules/#query-work-schedules.
- [Create] action
-
Endpoint URL address:
/user_schedule_exclusions.Documentation: https://developers.wrike.com/api/v4/user-schedule-exceptions/#create-user-schedule-exception.
- [Update] action
-
Endpoint URL address:
/user_schedule_exclusions/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/user-schedule-exceptions/#update-user-schedule-exception.
- [Delete] action
-
Endpoint URL address:
/user_schedule_exclusions/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/user-schedule-exceptions/#delete-user-schedule-exception.
The resource includes the fields from the ExceptionT template.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/bookings.Documentation: https://developers.wrike.com/api/v4/bookings/#query-bookings.
- [Read list] action
-
Endpoint URL address:
/bookings/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma-separated list of bookings identifiers.
Documentation: https://developers.wrike.com/api/v4/users/#query-user.
- [Read folder] action
-
Endpoint URL address:
/folders/{{=Wrike.UI.FolderEditor.getValue(parameters)}}/bookings.The action has the following user-defined parameters:
- folder_id: Required. Specify a folder identifier.
Documentation: https://developers.wrike.com/api/v4/bookings/#query-bookings.
- [Create] action
-
Endpoint URL address:
/folders/{{=item.folderId}}/bookings.Documentation: https://developers.wrike.com/api/v4/bookings/#update-booking.
- [Update] action
-
Endpoint URL address:
/bookings/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/bookings/#update-booking.
- [Delete] action
-
Endpoint URL address:
/bookings/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/bookings/#delete-booking.
- id
A key field. Template: ShortText.
- folderId
Template: ShortText.
- responsibleId
Template: ShortText.
- bookingDates
Field components:
-
Uses template:
Date. - Contains the following components: duration, startDate, finishDate, workOnWeekends.
-
Uses template:
- effortAllocation
Field components:
-
Uses template:
ShortText. - Contains the following components: responsibleAllocation, mode, totalEffort.
-
Uses template:
- responsiblePlaceholderId
Template: ShortText.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/jobroles.Documentation: https://developers.wrike.com/api/v4/job-roles/#query-job-roles.
- [Read list] action
-
Endpoint URL address:
/jobroles/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma-separated list of job role identifiers.
Documentation: https://developers.wrike.com/api/v4/job-roles/#query-job-roles.
- [Create] action
-
Endpoint URL address:
/jobroles.Documentation: https://developers.wrike.com/api/v4/job-roles/#create-job-role.
- [Update] action
-
Endpoint URL address:
/jobroles/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/job-roles/#delete-job-role.
- [Delete] action
-
Endpoint URL address:
/jobroles/{{=item.id}}.Documentation: https://developers.wrike.com/api/v4/job-roles/#delete-job-role.
- id
A key field. Template: ShortText.
- title
Template: LongText.
- shortTitle
Template: ShortText.
- avatarUrl
Template: ShortText.
- isDeleted
Data type: DT_BOOL
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/placeholders.Documentation: https://developers.wrike.com/api/v4/placeholders/#query-placeholders.
- [Read list] action
-
Endpoint URL address:
/placeholders/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma-separated list of placeholder identifiers.
Documentation: https://developers.wrike.com/api/v4/placeholders/#query-placeholders.
- id
A key field. Template: ShortText.
- title
Template: LongText.
- shortTitle
Template: ShortText.
- jobRoleId
Template: ShortText.
- avatarUrl
Template: ShortText.
- deleted
Data type: DT_BOOL
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/folder_blueprints.Documentation: https://developers.wrike.com/api/v4/blueprints/#get-folder-blueprints-tree.
- [Read list] action
-
Endpoint URL address:
/placeholders/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma-separated list of placeholder identifiers.
Documentation: https://developers.wrike.com/api/v4/placeholders/#query-placeholders.
- id
A key field. Template: ShortText.
- title
Template: LongText.
- scope
Template: ShortText.
- childIds
Template: MultiStringJoin.
- parent
Template: ShortText.
- titlePrefix
Template: ShortText.
- copyDescriptions
Data type: DT_BOOL
- notifyResponsibles
Data type: DT_BOOL
- copyResponsibles
Data type: DT_BOOL
- copyCustomFields
Data type: DT_BOOL
- copyAttachments
Data type: DT_BOOL
- rescheduleDate
Template: Date.
- rescheduleMode
Template: ShortText.
- entryLimit
Data type: DT_I4
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/custom_item_types.Documentation: https://developers.wrike.com/api/v4/custom-item-types/#query-all-custom-item-types.
- [Read list] action
-
Endpoint URL address:
/custom_item_types/{{=Wrike.UI.ListEditor.getValue(parameters)}}.
The result is extracted from:{{=response.data}}.The action has the following user-defined parameters:
- ids: Required. Specify comma-separated list of placeholder identifiers.
Documentation: https://developers.wrike.com/api/v4/custom-item-types/#query-specific-custom-item-type-by-id.
The resource includes the fields from the CustomItemTypeT template.
Based on resource template NoPagination.
- [Read] action
-
Endpoint URL address:
/user_types.Documentation: https://developers.wrike.com/api/v4/user-types/.
- id
A key field. Template: ShortText.
- title
Template: LongText.
- description
Template: LongText.
Based on resource template NoPagination.
- [Read contact] action
-
Endpoint URL address:
/contacts/{{=parameters.ids}}/contacts_history.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of resource type identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/contacts/#query-contacts-fields-history.
- [Read task] action
-
Endpoint URL address:
/tasks/{{=parameters.ids}}/tasks_history.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of resource type identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/tasks/#query-tasks-fields-history.
- [Read folder] action
-
Endpoint URL address:
/folders/{{=parameters.ids}}/folders_history.The action has the following user-defined parameters:
- ids: Required. Specify comma separated list of resource type identifiers.
The following request parameters will be automatically processed:
-
fields:
{{=Wrike.getExpandFields(parameters)}}
Documentation: https://developers.wrike.com/api/v4/folders-projects/#query-folders-fields-history.
- id
A key field. Template: ShortText.
- billRateHistory
Field components:
- An array.
-
Uses template:
GeneralRateHistoryT.
- costRateHistory
Field components:
- An array.
-
Uses template:
GeneralRateHistoryT.
- project
Field components:
- Contains the following components: actualFees, actualCost, plannedFees, plannedCost, budget.
- actualFees
Field components:
- An array.
-
Uses template:
GeneralCostFeeT.
- budget
Field components:
- An array.
-
Uses template:
GeneralCostFeeT.
- actualCost
Field components:
- An array.
-
Uses template:
GeneralCostFeeT.
- plannedFees
Field components:
- An array.
-
Uses template:
GeneralCostFeeT.
- plannedCost
Field components:
- An array.
-
Uses template:
GeneralCostFeeT.
- [Read] action
-
The result is extracted from:{{=response.data}}.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}} -
item:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
item:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
Based on resource template NoPagination.
- [Read] action
-
The result is paginated.The following request parameters will be automatically processed:
-
nextPageToken:
{{=parameters.iterator}} -
pageSize:
{{=parameters.batchSize}}
-
nextPageToken:
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Date
Data type: DT_DBDATE
- Numeric
Data type: DT_R8
- Boolean
Data type: DT_BOOL
- Integer
Data type: DT_I4
- MultiStringJoin
Template: LongText. A composite field. The gathered value is processed with
{{=value && value.join(',')}}expression.- ProfileT
Field components:
-
Uses template:
ShortText. - Contains the following components: accountId, email, role, external, admin, owner.
-
Uses template:
- RateHistoryT
Field components:
-
Uses template:
ShortText. - Contains the following components: rateSource, rateValue, startDate.
-
Uses template:
- MetadataT
Field components:
- An array.
- Contains the following components: key, value.
- CustomFieldT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, accountId, title, type, sharedIds, settings.
-
Uses template:
- FinanceT
Field components:
-
Uses template:
ShortText. - Contains the following components: currency, actualFees, actualCost, plannedFees, plannedCost, customItemTypeId.
-
Uses template:
- TaskT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, accountId, title, description, briefDescription, parentIds, superParentIds, sharedIds, responsibleIds, responsiblePlaceholderIds, restore, responsiblePlaceholders, parents, shareds, status, priorityAfter, priorityBefore, importance, customStatus, createdDate, updatedDate, dates, scope, authorIds, customStatusId, hasAttachments, recurrent, attachmentCount, permalink, priority, superTaskIds, subTaskIds, dependencyIds, billingType, effortAllocation, customItemTypeId, metadata, customFields.
-
Uses template:
- FolderT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, title, color, childIds, scope, project, space, customItemTypeId.
-
Uses template:
- CommentT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, authorId, text, plainText, updatedDate, createdDate, folderId, taskId, type, emailSubject, direction, attachmentIds, externalRequester.
-
Uses template:
- TimeLogT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, taskId, userId, categoryId, hours, createdDate, updatedDate, trackedDate, comment, finance, billingType.
-
Uses template:
- AttachmentT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, authorId, name, createdDate, version, type, contentType, size, folderId, taskId, commentId, currentAttachmentId, previewUrl, url, playlistUrl, reviewIds, width, height.
-
Uses template:
- ExceptionT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, fromDate, toDate, isWorkDays, exclusionType, exclusionType.
-
Uses template:
- CustomItemTypeT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, title, description, relatedType, spaceId.
-
Uses template:
- GeneralCostFeeT
Field components:
-
Uses template:
DateTime. - Contains the following components: value, startDate, endDate.
-
Uses template:
- GeneralRateHistoryT
Field components:
-
Uses template:
ShortText. - Contains the following components: rateSource, rateValue, startDate.
-
Uses template:
- ActionT
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.