Hellobaton

Tables in the Hellobaton connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	companies	6		Full Refresh
2	projects	25		Full Refresh
3	activity	13		Full Refresh
4	templates	18		Full Refresh
5	task_attachments	14		Full Refresh
6	project_attachments	11		Full Refresh
7	milestones	16		Full Refresh
8	time_entries	14		Full Refresh
9	users	13		Full Refresh
10	tasks	23		Full Refresh
11	phases	6		Full Refresh

Table: companies

No	Column Name	Type	Notes
1	created	VARCHAR
2	name	VARCHAR
3	modified	VARCHAR
4	id	INTEGER
5	_self	VARCHAR
6	type	VARCHAR

Table: projects

No	Column Name	Type	Notes
1	client_systems	VARCHAR
2	start_datetime	VARCHAR
3	created_from_template	VARCHAR
4	time_entry_list	VARCHAR
5	completed_datetime	VARCHAR
6	title	VARCHAR
7	companies	VARCHAR
8	risk_profiles	VARCHAR
9	modified	VARCHAR
10	_self	VARCHAR
11	id	INTEGER
12	deadline_datetime	VARCHAR
13	task_list	VARCHAR
14	phase	VARCHAR
15	creator	VARCHAR
16	milestone_list	VARCHAR
17	cost	INTEGER
18	attachment_list	VARCHAR
19	created	VARCHAR
20	estimated_duration	INTEGER
21	implementation_budget	VARCHAR
22	started_datetime	VARCHAR
23	annual_contract_value	VARCHAR
24	created_from	VARCHAR
25	status	VARCHAR

Table: activity

No	Column Name	Type	Notes
1	parent	VARCHAR
2	created	VARCHAR
3	project	VARCHAR
4	type	VARCHAR
5	parent_type	VARCHAR
6	actor	VARCHAR
7	meta	VARCHAR
8	modified	VARCHAR
9	id	INTEGER
10	_self	VARCHAR
11	child_type	VARCHAR
12	group	VARCHAR
13	child	VARCHAR

Table: templates

No	Column Name	Type	Notes
1	phase	VARCHAR
2	creator	VARCHAR
3	cost	VARCHAR
4	start_datetime	VARCHAR
5	client_systems	VARCHAR
6	created_from_template	VARCHAR
7	completed_datetime	VARCHAR
8	title	VARCHAR
9	estimated_duration	INTEGER
10	implementation_budget	VARCHAR
11	started_datetime	VARCHAR
12	annual_contract_value	VARCHAR
13	id	INTEGER
14	_self	VARCHAR
15	deadline_datetime	VARCHAR
16	task_list	VARCHAR
17	created_from	VARCHAR
18	status	VARCHAR

Table: task_attachments

No	Column Name	Type	Notes
1	revision_task	VARCHAR
2	created	VARCHAR
3	deliverable	BOOLEAN
4	label	VARCHAR
5	type	VARCHAR
6	created_by	VARCHAR
7	url	VARCHAR
8	requires_approval	BOOLEAN
9	approved	BOOLEAN
10	task	VARCHAR
11	original_filename	VARCHAR
12	modified	VARCHAR
13	id	INTEGER
14	_self	VARCHAR

Table: project_attachments

No	Column Name	Type	Notes
1	original_filename	VARCHAR
2	created	VARCHAR
3	is_sow	BOOLEAN
4	project	VARCHAR
5	modified	VARCHAR
6	id	INTEGER
7	_self	VARCHAR
8	label	VARCHAR
9	type	VARCHAR
10	created_by	VARCHAR
11	url	VARCHAR

Table: milestones

No	Column Name	Type	Notes
1	phase	VARCHAR
2	deadline_fixed	BOOLEAN
3	start_datetime	VARCHAR
4	created	VARCHAR
5	description	VARCHAR
6	project	VARCHAR
7	finish_datetime	VARCHAR
8	title	VARCHAR
9	duration	INTEGER
10	risk_profiles	VARCHAR
11	modified	VARCHAR
12	id	INTEGER
13	_self	VARCHAR
14	task_list	VARCHAR
15	deadline_datetime	VARCHAR
16	created_from	VARCHAR

Table: time_entries

No	Column Name	Type	Notes
1	notes	VARCHAR
2	project	VARCHAR
3	created_by	VARCHAR
4	billable	BOOLEAN
5	inputted_duration	INTEGER
6	task	VARCHAR
7	rate	VARCHAR
8	started_at	VARCHAR
9	id	INTEGER
10	_self	VARCHAR
11	reference_date	VARCHAR
12	calculated_duration	INTEGER
13	user	VARCHAR
14	ended_at	VARCHAR

Table: users

No	Column Name	Type	Notes
1	account_type	VARCHAR
2	signed_up_at	VARCHAR
3	created	VARCHAR
4	last_name	VARCHAR
5	created_by	VARCHAR
6	avatar_url	VARCHAR
7	modified	VARCHAR
8	company	VARCHAR
9	id	INTEGER
10	_self	VARCHAR
11	first_name	VARCHAR
12	job_title	VARCHAR
13	email	VARCHAR

Table: tasks

No	Column Name	Type	Notes
1	dependency	VARCHAR
2	start_datetime	VARCHAR
3	attachment_list	VARCHAR
4	created	VARCHAR
5	time_entry_list	VARCHAR
6	description	VARCHAR
7	project	VARCHAR
8	finished_datetime	VARCHAR
9	title	VARCHAR
10	estimated_duration	INTEGER
11	finished_overridden_datetime	VARCHAR
12	created_by	VARCHAR
13	due_datetime	VARCHAR
14	started_datetime	VARCHAR
15	milestone	VARCHAR
16	started_overridden_datetime	VARCHAR
17	risk_profiles	VARCHAR
18	modified	VARCHAR
19	id	INTEGER
20	_self	VARCHAR
21	created_from	VARCHAR
22	status	VARCHAR
23	assigned_to	VARCHAR

Table: phases

No	Column Name	Type	Notes
1	created	VARCHAR
2	name	VARCHAR
3	modified	VARCHAR
4	id	INTEGER
5	_self	VARCHAR
6	order	INTEGER

External Resources

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.