Toggl Track

Toggl Track is a time-tracking and reporting solution that helps individuals and teams manage projects.

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

Backup: Skyvia Backup does not support Toggl Track.

Query: Skyvia Query supports Toggl Track.  

Establishing Connection

  To create a connection to Toggl Track, specify the API Token.  

Getting Credentials

To locate an API Token, go to Toggle Track and do the following.

  1. Click the user icon on the bottom left.
  2. Select Profile Settings.
  3. Scroll to the API Token section and press Click to Reveal.

    toggltrack-apikey

  4. Copy the API Token.

Creating Connection

To connect to Toggl Track, perform the following steps:

toggltrack-connection  

Connector Specifics

Object Peculiarities

Clients

When querying, the Clients object returns records with active and archived status. Use filter by the Status field to select records of the particular status.

TimeEntries

The TimeEntries object returns the records for the last two weeks when querying. To query other records, use filters by the Before field with < or <= operators or a pair of fields StartDate and EndDate with > or >= operators.

Groups

The Users field value returns in the following JSON format when querying:   [{"user_id":11058573,"name":"dataloader.io@gmail.com","avatar_url":"","inactive":false,"joined":true}]

However, to insert or update data in this field, map this field to the array of user IDs in the following format: [123, 456, 789].  

Filtering Specifics

The Tags, Tasks, Workspaces, and TimeEntries objects support filtering by the UpdatedDate field using the> and >= operators.

The maximum period for filtering is three months. Due to Toggl Track API specifics, you can select data for the last three months. If you select data for a date earlier than three months ago, you will get an error message saying “Since cannot be older than 3 months.”

DML Operations Support

Operation Object
INSERT, UPDATE, DELETE Approvals, Clients, Groups, Projects, Tags, Tasks, TimeEntries, WorkspaceprojectUsers
INSERT, UPDATE Organizations, Workspaces

Incremental Replication

The following Toggl Track objects support Incremental Updates: Organizations, Projects, User, Clients, Groups, Tags, Tasks, TimeEntries, TrackReminders, WebTimerTimeEntries, WorkspaceProjectsUsers, Workspaces. Skyvia detects only new records for the TrackReminders object.

Only the Projects and Organizations objects support Synchronization. The Organizations object supports the INSERT and UPDATE operations but doesn’t support the DELETE operation. Deleted records will fail during Synchronization.  

Stored Procedures

Skyvia represents part of the supported Toggl Track 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.    

StopTimeEntry

The following command stops a workspace time entry.

call StopTimeEntry(:workspace_id,:time_entry_id)

ArchiveClient

The following command archives a workspace client and related projects.

call ArchiveClient(:workspace_id,:client_id)

UpdateStartDate

To update a timesheet start date, use the following command.

call UpdateStartDate (:workspace_id, :setup_id, :start_date, :rejection_comment, :status)

Parameter Description
Workspace_id Numeric ID of the workspace.
Setup_id Numeric ID of the timesheet setup.
Start_date The time sheet start date in the YYYY-MM-DD format.
Rejection_comment String comment
Status String

Supported Actions

Skyvia supports all the common actions for Toggl Track.