Toggl

Tables in the Toggl connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	workspace_tasks	11		Full Refresh
2	workspace	3		Full Refresh
3	workspace_clients	6		Full Refresh
4	organizations	16		Full Refresh
5	organizations_users	13		Full Refresh
6	workspace_projects	25		Full Refresh
7	organizations_groups	5		Full Refresh
8	time_entries	19		Full Refresh

Table: workspace_tasks

No	Column Name	Type	Notes
1	workspace_id	INTEGER
2	at	VARCHAR
3	project_id	INTEGER
4	user_id	INTEGER
5	recurring	BOOLEAN
6	estimated_seconds	INTEGER
7	name	VARCHAR
8	active	BOOLEAN
9	tracked_seconds	INTEGER
10	id	INTEGER
11	server_deleted_at	VARCHAR

Table: workspace

No	Column Name	Type	Notes
1	groups_count	INTEGER
2	members_count	INTEGER
3	admins	VARCHAR

Table: workspace_clients

No	Column Name	Type	Notes
1	archived	BOOLEAN
2	at	VARCHAR
3	wid	INTEGER
4	name	VARCHAR
5	id	INTEGER
6	server_deleted_at	VARCHAR

Table: organizations

No	Column Name	Type	Notes
1	owner	BOOLEAN
2	max_workspaces	INTEGER
3	trial_info	VARCHAR
4	admin	BOOLEAN
5	created_at	VARCHAR
6	is_chargify	BOOLEAN
7	pricing_plan_id	INTEGER
8	is_unified	BOOLEAN
9	payment_methods	VARCHAR
10	at	VARCHAR
11	user_count	INTEGER
12	name	VARCHAR
13	id	INTEGER
14	is_multi_workspace_enabled	BOOLEAN
15	server_deleted_at	VARCHAR
16	suspended_at	VARCHAR

Table: organizations_users

No	Column Name	Type	Notes
1	owner	BOOLEAN
2	invitation_code	VARCHAR
3	joined	BOOLEAN
4	admin	BOOLEAN
5	can_edit_email	BOOLEAN
6	groups	VARCHAR
7	inactive	BOOLEAN
8	avatar_url	VARCHAR
9	user_id	INTEGER
10	name	VARCHAR
11	id	INTEGER
12	workspaces	VARCHAR
13	email	VARCHAR

Table: workspace_projects

No	Column Name	Type	Notes
1	is_private	BOOLEAN
2	template	BOOLEAN
3	color	VARCHAR
4	created_at	VARCHAR
5	client_id	INTEGER
6	current_period	VARCHAR
7	workspace_id	INTEGER
8	auto_estimates	BOOLEAN
9	wid	INTEGER
10	actual_hours	INTEGER
11	rate	DOUBLE
12	currency	VARCHAR
13	id	INTEGER
14	recurring	BOOLEAN
15	first_time_entry	VARCHAR
16	active	BOOLEAN
17	fixed_fee	DOUBLE
18	billable	BOOLEAN
19	at	VARCHAR
20	rate_last_updated	VARCHAR
21	estimated_hours	INTEGER
22	name	VARCHAR
23	recurring_parameters	VARCHAR
24	server_deleted_at	VARCHAR
25	cid	INTEGER

Table: organizations_groups

No	Column Name	Type	Notes
1	at	VARCHAR
2	group_id	INTEGER
3	name	VARCHAR
4	workspaces	VARCHAR
5	users	VARCHAR

Table: time_entries

No	Column Name	Type	Notes
1	tag_ids	VARCHAR
2	start	VARCHAR
3	description	VARCHAR
4	pid	INTEGER
5	task_id	INTEGER
6	billable	BOOLEAN
7	tid	INTEGER
8	tags	VARCHAR
9	duration	INTEGER
10	workspace_id	INTEGER
11	uid	INTEGER
12	at	VARCHAR
13	wid	INTEGER
14	stop	VARCHAR
15	project_id	INTEGER
16	user_id	INTEGER
17	id	INTEGER
18	duronly	BOOLEAN
19	server_deleted_at	VARCHAR

External Resources

• Toggl Api
• Here

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.