Harvest

Prerequisites

To set up the Harvest source connector, you'll need the Harvest Account ID and API key.

Setting up the Harvest connector

No	Item	Required	Example	Notes
1	Account ID	Yes		Harvest account ID. Required for all Harvest requests in pair with Personal Access Token
2	Start Date	Yes	2017-01-25T00:00:00Z	UTC date and time in the format 2017-01-25T00:00:00Z. Any data before this date will not be replicated.
3	End Date	No	2017-01-25T00:00:00Z	UTC date and time in the format 2017-01-25T00:00:00Z. Any data after this date will not be replicated.
4	Authentication mechanism	Yes		Choose how to authenticate to Harvest. Refer to the documentation in the form while using the connector Authenticate via Harvest (OAuth) Authenticate with Personal Access Token

Tables in the Harvest connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	invoice_payments	12		Full Refresh, Incremental	updated_at
2	projects	24		Full Refresh, Incremental	updated_at	API Reference
3	clients	8		Full Refresh, Incremental	updated_at	API Reference
4	expenses_categories	7		Full Refresh, Incremental	to
5	roles	5		Full Refresh, Incremental	updated_at	API Reference
6	billable_rates	7		Full Refresh
7	expenses_projects	9		Full Refresh, Incremental	to
8	invoice_item_categories	6		Full Refresh, Incremental	updated_at
9	expenses_team	8		Full Refresh, Incremental	to
10	invoices	33		Full Refresh, Incremental	updated_at	API Reference
11	user_assignments	10		Full Refresh, Incremental	updated_at
12	project_assignments	12		Full Refresh, Incremental	updated_at
13	invoice_messages	18		Full Refresh, Incremental	updated_at
14	expense_categories	7		Full Refresh, Incremental	updated_at
15	uninvoiced	11		Full Refresh
16	company	17		Full Refresh		API Reference
17	estimate_item_categories	4		Full Refresh, Incremental	updated_at
18	time_entries	28		Full Refresh, Incremental	updated_at
19	task_assignments	9		Full Refresh, Incremental	updated_at
20	tasks	8		Full Refresh, Incremental	updated_at	API Reference
21	time_projects	10		Full Refresh, Incremental	to
22	estimates	24		Full Refresh, Incremental	updated_at	API Reference
23	expenses_clients	7		Full Refresh, Incremental	to
24	time_team	9		Full Refresh, Incremental	to
25	time_tasks	8		Full Refresh, Incremental	to
26	users	23		Full Refresh, Incremental	updated_at
27	project_budget	12		Full Refresh
28	time_clients	8		Full Refresh, Incremental	to
29	cost_rates	7		Full Refresh
30	estimate_messages	13		Full Refresh, Incremental	updated_at
31	contacts	11		Full Refresh, Incremental	updated_at
32	expenses	19		Full Refresh, Incremental	updated_at	API Reference

Table: invoice_payments

No	Column Name	Type	Notes
1	paid_at	VARCHAR
2	transaction_id	VARCHAR
3	amount	DOUBLE
4	notes	VARCHAR
5	recorded_by_email	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	recorded_by	VARCHAR
8	payment_gateway	VARCHAR
9	parent_id	INTEGER
10	created_at	VARCHAR
11	id	INTEGER
12	paid_date	VARCHAR

Table: projects

No	Column Name	Type	Notes
1	budget_by	VARCHAR
2	cost_budget_include_expenses	BOOLEAN
3	code	VARCHAR
4	is_active	BOOLEAN
5	notes	VARCHAR
6	budget_is_monthly	BOOLEAN
7	ends_on	VARCHAR
8	fee	DOUBLE
9	created_at	VARCHAR
10	is_billable	BOOLEAN
11	is_fixed_fee	BOOLEAN
12	cost_budget	DOUBLE
13	over_budget_notification_percentage	DOUBLE
14	starts_on	VARCHAR
15	show_budget_to_all	BOOLEAN
16	updated_at	VARCHAR	Incremental sync key
17	hourly_rate	DOUBLE
18	name	VARCHAR
19	client	VARCHAR
20	notify_when_over_budget	BOOLEAN
21	id	INTEGER
22	bill_by	VARCHAR
23	over_budget_notification_date	VARCHAR
24	budget	DOUBLE

Table: clients

No	Column Name	Type	Notes
1	is_active	BOOLEAN
2	address	VARCHAR
3	updated_at	VARCHAR	Incremental sync key
4	name	VARCHAR
5	created_at	VARCHAR
6	currency	VARCHAR
7	id	INTEGER
8	statement_key	VARCHAR

Table: expenses_categories

No	Column Name	Type	Notes
1	expense_category_name	VARCHAR
2	total_amount	DOUBLE
3	billable_amount	DOUBLE
4	currency	VARCHAR
5	from	VARCHAR
6	to	VARCHAR	Incremental sync key
7	expense_category_id	INTEGER

Table: roles

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	user_ids	VARCHAR
3	name	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER

Table: billable_rates

No	Column Name	Type	Notes
1	end_date	VARCHAR
2	amount	DOUBLE
3	updated_at	VARCHAR
4	parent_id	INTEGER
5	created_at	VARCHAR
6	id	INTEGER
7	start_date	VARCHAR

Table: expenses_projects

No	Column Name	Type	Notes
1	project_id	INTEGER
2	total_amount	DOUBLE
3	billable_amount	DOUBLE
4	currency	VARCHAR
5	from	VARCHAR
6	to	VARCHAR	Incremental sync key
7	project_name	VARCHAR
8	client_name	VARCHAR
9	client_id	INTEGER

Table: invoice_item_categories

No	Column Name	Type	Notes
1	use_as_expense	BOOLEAN
2	use_as_service	BOOLEAN
3	updated_at	VARCHAR	Incremental sync key
4	name	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER

Table: expenses_team

No	Column Name	Type	Notes
1	is_contractor	BOOLEAN
2	user_id	INTEGER
3	total_amount	DOUBLE
4	billable_amount	DOUBLE
5	user_name	VARCHAR
6	currency	VARCHAR
7	from	VARCHAR
8	to	VARCHAR	Incremental sync key

Table: invoices

No	Column Name	Type	Notes
1	tax_amount	DOUBLE
2	notes	VARCHAR
3	discount_amount	DOUBLE
4	subject	VARCHAR
5	discount	DOUBLE
6	created_at	VARCHAR
7	line_items	VARCHAR
8	client_key	VARCHAR
9	number	VARCHAR
10	tax2	DOUBLE
11	issue_date	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	period_start	VARCHAR
14	estimate	VARCHAR
15	client	VARCHAR
16	currency	VARCHAR
17	id	INTEGER
18	state	VARCHAR
19	tax2_amount	DOUBLE
20	recurring_invoice_id	VARCHAR
21	amount	DOUBLE
22	creator	VARCHAR
23	closed_at	VARCHAR
24	payment_term	VARCHAR
25	retainer	VARCHAR
26	due_date	VARCHAR
27	tax	DOUBLE
28	period_end	VARCHAR
29	sent_at	VARCHAR
30	paid_at	VARCHAR
31	due_amount	DOUBLE
32	purchase_order	VARCHAR
33	paid_date	VARCHAR

Table: user_assignments

No	Column Name	Type	Notes
1	is_project_manager	BOOLEAN
2	is_active	BOOLEAN
3	updated_at	VARCHAR	Incremental sync key
4	use_default_rates	BOOLEAN
5	hourly_rate	DOUBLE
6	created_at	VARCHAR
7	project	VARCHAR
8	id	INTEGER
9	user	VARCHAR
10	budget	DOUBLE

Table: project_assignments

No	Column Name	Type	Notes
1	is_project_manager	BOOLEAN
2	is_active	BOOLEAN
3	updated_at	VARCHAR	Incremental sync key
4	use_default_rates	BOOLEAN
5	parent_id	INTEGER
6	hourly_rate	DOUBLE
7	created_at	VARCHAR
8	project	VARCHAR
9	client	VARCHAR
10	id	INTEGER
11	task_assignments	VARCHAR
12	budget	DOUBLE

Table: invoice_messages

No	Column Name	Type	Notes
1	include_link_to_client_invoice	BOOLEAN
2	reminder	BOOLEAN
3	subject	VARCHAR
4	created_at	VARCHAR
5	attach_pdf	BOOLEAN
6	body	VARCHAR
7	sent_from_email	VARCHAR
8	sent_from	VARCHAR
9	send_reminder_on	VARCHAR
10	event_type	VARCHAR
11	sent_by	VARCHAR
12	thank_you	BOOLEAN
13	updated_at	VARCHAR	Incremental sync key
14	parent_id	INTEGER
15	recipients	VARCHAR
16	id	INTEGER
17	send_me_a_copy	BOOLEAN
18	sent_by_email	VARCHAR

Table: expense_categories

No	Column Name	Type	Notes
1	unit_name	VARCHAR
2	is_active	BOOLEAN
3	updated_at	VARCHAR	Incremental sync key
4	name	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER
7	unit_price	DOUBLE

Table: uninvoiced

No	Column Name	Type	Notes
1	uninvoiced_expenses	DOUBLE
2	project_id	INTEGER
3	uninvoiced_hours	DOUBLE
4	currency	VARCHAR
5	from	VARCHAR
6	to	VARCHAR
7	project_name	VARCHAR
8	total_hours	DOUBLE
9	client_name	VARCHAR
10	uninvoiced_amount	DOUBLE
11	client_id	INTEGER

Table: company

No	Column Name	Type	Notes
1	thousands_separator	VARCHAR
2	estimate_feature	BOOLEAN
3	plan_type	VARCHAR
4	is_active	BOOLEAN
5	time_format	VARCHAR
6	weekly_capacity	INTEGER
7	full_domain	VARCHAR
8	week_start_day	VARCHAR
9	approval_required	BOOLEAN
10	expense_feature	BOOLEAN
11	clock	VARCHAR
12	decimal_symbol	VARCHAR
13	base_uri	VARCHAR
14	name	VARCHAR
15	invoice_feature	BOOLEAN
16	color_scheme	VARCHAR
17	wants_timestamp_timers	BOOLEAN

Table: estimate_item_categories

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	name	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER

Table: time_entries

No	Column Name	Type	Notes
1	user_assignment	VARCHAR
2	is_locked	BOOLEAN
3	rounded_hours	DOUBLE
4	locked_reason	VARCHAR
5	notes	VARCHAR
6	is_billed	BOOLEAN
7	project	VARCHAR
8	created_at	VARCHAR
9	budgeted	BOOLEAN
10	spent_date	VARCHAR
11	timer_started_at	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	external_reference	VARCHAR
14	client	VARCHAR
15	id	INTEGER
16	task_assignment	VARCHAR
17	hours_without_timer	DOUBLE
18	is_closed	BOOLEAN
19	hours	DOUBLE
20	started_time	VARCHAR
21	billable	BOOLEAN
22	is_running	BOOLEAN
23	task	VARCHAR
24	ended_time	VARCHAR
25	billable_rate	DOUBLE
26	cost_rate	DOUBLE
27	invoice	VARCHAR
28	user	VARCHAR

Table: task_assignments

No	Column Name	Type	Notes
1	is_active	BOOLEAN
2	task	VARCHAR
3	updated_at	VARCHAR	Incremental sync key
4	hourly_rate	DOUBLE
5	created_at	VARCHAR
6	project	VARCHAR
7	id	INTEGER
8	billable	BOOLEAN
9	budget	VARCHAR

Table: tasks

No	Column Name	Type	Notes
1	is_active	BOOLEAN
2	updated_at	VARCHAR	Incremental sync key
3	billable_by_default	BOOLEAN
4	name	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER
7	default_hourly_rate	DOUBLE
8	is_default	BOOLEAN

Table: time_projects

No	Column Name	Type	Notes
1	project_id	INTEGER
2	billable_amount	DOUBLE
3	billable_hours	DOUBLE
4	currency	VARCHAR
5	from	VARCHAR
6	to	VARCHAR	Incremental sync key
7	project_name	VARCHAR
8	total_hours	DOUBLE
9	client_name	VARCHAR
10	client_id	INTEGER

Table: estimates

No	Column Name	Type	Notes
1	tax_amount	DOUBLE
2	amount	DOUBLE
3	declined_at	VARCHAR
4	creator	VARCHAR
5	notes	VARCHAR
6	discount_amount	DOUBLE
7	subject	VARCHAR
8	discount	DOUBLE
9	created_at	VARCHAR
10	tax	DOUBLE
11	line_items	VARCHAR
12	accepted_at	VARCHAR
13	sent_at	VARCHAR
14	client_key	VARCHAR
15	number	VARCHAR
16	tax2	DOUBLE
17	issue_date	VARCHAR
18	updated_at	VARCHAR	Incremental sync key
19	purchase_order	VARCHAR
20	client	VARCHAR
21	currency	VARCHAR
22	id	INTEGER
23	state	VARCHAR
24	tax2_amount	DOUBLE

Table: expenses_clients

No	Column Name	Type	Notes
1	total_amount	DOUBLE
2	billable_amount	DOUBLE
3	currency	VARCHAR
4	from	VARCHAR
5	to	VARCHAR	Incremental sync key
6	client_name	VARCHAR
7	client_id	INTEGER

Table: time_team

No	Column Name	Type	Notes
1	is_contractor	BOOLEAN
2	user_id	INTEGER
3	billable_amount	DOUBLE
4	user_name	VARCHAR
5	billable_hours	DOUBLE
6	currency	VARCHAR
7	from	VARCHAR
8	to	VARCHAR	Incremental sync key
9	total_hours	DOUBLE

Table: time_tasks

No	Column Name	Type	Notes
1	task_name	VARCHAR
2	billable_amount	DOUBLE
3	billable_hours	DOUBLE
4	task_id	INTEGER
5	currency	VARCHAR
6	from	VARCHAR
7	to	VARCHAR	Incremental sync key
8	total_hours	DOUBLE

Table: users

No	Column Name	Type	Notes
1	can_create_invoices	BOOLEAN
2	can_see_rates	BOOLEAN
3	is_active	BOOLEAN
4	weekly_capacity	INTEGER
5	timezone	VARCHAR
6	roles	VARCHAR
7	last_name	VARCHAR
8	created_at	VARCHAR
9	telephone	VARCHAR
10	calendar_integration_source	VARCHAR
11	can_create_projects	BOOLEAN
12	has_access_to_all_future_projects	BOOLEAN
13	is_admin	BOOLEAN
14	is_project_manager	BOOLEAN
15	is_contractor	BOOLEAN
16	updated_at	VARCHAR	Incremental sync key
17	avatar_url	VARCHAR
18	calendar_integration_enabled	BOOLEAN
19	cost_rate	DOUBLE
20	id	INTEGER
21	default_hourly_rate	DOUBLE
22	first_name	VARCHAR
23	email	VARCHAR

Table: project_budget

No	Column Name	Type	Notes
1	budget_by	VARCHAR
2	is_active	BOOLEAN
3	project_id	INTEGER
4	budget_remaining	DOUBLE
5	budget_is_monthly	BOOLEAN
6	budget_spent	DOUBLE
7	from	VARCHAR
8	to	VARCHAR
9	project_name	VARCHAR
10	client_name	VARCHAR
11	client_id	INTEGER
12	budget	DOUBLE

Table: time_clients

No	Column Name	Type	Notes
1	billable_amount	DOUBLE
2	billable_hours	DOUBLE
3	currency	VARCHAR
4	from	VARCHAR
5	to	VARCHAR	Incremental sync key
6	total_hours	DOUBLE
7	client_name	VARCHAR
8	client_id	INTEGER

Table: cost_rates

No	Column Name	Type	Notes
1	end_date	VARCHAR
2	amount	DOUBLE
3	updated_at	VARCHAR
4	parent_id	INTEGER
5	created_at	VARCHAR
6	id	INTEGER
7	start_date	VARCHAR

Table: estimate_messages

No	Column Name	Type	Notes
1	subject	VARCHAR
2	created_at	VARCHAR
3	body	VARCHAR
4	sent_from_email	VARCHAR
5	sent_from	VARCHAR
6	event_type	VARCHAR
7	sent_by	VARCHAR
8	updated_at	VARCHAR	Incremental sync key
9	parent_id	INTEGER
10	recipients	VARCHAR
11	id	INTEGER
12	send_me_a_copy	BOOLEAN
13	sent_by_email	VARCHAR

Table: contacts

No	Column Name	Type	Notes
1	phone_mobile	VARCHAR
2	phone_office	VARCHAR
3	updated_at	VARCHAR	Incremental sync key
4	last_name	VARCHAR
5	created_at	VARCHAR
6	client	VARCHAR
7	id	INTEGER
8	title	VARCHAR
9	fax	VARCHAR
10	first_name	VARCHAR
11	email	VARCHAR

Table: expenses

No	Column Name	Type	Notes
1	is_locked	BOOLEAN
2	user_assignment	VARCHAR
3	locked_reason	VARCHAR
4	notes	VARCHAR
5	total_cost	DOUBLE
6	is_billed	BOOLEAN
7	created_at	VARCHAR
8	project	VARCHAR
9	units	DOUBLE
10	billable	BOOLEAN
11	spent_date	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	expense_category	VARCHAR
14	client	VARCHAR
15	receipt	VARCHAR
16	id	INTEGER
17	invoice	VARCHAR
18	user	VARCHAR
19	is_closed	BOOLEAN

External Resources

• Harvest Account Id And Api Key
• Harvest Account Id
• Personal Access Token
• Client Contacts
• Invoice Messages
• Invoice Payments
• Invoice Item Categories
• Estimate Messages
• Estimate Item Categories
• Expense Categories
• Time Entries
• Project User Assignments
• Project Task Assignments
• User Billable Rates
• User Cost Rates
• User Project Assignments
• Expense Reports
• Uninvoiced Report
• Time Reports
• Project Budget Report
• Harvest Rate Limits

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.