Toggl

Adicionando o conector

Baseado na documentação da API do Toggl

Este conector está em modo beta

Requisitos

  • Siga as instruções abaixo com um usuário Workspace administrator

Instruções

1) Faça login em sua conta Toggl acesse sua página de perfil em https://track.toggl.com/profile e copie o valor de API Token

2) Faça login na plataforma da Kondado, clique para criar um novo conector Toggl e cole em “API Token” o valor obtido no passo 1

Agora basta clicar em SALVAR e criar suas integrações para começar a receber dados do Toggl no seu Data Warehouse, Data Lake ou planilha

Integrações

Índice

Gráfico de relacionamento

Clique para ampliar

Clientes

Campo Tipo

id

text

[en] Client ID

archived

boolean

at

timestamp

[en] When was the last update

name

text

[en] Name of the client

wid

text

[en] Workspace ID

    Workspaces > > id

Grupos

Objeto principal

Campo Tipo

group_id

text

[en] Numeric ID of the group.

at

timestamp

[en] When was created/last modified

name

text

[en] Group name

workspaces

text

[en] List of group workspaces

toggl_groups_users

Campo Tipo

group_id

text

[en] Numeric ID of the group.

users_avatar_url

text

[en] User avatar URL

users_joined

boolean

users_name

text

users_user_id

text

Projetos

Objeto principal

Campo Tipo

id

text

[en] Project ID

active

boolean

[en] Indicates if the project is active

actual_hours

float

[en] Actual hours spent on the project

actual_seconds

float

[en] Actual seconds spent on the project

at

timestamp

[en] Timestamp of last update

auto_estimates

boolean

[en] Indicates if auto estimates are enabled for the project

billable

boolean

[en] Indicates if the project is billable

client_id

text

[en] ID of the client associated with the project

    Clients > > id

color

text

[en] Color associated with the project

created_at

timestamp

[en] Project creation timestamp

currency

text

[en] Currency used for billing

estimated_hours

float

[en] Estimated hours for the project

estimated_seconds

float

[en] Estimated seconds for the project

fixed_fee

float

[en] Fixed fee for the project

is_private

boolean

[en] Indicates if the project is private

name

text

[en] Project name

rate

float

[en] Hourly rate for the project

rate_last_updated

timestamp

[en] Timestamp of the last update to the rate

recurring

boolean

[en] Indicates if the project is recurring

server_deleted_at

text

[en] Timestamp of when the project was deleted on the server

start_date

date

[en] Start date of the project

status

text

[en] Current status of the project

template

boolean

[en] Indicates if the project is a template

template_id

text

[en] Template ID of the project

workspace_id

text

[en] Project workspace ID

    Workspaces > > id

toggl_projects_recurring_parameters

Campo Tipo

id

text

[en] Project ID

recurring_parameters_custom_period

text

[en] Custom recurring period

recurring_parameters_estimated_seconds

float

[en] Estimated seconds for recurring parameters

recurring_parameters_parameter_end_date

text

[en] End date for recurring parameters

recurring_parameters_parameter_start_date

date

[en] Start date for recurring parameters

recurring_parameters_period

text

[en] Recurring period type

recurring_parameters_project_start_date

date

[en] Project start date for recurring parameters

Projetos: grupos

Campo Tipo

id

text

[en] Refers to the unique identifier of the specific record.

group_id

text

[en] It's a unique identifier for the group.

    Groups > > group_id

pid

text

[en] It's the unique identifier of the project to which the group belongs.

    Projects > > id

wid

text

[en] Represents the unique identifier of the workspace where the project and the group are located.

    Workspaces > > id

Projetos: usuários

Campo Tipo

id

text

[en] Unique identifier of the project user

user_id

text

[en] Identifier of the user associated with this project

    Workspaces: users > > id

project_id

text

[en] Identifier of the associated project

    Projects > > id

group_id

text

[en] Identifier of the group this project user belongs to, if applicable

    Groups > > group_id

at

timestamp

[en] Timestamp of the last update to the project user

labour_cost

float

[en] Total labour cost for the user on this project

manager

boolean

[en] Indicates whether the user is a manager of the project

rate

float

[en] Hourly rate of the user for this project

rate_last_updated

timestamp

[en] Timestamp of the last update to the user's rate

workspace_id

text

[en] Identifier of the workspace this project user belongs to

    Workspaces > > id

Registros de tempo

Campo Tipo

id

text

[en] Unique identifier of the time entry

at

timestamp

[en] Timestamp indicating the last time the entry was updated

billable

boolean

[en] Indicates if the time entry is billable

billable_amount_in_cents

float

[en] The billable amount for the time entry in cents

currency

text

[en] Currency used for billing

description

text

[en] Description of the time entry

hourly_rate_in_cents

float

[en] Hourly rate for the time entry in cents

project_id

text

[en] Identifier of the project to which the time entry is associated

    Projects > > id

seconds

float

[en] Duration of the time entry in seconds

start

timestamp

[en] Start time of the time entry

stop

timestamp

[en] Stop time of the time entry

tag_ids

text

[en] List of tag identifiers associated with the time entry

    Tags > > id

task_id

text

[en] Identifier of the task to which the time entry is associated

    Tasks > > id

user_id

text

[en] Unique identifier of the user

    Workspaces: users > > id

username

text

[en] Name of the user

workspace_id

text

[en] Indicates the associated workspace for the given entry.

    Workspaces > > id

Tags

Campo Tipo

id

text

[en] TAG ID

at

timestamp

[en] IWhen was created/last modified

name

text

[en] TAG name

workspace_id

text

[en] TAG Workspace

    Workspaces > > id

Tarefas

Campo Tipo

id

text

[en] Unique identifier of the task

active

boolean

[en] Indicates whether the task is active

at

timestamp

[en] Timestamp of the last update to the task

estimated_seconds

float

[en] Estimated seconds for the task

name

text

[en] Name of the task

project_id

text

[en] Identifier of the project this task is associated with

    Projects > > id

recurring

boolean

[en] Indicates whether the task is recurring

tracked_seconds

float

[en] Total tracked seconds for the task

user_id

text

[en] Identifier of the user associated with this task

    Workspaces: users > > id

workspace_id

text

[en] Identifier of the workspace this task belongs to

    Workspaces > > id

Workspaces

Campo Tipo

id

text

[en] Workspace ID

admin

boolean

[en] List of admins

at

timestamp

[en] Creation time

business_ws

boolean

csv_upload

text

default_currency

text

[en] Default currency, premium feature, optional, only for existing WS, will be 'USD' initially

default_hourly_rate

float

[en] The default hourly rate, premium feature, optional, only for existing WS, will be 0.0 initially

ical_enabled

boolean

ical_url

text

last_modified

timestamp

logo_url

text

name

text

[en] Workspace name

only_admins_may_create_projects

boolean

[en] Only admins will be able to create projects, optional, only for existing WS, will be false initially

only_admins_may_create_tags

boolean

[en] Only admins will be able to create tags, optional, only for existing WS, will be false initially

only_admins_see_billable_rates

boolean

[en] Whether only admins will be able to see billable rates, premium feature, optional, only for existing WS. Will be false initially

only_admins_see_team_dashboard

boolean

[en] Only admins will be able to see the team dashboard, optional, only for existing WS, will be false initially

organization_id

text

[en] Numeric ID of the organization

premium

boolean

profile

float

projects_billable_by_default

boolean

[en] Whether projects will be set as billable by default, premium feature, optional, only for existing WS. Will be true initially

rate_last_updated

timestamp

[en] Date of last update in the 'rate' field

reports_collapse

boolean

[en] Whether reports should be collapsed by default, optional, only for existing WS, will be true initially

role

text

[en] A user's level of access and permissions in a workspace.

rounding

float

[en] Default rounding, premium feature, optional, only for existing WS

rounding_minutes

float

[en] Default rounding in minutes, premium feature, optional, only for existing WS

server_deleted_at

timestamp

subscription_auto_renew

boolean

subscription_card_details

text

subscription_company_id

text

subscription_contact_detail

text

subscription_created_at

timestamp

subscription_currency

text

subscription_customer_id

text

subscription_deleted_at

text

subscription_last_pricing_plan_id

text

subscription_organization_id

text

subscription_payment_details

text

subscription_pricing_plan_id

text

subscription_renewal_at

timestamp

subscription_subscription_id

text

subscription_subscription_period

text

subscription_working_hours_in_minutes

float

subscription_workspace_id

text

suspended_at

timestamp

Workspaces: usuários

Campo Tipo

id

text

[en] User ID

email

text

[en] User's email

fullname

text

[en] User's full name

inactive

boolean

is_active

boolean

[en] If 'True', user with invitation accepted in Workspace.

is_admin

boolean

[en] If 'True', user has admin permissions on the workspace.

wid

text

[en] Project workspace ID

    Workspaces > > id