Wrike

Wrike is a digital work management tool that helps users track and coordinate projects.

Data integration: Skyvia supports importing data to and from Wrike, exporting Wrike data to CSV files, replicating Wrike data to relational databases, and synchronizing Wrike data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Wrike.

Query: Skyvia Query supports Wrike.

Establishing Connection

To create a connection with Wrike, log in to your Wrike account.

Creating Connection

To start creating a connection, follow the steps below:

1. In the Connection Editor, click Sign In with Wrike.

2. In the opened window, enter your email used when signing in to Wrike.

   

3. Enter your password.

   

Additional Connection Parameters

Suppress Extended Requests

Wrike API returns only part of the fields for some objects when querying multiple records. To query values of lacking fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such an object. However, this can decrease performance and significantly increase the number of API calls used.

The additional fields are the following:

You can select the Suppress Extended Requests checkbox to reduce the number of API calls.

Connector Specifics

Object Peculiarities

Users

You can only get data from this object by the specified Id.

Invitations

The delete operation performs the soft delete when deleting records from this object. It changes the record’s status to Canceled instead of physically deleting it.

AuditLog

The AuditLog object data is available for the Wrike users on the Enterprise plan.

Spaces

Use the Members, SuggestedProjectWorkflowIds, SuggestedTaskWorkflowIds fields to query data from the Spaces object. Fields MembersAdd, MembersUpdate, MembersRemove, SuggestedProjectWorkflowsAdd, SuggestedProjectWorkflowsRemove, SuggestedTaskWorkflowsAdd, SuggestedTaskWorkflowsRemove are used for import and return empty results by default when querying.

When performing an Insert operation, assign the Members field mapping in the following format: [{"id":"KUFK5PNB","accessRoleId":"IEC7PGVEND777777","isManager":true}].

When performing an Update operation, the MembersAdd, MembersUpdate fields should have the same format. When deleting records, select the Update operation in the integration and map the MembersRemove field to the list of Ids you want to remove (for example, ["KUFK5PNB", "KUFK5PN8"]).

WorkSchedule

When querying data from the WorkSchedule object, the Workweek field returns in the following format [{"workDays":["Mon","Tue","Wed","Thu","Fri"]}] in the result.

When performing the Insert and Update operations, the Workweek field should look like below:

1
2
3
4
[{"dayOfWeek":"Mon","isWorkDay":true},{"dayOfWeek":"Tue","isWorkDay":true},   
{"dayOfWeek":"Wed","isWorkDay":true},{ "dayOfWeek":"Thu","isWorkDay":false},   
{"dayOfWeek":"Fri","isWorkDay":false},{"dayOfWeek":"Sat","isWorkDay":false},   
{"dayOfWeek ":"Sun","isWorkDay":false}]

The AddUsers and RemoveUsers fields are used for import and return empty results when querying.

Use the AddUsers field for Insert and Update operations.

To delete the record, select the Update operation in the integration and specify the user ID, you want to delete in the RemoveUsers field mapping. For example, ["KUAHVFPE"].

Tasks

The AddParents, AddShareds, AddResponsibles, AddFollowers, AddSuperTasks, RemoveParents, RemoveShareds, RemoveResponsibles, RemoveSuperTasks fields return empty results when querying. They are used for the Update operation.

Comments

The Comments object returns data for the last seven days by default if you don’t use filters. To query data for other periods, use filter by the PeriodDate field. Its values in the filter should look like this {"start":"2023-06-28T14:50:31Z","end":"2023-06-30T14:50:31Z"}.

Incremental Replication and Synchronization

Skyvia supports Replication with Incremental Updates for Wrike objects: Account, Approvals, Attachments, Comments, Tasks, Timelogs, FoldersAndSpaces, Projects.

Skyvia supports Synchronization for such Wrike objects Approvals, Timelogs.

DML Operation Support

Skyvia supports DML operations for such Wrike objects:

Stored Procedures

Skyvia represents part of the supported Wrike features as stored procedures. You can call a stored procedure, for example, as a text of the command in the ExecuteCommand action in a Target component of a Data Flow or in Query.

CreateTaskComment

Use the following command to insert the comment for a folder.

call CreateTaskComment(:task1, :text)

You can update the existing comments only within 5 minutes after their creation. When you try to update comments later, you will get an error.

CreateFolderApproval

To add a record to the specific folder, use the following command.

call CreateFolderApproval(:FolderId, :Description, :DueDate, :Approvers, :Attachments, :AutoFinishOnApprove, :AutoFinishOnReject)

UpdateDependencies

To Update and Delete the dependencies, use the following command call UpdateDependencies(:dependencyId, :RelationType)

DeleteDependencies

Use the following command to delete the specific dependency.

call DeleteDependencies(:dependencyId).

Supported Actions

Skyvia supports all the common actions for Wrike.