Harvest Connector Reference

109 metrics291 dimensions

Fields

The Harvest connector exposes 400 fields (109 metrics, 291 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Harvest Fields

Harvest billable_rates fields

The billable_rates report of the Harvest connector includes 7 fields.

ID	Type	Name	Description
billable_rates__amount	NUMERIC	billable_rates.amount	billable_rates.amount
billable_rates__created_at	TEXT	billable_rates.created_at	billable_rates.created_at
billable_rates__end_date	TEXT	billable_rates.end_date	billable_rates.end_date
billable_rates__id	NUMERIC	billable_rates.id	billable_rates.id
billable_rates__parent_id	NUMERIC	billable_rates.parent_id	billable_rates.parent_id
billable_rates__start_date	TEXT	billable_rates.start_date	billable_rates.start_date
billable_rates__updated_at	TEXT	billable_rates.updated_at	billable_rates.updated_at

Harvest clients fields

The clients report of the Harvest connector includes 8 fields.

ID	Type	Name	Description
clients__address	TEXT	clients.address	clients.address
clients__created_at	TEXT	clients.created_at	clients.created_at
clients__currency	TEXT	clients.currency	clients.currency
clients__id	NUMERIC	clients.id	clients.id
clients__is_active	BOOLEAN	clients.is_active	clients.is_active
clients__name	TEXT	clients.name	clients.name
clients__statement_key	TEXT	clients.statement_key	clients.statement_key
clients__updated_at	TEXT	clients.updated_at	clients.updated_at

Harvest company fields

The company report of the Harvest connector includes 17 fields.

ID	Type	Name	Description
company__approval_required	BOOLEAN	company.approval_required	company.approval_required
company__base_uri	TEXT	company.base_uri	company.base_uri
company__clock	TEXT	company.clock	company.clock
company__color_scheme	TEXT	company.color_scheme	company.color_scheme
company__decimal_symbol	TEXT	company.decimal_symbol	company.decimal_symbol
company__estimate_feature	BOOLEAN	company.estimate_feature	company.estimate_feature
company__expense_feature	BOOLEAN	company.expense_feature	company.expense_feature
company__full_domain	TEXT	company.full_domain	company.full_domain
company__invoice_feature	BOOLEAN	company.invoice_feature	company.invoice_feature
company__is_active	BOOLEAN	company.is_active	company.is_active
company__name	TEXT	company.name	company.name
company__plan_type	TEXT	company.plan_type	company.plan_type
company__thousands_separator	TEXT	company.thousands_separator	company.thousands_separator
company__time_format	TEXT	company.time_format	company.time_format
company__wants_timestamp_timers	BOOLEAN	company.wants_timestamp_timers	company.wants_timestamp_timers
company__week_start_day	TEXT	company.week_start_day	company.week_start_day
company__weekly_capacity	NUMERIC	company.weekly_capacity	company.weekly_capacity

Harvest contacts fields

The contacts report of the Harvest connector includes 11 fields.

ID	Type	Name	Description
contacts__client	OBJECT	contacts.client	contacts.client
contacts__created_at	TEXT	contacts.created_at	contacts.created_at
contacts__email	TEXT	contacts.email	contacts.email
contacts__fax	TEXT	contacts.fax	contacts.fax
contacts__first_name	TEXT	contacts.first_name	contacts.first_name
contacts__id	NUMERIC	contacts.id	contacts.id
contacts__last_name	TEXT	contacts.last_name	contacts.last_name
contacts__phone_mobile	TEXT	contacts.phone_mobile	contacts.phone_mobile
contacts__phone_office	TEXT	contacts.phone_office	contacts.phone_office
contacts__title	TEXT	contacts.title	contacts.title
contacts__updated_at	TEXT	contacts.updated_at	contacts.updated_at

Harvest cost_rates fields

The cost_rates report of the Harvest connector includes 7 fields.

ID	Type	Name	Description
cost_rates__amount	NUMERIC	cost_rates.amount	cost_rates.amount
cost_rates__created_at	TEXT	cost_rates.created_at	cost_rates.created_at
cost_rates__end_date	TEXT	cost_rates.end_date	cost_rates.end_date
cost_rates__id	NUMERIC	cost_rates.id	cost_rates.id
cost_rates__parent_id	NUMERIC	cost_rates.parent_id	cost_rates.parent_id
cost_rates__start_date	TEXT	cost_rates.start_date	cost_rates.start_date
cost_rates__updated_at	TEXT	cost_rates.updated_at	cost_rates.updated_at

Harvest estimate_item_categories fields

The estimate_item_categories report of the Harvest connector includes 4 fields.

ID	Type	Name	Description
estimate_item_categories__created_at	TEXT	estimate_item_categories.created_at	estimate_item_categories.created_at
estimate_item_categories__id	NUMERIC	estimate_item_categories.id	estimate_item_categories.id
estimate_item_categories__name	TEXT	estimate_item_categories.name	estimate_item_categories.name
estimate_item_categories__updated_at	TEXT	estimate_item_categories.updated_at	estimate_item_categories.updated_at

Harvest estimate_messages fields

The estimate_messages report of the Harvest connector includes 13 fields.

ID	Type	Name	Description
estimate_messages__body	TEXT	estimate_messages.body	estimate_messages.body
estimate_messages__created_at	TEXT	estimate_messages.created_at	estimate_messages.created_at
estimate_messages__event_type	TEXT	estimate_messages.event_type	estimate_messages.event_type
estimate_messages__id	NUMERIC	estimate_messages.id	estimate_messages.id
estimate_messages__parent_id	NUMERIC	estimate_messages.parent_id	estimate_messages.parent_id
estimate_messages__recipients	OBJECT	estimate_messages.recipients	estimate_messages.recipients
estimate_messages__send_me_a_copy	BOOLEAN	estimate_messages.send_me_a_copy	estimate_messages.send_me_a_copy
estimate_messages__sent_by	TEXT	estimate_messages.sent_by	estimate_messages.sent_by
estimate_messages__sent_by_email	TEXT	estimate_messages.sent_by_email	estimate_messages.sent_by_email
estimate_messages__sent_from	TEXT	estimate_messages.sent_from	estimate_messages.sent_from
estimate_messages__sent_from_email	TEXT	estimate_messages.sent_from_email	estimate_messages.sent_from_email
estimate_messages__subject	TEXT	estimate_messages.subject	estimate_messages.subject
estimate_messages__updated_at	TEXT	estimate_messages.updated_at	estimate_messages.updated_at

Harvest estimates fields

The estimates report of the Harvest connector includes 24 fields.

ID	Type	Name	Description
estimates__accepted_at	TEXT	estimates.accepted_at	estimates.accepted_at
estimates__amount	NUMERIC	estimates.amount	estimates.amount
estimates__client	OBJECT	estimates.client	estimates.client
estimates__client_key	TEXT	estimates.client_key	estimates.client_key
estimates__created_at	TEXT	estimates.created_at	estimates.created_at
estimates__creator	OBJECT	estimates.creator	estimates.creator
estimates__currency	TEXT	estimates.currency	estimates.currency
estimates__declined_at	TEXT	estimates.declined_at	estimates.declined_at
estimates__discount	NUMERIC	estimates.discount	estimates.discount
estimates__discount_amount	NUMERIC	estimates.discount_amount	estimates.discount_amount
estimates__id	NUMERIC	estimates.id	estimates.id
estimates__issue_date	TEXT	estimates.issue_date	estimates.issue_date
estimates__line_items	OBJECT	estimates.line_items	estimates.line_items
estimates__notes	TEXT	estimates.notes	estimates.notes
estimates__number	TEXT	estimates.number	estimates.number
estimates__purchase_order	TEXT	estimates.purchase_order	estimates.purchase_order
estimates__sent_at	TEXT	estimates.sent_at	estimates.sent_at
estimates__state	TEXT	estimates.state	estimates.state
estimates__subject	TEXT	estimates.subject	estimates.subject
estimates__tax	NUMERIC	estimates.tax	estimates.tax
estimates__tax2	NUMERIC	estimates.tax2	estimates.tax2
estimates__tax2_amount	NUMERIC	estimates.tax2_amount	estimates.tax2_amount
estimates__tax_amount	NUMERIC	estimates.tax_amount	estimates.tax_amount
estimates__updated_at	TEXT	estimates.updated_at	estimates.updated_at

Harvest expense_categories fields

The expense_categories report of the Harvest connector includes 7 fields.

ID	Type	Name	Description
expense_categories__created_at	TEXT	expense_categories.created_at	expense_categories.created_at
expense_categories__id	NUMERIC	expense_categories.id	expense_categories.id
expense_categories__is_active	BOOLEAN	expense_categories.is_active	expense_categories.is_active
expense_categories__name	TEXT	expense_categories.name	expense_categories.name
expense_categories__unit_name	TEXT	expense_categories.unit_name	expense_categories.unit_name
expense_categories__unit_price	NUMERIC	expense_categories.unit_price	expense_categories.unit_price
expense_categories__updated_at	TEXT	expense_categories.updated_at	expense_categories.updated_at

Harvest expenses fields

The expenses report of the Harvest connector includes 19 fields.

ID	Type	Name	Description
expenses__billable	BOOLEAN	expenses.billable	expenses.billable
expenses__client	OBJECT	expenses.client	expenses.client
expenses__created_at	TEXT	expenses.created_at	expenses.created_at
expenses__expense_category	OBJECT	expenses.expense_category	expenses.expense_category
expenses__id	NUMERIC	expenses.id	expenses.id
expenses__invoice	OBJECT	expenses.invoice	expenses.invoice
expenses__is_billed	BOOLEAN	expenses.is_billed	expenses.is_billed
expenses__is_closed	BOOLEAN	expenses.is_closed	expenses.is_closed
expenses__is_locked	BOOLEAN	expenses.is_locked	expenses.is_locked
expenses__locked_reason	TEXT	expenses.locked_reason	expenses.locked_reason
expenses__notes	TEXT	expenses.notes	expenses.notes
expenses__project	OBJECT	expenses.project	expenses.project
expenses__receipt	OBJECT	expenses.receipt	expenses.receipt
expenses__spent_date	TEXT	expenses.spent_date	expenses.spent_date
expenses__total_cost	NUMERIC	expenses.total_cost	expenses.total_cost
expenses__units	NUMERIC	expenses.units	expenses.units
expenses__updated_at	TEXT	expenses.updated_at	expenses.updated_at
expenses__user	OBJECT	expenses.user	expenses.user
expenses__user_assignment	OBJECT	expenses.user_assignment	expenses.user_assignment

Harvest expenses_categories fields

The expenses_categories report of the Harvest connector includes 7 fields.

ID	Type	Name	Description
expenses_categories__billable_amount	NUMERIC	expenses_categories.billable_amount	expenses_categories.billable_amount
expenses_categories__currency	TEXT	expenses_categories.currency	expenses_categories.currency
expenses_categories__expense_category_id	NUMERIC	expenses_categories.expense_category_id	expenses_categories.expense_category_id
expenses_categories__expense_category_name	TEXT	expenses_categories.expense_category_name	expenses_categories.expense_category_name
expenses_categories__from	TEXT	expenses_categories.from	expenses_categories.from
expenses_categories__to	TEXT	expenses_categories.to	expenses_categories.to
expenses_categories__total_amount	NUMERIC	expenses_categories.total_amount	expenses_categories.total_amount

Harvest expenses_clients fields

The expenses_clients report of the Harvest connector includes 7 fields.

ID	Type	Name	Description
expenses_clients__billable_amount	NUMERIC	expenses_clients.billable_amount	expenses_clients.billable_amount
expenses_clients__client_id	NUMERIC	expenses_clients.client_id	expenses_clients.client_id
expenses_clients__client_name	TEXT	expenses_clients.client_name	expenses_clients.client_name
expenses_clients__currency	TEXT	expenses_clients.currency	expenses_clients.currency
expenses_clients__from	TEXT	expenses_clients.from	expenses_clients.from
expenses_clients__to	TEXT	expenses_clients.to	expenses_clients.to
expenses_clients__total_amount	NUMERIC	expenses_clients.total_amount	expenses_clients.total_amount

Harvest expenses_projects fields

The expenses_projects report of the Harvest connector includes 9 fields.

ID	Type	Name	Description
expenses_projects__billable_amount	NUMERIC	expenses_projects.billable_amount	expenses_projects.billable_amount
expenses_projects__client_id	NUMERIC	expenses_projects.client_id	expenses_projects.client_id
expenses_projects__client_name	TEXT	expenses_projects.client_name	expenses_projects.client_name
expenses_projects__currency	TEXT	expenses_projects.currency	expenses_projects.currency
expenses_projects__from	TEXT	expenses_projects.from	expenses_projects.from
expenses_projects__project_id	NUMERIC	expenses_projects.project_id	expenses_projects.project_id
expenses_projects__project_name	TEXT	expenses_projects.project_name	expenses_projects.project_name
expenses_projects__to	TEXT	expenses_projects.to	expenses_projects.to
expenses_projects__total_amount	NUMERIC	expenses_projects.total_amount	expenses_projects.total_amount

Harvest expenses_team fields

The expenses_team report of the Harvest connector includes 8 fields.

ID	Type	Name	Description
expenses_team__billable_amount	NUMERIC	expenses_team.billable_amount	expenses_team.billable_amount
expenses_team__currency	TEXT	expenses_team.currency	expenses_team.currency
expenses_team__from	TEXT	expenses_team.from	expenses_team.from
expenses_team__is_contractor	BOOLEAN	expenses_team.is_contractor	expenses_team.is_contractor
expenses_team__to	TEXT	expenses_team.to	expenses_team.to
expenses_team__total_amount	NUMERIC	expenses_team.total_amount	expenses_team.total_amount
expenses_team__user_id	NUMERIC	expenses_team.user_id	expenses_team.user_id
expenses_team__user_name	TEXT	expenses_team.user_name	expenses_team.user_name

Harvest invoice_item_categories fields

The invoice_item_categories report of the Harvest connector includes 6 fields.

ID	Type	Name	Description
invoice_item_categories__created_at	TEXT	invoice_item_categories.created_at	invoice_item_categories.created_at
invoice_item_categories__id	NUMERIC	invoice_item_categories.id	invoice_item_categories.id
invoice_item_categories__name	TEXT	invoice_item_categories.name	invoice_item_categories.name
invoice_item_categories__updated_at	TEXT	invoice_item_categories.updated_at	invoice_item_categories.updated_at
invoice_item_categories__use_as_expense	BOOLEAN	invoice_item_categories.use_as_expense	invoice_item_categories.use_as_expense
invoice_item_categories__use_as_service	BOOLEAN	invoice_item_categories.use_as_service	invoice_item_categories.use_as_service

Harvest invoice_messages fields

The invoice_messages report of the Harvest connector includes 18 fields.

ID	Type	Name	Description
invoice_messages__attach_pdf	BOOLEAN	invoice_messages.attach_pdf	invoice_messages.attach_pdf
invoice_messages__body	TEXT	invoice_messages.body	invoice_messages.body
invoice_messages__created_at	TEXT	invoice_messages.created_at	invoice_messages.created_at
invoice_messages__event_type	TEXT	invoice_messages.event_type	invoice_messages.event_type
invoice_messages__id	NUMERIC	invoice_messages.id	invoice_messages.id
invoice_messages__include_link_to_client_invoice	BOOLEAN	invoice_messages.include_link_to_client_invoice	invoice_messages.include_link_to_client_invoice
invoice_messages__parent_id	NUMERIC	invoice_messages.parent_id	invoice_messages.parent_id
invoice_messages__recipients	OBJECT	invoice_messages.recipients	invoice_messages.recipients
invoice_messages__reminder	BOOLEAN	invoice_messages.reminder	invoice_messages.reminder
invoice_messages__send_me_a_copy	BOOLEAN	invoice_messages.send_me_a_copy	invoice_messages.send_me_a_copy
invoice_messages__send_reminder_on	TEXT	invoice_messages.send_reminder_on	invoice_messages.send_reminder_on
invoice_messages__sent_by	TEXT	invoice_messages.sent_by	invoice_messages.sent_by
invoice_messages__sent_by_email	TEXT	invoice_messages.sent_by_email	invoice_messages.sent_by_email
invoice_messages__sent_from	TEXT	invoice_messages.sent_from	invoice_messages.sent_from
invoice_messages__sent_from_email	TEXT	invoice_messages.sent_from_email	invoice_messages.sent_from_email
invoice_messages__subject	TEXT	invoice_messages.subject	invoice_messages.subject
invoice_messages__thank_you	BOOLEAN	invoice_messages.thank_you	invoice_messages.thank_you
invoice_messages__updated_at	TEXT	invoice_messages.updated_at	invoice_messages.updated_at

Harvest invoice_payments fields

The invoice_payments report of the Harvest connector includes 12 fields.

ID	Type	Name	Description
invoice_payments__amount	NUMERIC	invoice_payments.amount	invoice_payments.amount
invoice_payments__created_at	TEXT	invoice_payments.created_at	invoice_payments.created_at
invoice_payments__id	NUMERIC	invoice_payments.id	invoice_payments.id
invoice_payments__notes	TEXT	invoice_payments.notes	invoice_payments.notes
invoice_payments__paid_at	TEXT	invoice_payments.paid_at	invoice_payments.paid_at
invoice_payments__paid_date	TEXT	invoice_payments.paid_date	invoice_payments.paid_date
invoice_payments__parent_id	NUMERIC	invoice_payments.parent_id	invoice_payments.parent_id
invoice_payments__payment_gateway	OBJECT	invoice_payments.payment_gateway	invoice_payments.payment_gateway
invoice_payments__recorded_by	TEXT	invoice_payments.recorded_by	invoice_payments.recorded_by
invoice_payments__recorded_by_email	TEXT	invoice_payments.recorded_by_email	invoice_payments.recorded_by_email
invoice_payments__transaction_id	TEXT	invoice_payments.transaction_id	invoice_payments.transaction_id
invoice_payments__updated_at	TEXT	invoice_payments.updated_at	invoice_payments.updated_at

Harvest invoices fields

The invoices report of the Harvest connector includes 34 fields.

ID	Type	Name	Description
invoices__amount	NUMERIC	invoices.amount	invoices.amount
invoices__client	OBJECT	invoices.client	invoices.client
invoices__client_key	TEXT	invoices.client_key	invoices.client_key
invoices__closed_at	TEXT	invoices.closed_at	invoices.closed_at
invoices__created_at	TEXT	invoices.created_at	invoices.created_at
invoices__creator	OBJECT	invoices.creator	invoices.creator
invoices__currency	TEXT	invoices.currency	invoices.currency
invoices__discount	NUMERIC	invoices.discount	invoices.discount
invoices__discount_amount	NUMERIC	invoices.discount_amount	invoices.discount_amount
invoices__due_amount	NUMERIC	invoices.due_amount	invoices.due_amount
invoices__due_date	TEXT	invoices.due_date	invoices.due_date
invoices__estimate	TEXT	invoices.estimate	invoices.estimate
invoices__id	NUMERIC	invoices.id	invoices.id
invoices__issue_date	TEXT	invoices.issue_date	invoices.issue_date
invoices__line_items	OBJECT	invoices.line_items	invoices.line_items
invoices__notes	TEXT	invoices.notes	invoices.notes
invoices__number	TEXT	invoices.number	invoices.number
invoices__paid_at	TEXT	invoices.paid_at	invoices.paid_at
invoices__paid_date	TEXT	invoices.paid_date	invoices.paid_date
invoices__payment_options	OBJECT	invoices.payment_options	invoices.payment_options
invoices__payment_term	TEXT	invoices.payment_term	invoices.payment_term
invoices__period_end	TEXT	invoices.period_end	invoices.period_end
invoices__period_start	TEXT	invoices.period_start	invoices.period_start
invoices__purchase_order	TEXT	invoices.purchase_order	invoices.purchase_order
invoices__recurring_invoice_id	TEXT	invoices.recurring_invoice_id	invoices.recurring_invoice_id
invoices__retainer	TEXT	invoices.retainer	invoices.retainer
invoices__sent_at	TEXT	invoices.sent_at	invoices.sent_at
invoices__state	TEXT	invoices.state	invoices.state
invoices__subject	TEXT	invoices.subject	invoices.subject
invoices__tax	NUMERIC	invoices.tax	invoices.tax
invoices__tax2	NUMERIC	invoices.tax2	invoices.tax2
invoices__tax2_amount	NUMERIC	invoices.tax2_amount	invoices.tax2_amount
invoices__tax_amount	NUMERIC	invoices.tax_amount	invoices.tax_amount
invoices__updated_at	TEXT	invoices.updated_at	invoices.updated_at

Harvest project_assignments fields

The project_assignments report of the Harvest connector includes 12 fields.

ID	Type	Name	Description
project_assignments__budget	NUMERIC	project_assignments.budget	project_assignments.budget
project_assignments__client	OBJECT	project_assignments.client	project_assignments.client
project_assignments__created_at	TEXT	project_assignments.created_at	project_assignments.created_at
project_assignments__hourly_rate	NUMERIC	project_assignments.hourly_rate	project_assignments.hourly_rate
project_assignments__id	NUMERIC	project_assignments.id	project_assignments.id
project_assignments__is_active	BOOLEAN	project_assignments.is_active	project_assignments.is_active
project_assignments__is_project_manager	BOOLEAN	project_assignments.is_project_manager	project_assignments.is_project_manager
project_assignments__parent_id	NUMERIC	project_assignments.parent_id	project_assignments.parent_id
project_assignments__project	OBJECT	project_assignments.project	project_assignments.project
project_assignments__task_assignments	OBJECT	project_assignments.task_assignments	project_assignments.task_assignments
project_assignments__updated_at	TEXT	project_assignments.updated_at	project_assignments.updated_at
project_assignments__use_default_rates	BOOLEAN	project_assignments.use_default_rates	project_assignments.use_default_rates

Harvest project_budget fields

The project_budget report of the Harvest connector includes 12 fields.

ID	Type	Name	Description
project_budget__budget	NUMERIC	project_budget.budget	project_budget.budget
project_budget__budget_by	TEXT	project_budget.budget_by	project_budget.budget_by
project_budget__budget_is_monthly	BOOLEAN	project_budget.budget_is_monthly	project_budget.budget_is_monthly
project_budget__budget_remaining	NUMERIC	project_budget.budget_remaining	project_budget.budget_remaining
project_budget__budget_spent	NUMERIC	project_budget.budget_spent	project_budget.budget_spent
project_budget__client_id	NUMERIC	project_budget.client_id	project_budget.client_id
project_budget__client_name	TEXT	project_budget.client_name	project_budget.client_name
project_budget__from	TEXT	project_budget.from	project_budget.from
project_budget__is_active	BOOLEAN	project_budget.is_active	project_budget.is_active
project_budget__project_id	NUMERIC	project_budget.project_id	project_budget.project_id
project_budget__project_name	TEXT	project_budget.project_name	project_budget.project_name
project_budget__to	TEXT	project_budget.to	project_budget.to

Harvest projects fields

The projects report of the Harvest connector includes 24 fields.

ID	Type	Name	Description
projects__bill_by	TEXT	projects.bill_by	projects.bill_by
projects__budget	NUMERIC	projects.budget	projects.budget
projects__budget_by	TEXT	projects.budget_by	projects.budget_by
projects__budget_is_monthly	BOOLEAN	projects.budget_is_monthly	projects.budget_is_monthly
projects__client	OBJECT	projects.client	projects.client
projects__code	TEXT	projects.code	projects.code
projects__cost_budget	NUMERIC	projects.cost_budget	projects.cost_budget
projects__cost_budget_include_expenses	BOOLEAN	projects.cost_budget_include_expenses	projects.cost_budget_include_expenses
projects__created_at	TEXT	projects.created_at	projects.created_at
projects__ends_on	TEXT	projects.ends_on	projects.ends_on
projects__fee	NUMERIC	projects.fee	projects.fee
projects__hourly_rate	NUMERIC	projects.hourly_rate	projects.hourly_rate
projects__id	NUMERIC	projects.id	projects.id
projects__is_active	BOOLEAN	projects.is_active	projects.is_active
projects__is_billable	BOOLEAN	projects.is_billable	projects.is_billable
projects__is_fixed_fee	BOOLEAN	projects.is_fixed_fee	projects.is_fixed_fee
projects__name	TEXT	projects.name	projects.name
projects__notes	TEXT	projects.notes	projects.notes
projects__notify_when_over_budget	BOOLEAN	projects.notify_when_over_budget	projects.notify_when_over_budget
projects__over_budget_notification_date	TEXT	projects.over_budget_notification_date	projects.over_budget_notification_date
projects__over_budget_notification_percentage	NUMERIC	projects.over_budget_notification_percentage	projects.over_budget_notification_percentage
projects__show_budget_to_all	BOOLEAN	projects.show_budget_to_all	projects.show_budget_to_all
projects__starts_on	TEXT	projects.starts_on	projects.starts_on
projects__updated_at	TEXT	projects.updated_at	projects.updated_at

Harvest roles fields

The roles report of the Harvest connector includes 5 fields.

ID	Type	Name	Description
roles__created_at	TEXT	roles.created_at	roles.created_at
roles__id	NUMERIC	roles.id	roles.id
roles__name	TEXT	roles.name	roles.name
roles__updated_at	TEXT	roles.updated_at	roles.updated_at
roles__user_ids	OBJECT	roles.user_ids	roles.user_ids

Harvest task_assignments fields

The task_assignments report of the Harvest connector includes 9 fields.

ID	Type	Name	Description
task_assignments__billable	BOOLEAN	task_assignments.billable	task_assignments.billable
task_assignments__budget	TEXT	task_assignments.budget	task_assignments.budget
task_assignments__created_at	TEXT	task_assignments.created_at	task_assignments.created_at
task_assignments__hourly_rate	NUMERIC	task_assignments.hourly_rate	task_assignments.hourly_rate
task_assignments__id	NUMERIC	task_assignments.id	task_assignments.id
task_assignments__is_active	BOOLEAN	task_assignments.is_active	task_assignments.is_active
task_assignments__project	OBJECT	task_assignments.project	task_assignments.project
task_assignments__task	OBJECT	task_assignments.task	task_assignments.task
task_assignments__updated_at	TEXT	task_assignments.updated_at	task_assignments.updated_at

Harvest tasks fields

The tasks report of the Harvest connector includes 8 fields.

ID	Type	Name	Description
tasks__billable_by_default	BOOLEAN	tasks.billable_by_default	tasks.billable_by_default
tasks__created_at	TEXT	tasks.created_at	tasks.created_at
tasks__default_hourly_rate	NUMERIC	tasks.default_hourly_rate	tasks.default_hourly_rate
tasks__id	NUMERIC	tasks.id	tasks.id
tasks__is_active	BOOLEAN	tasks.is_active	tasks.is_active
tasks__is_default	BOOLEAN	tasks.is_default	tasks.is_default
tasks__name	TEXT	tasks.name	tasks.name
tasks__updated_at	TEXT	tasks.updated_at	tasks.updated_at

Harvest time_clients fields

The time_clients report of the Harvest connector includes 8 fields.

ID	Type	Name	Description
time_clients__billable_amount	NUMERIC	time_clients.billable_amount	time_clients.billable_amount
time_clients__billable_hours	NUMERIC	time_clients.billable_hours	time_clients.billable_hours
time_clients__client_id	NUMERIC	time_clients.client_id	time_clients.client_id
time_clients__client_name	TEXT	time_clients.client_name	time_clients.client_name
time_clients__currency	TEXT	time_clients.currency	time_clients.currency
time_clients__from	TEXT	time_clients.from	time_clients.from
time_clients__to	TEXT	time_clients.to	time_clients.to
time_clients__total_hours	NUMERIC	time_clients.total_hours	time_clients.total_hours

Harvest time_entries fields

The time_entries report of the Harvest connector includes 28 fields.

ID	Type	Name	Description
time_entries__billable	BOOLEAN	time_entries.billable	time_entries.billable
time_entries__billable_rate	NUMERIC	time_entries.billable_rate	time_entries.billable_rate
time_entries__budgeted	BOOLEAN	time_entries.budgeted	time_entries.budgeted
time_entries__client	OBJECT	time_entries.client	time_entries.client
time_entries__cost_rate	NUMERIC	time_entries.cost_rate	time_entries.cost_rate
time_entries__created_at	TEXT	time_entries.created_at	time_entries.created_at
time_entries__ended_time	TEXT	time_entries.ended_time	time_entries.ended_time
time_entries__external_reference	TEXT	time_entries.external_reference	time_entries.external_reference
time_entries__hours	NUMERIC	time_entries.hours	time_entries.hours
time_entries__hours_without_timer	NUMERIC	time_entries.hours_without_timer	time_entries.hours_without_timer
time_entries__id	NUMERIC	time_entries.id	time_entries.id
time_entries__invoice	OBJECT	time_entries.invoice	time_entries.invoice
time_entries__is_billed	BOOLEAN	time_entries.is_billed	time_entries.is_billed
time_entries__is_closed	BOOLEAN	time_entries.is_closed	time_entries.is_closed
time_entries__is_locked	BOOLEAN	time_entries.is_locked	time_entries.is_locked
time_entries__is_running	BOOLEAN	time_entries.is_running	time_entries.is_running
time_entries__locked_reason	TEXT	time_entries.locked_reason	time_entries.locked_reason
time_entries__notes	TEXT	time_entries.notes	time_entries.notes
time_entries__project	OBJECT	time_entries.project	time_entries.project
time_entries__rounded_hours	NUMERIC	time_entries.rounded_hours	time_entries.rounded_hours
time_entries__spent_date	TEXT	time_entries.spent_date	time_entries.spent_date
time_entries__started_time	TEXT	time_entries.started_time	time_entries.started_time
time_entries__task	OBJECT	time_entries.task	time_entries.task
time_entries__task_assignment	OBJECT	time_entries.task_assignment	time_entries.task_assignment
time_entries__timer_started_at	TEXT	time_entries.timer_started_at	time_entries.timer_started_at
time_entries__updated_at	TEXT	time_entries.updated_at	time_entries.updated_at
time_entries__user	OBJECT	time_entries.user	time_entries.user
time_entries__user_assignment	OBJECT	time_entries.user_assignment	time_entries.user_assignment

Harvest time_projects fields

The time_projects report of the Harvest connector includes 10 fields.

ID	Type	Name	Description
time_projects__billable_amount	NUMERIC	time_projects.billable_amount	time_projects.billable_amount
time_projects__billable_hours	NUMERIC	time_projects.billable_hours	time_projects.billable_hours
time_projects__client_id	NUMERIC	time_projects.client_id	time_projects.client_id
time_projects__client_name	TEXT	time_projects.client_name	time_projects.client_name
time_projects__currency	TEXT	time_projects.currency	time_projects.currency
time_projects__from	TEXT	time_projects.from	time_projects.from
time_projects__project_id	NUMERIC	time_projects.project_id	time_projects.project_id
time_projects__project_name	TEXT	time_projects.project_name	time_projects.project_name
time_projects__to	TEXT	time_projects.to	time_projects.to
time_projects__total_hours	NUMERIC	time_projects.total_hours	time_projects.total_hours

Harvest time_tasks fields

The time_tasks report of the Harvest connector includes 8 fields.

ID	Type	Name	Description
time_tasks__billable_amount	NUMERIC	time_tasks.billable_amount	time_tasks.billable_amount
time_tasks__billable_hours	NUMERIC	time_tasks.billable_hours	time_tasks.billable_hours
time_tasks__currency	TEXT	time_tasks.currency	time_tasks.currency
time_tasks__from	TEXT	time_tasks.from	time_tasks.from
time_tasks__task_id	NUMERIC	time_tasks.task_id	time_tasks.task_id
time_tasks__task_name	TEXT	time_tasks.task_name	time_tasks.task_name
time_tasks__to	TEXT	time_tasks.to	time_tasks.to
time_tasks__total_hours	NUMERIC	time_tasks.total_hours	time_tasks.total_hours

Harvest time_team fields

The time_team report of the Harvest connector includes 9 fields.

ID	Type	Name	Description
time_team__billable_amount	NUMERIC	time_team.billable_amount	time_team.billable_amount
time_team__billable_hours	NUMERIC	time_team.billable_hours	time_team.billable_hours
time_team__currency	TEXT	time_team.currency	time_team.currency
time_team__from	TEXT	time_team.from	time_team.from
time_team__is_contractor	BOOLEAN	time_team.is_contractor	time_team.is_contractor
time_team__to	TEXT	time_team.to	time_team.to
time_team__total_hours	NUMERIC	time_team.total_hours	time_team.total_hours
time_team__user_id	NUMERIC	time_team.user_id	time_team.user_id
time_team__user_name	TEXT	time_team.user_name	time_team.user_name

Harvest uninvoiced fields

The uninvoiced report of the Harvest connector includes 11 fields.

ID	Type	Name	Description
uninvoiced__client_id	NUMERIC	uninvoiced.client_id	uninvoiced.client_id
uninvoiced__client_name	TEXT	uninvoiced.client_name	uninvoiced.client_name
uninvoiced__currency	TEXT	uninvoiced.currency	uninvoiced.currency
uninvoiced__from	TEXT	uninvoiced.from	uninvoiced.from
uninvoiced__project_id	NUMERIC	uninvoiced.project_id	uninvoiced.project_id
uninvoiced__project_name	TEXT	uninvoiced.project_name	uninvoiced.project_name
uninvoiced__to	TEXT	uninvoiced.to	uninvoiced.to
uninvoiced__total_hours	NUMERIC	uninvoiced.total_hours	uninvoiced.total_hours
uninvoiced__uninvoiced_amount	NUMERIC	uninvoiced.uninvoiced_amount	uninvoiced.uninvoiced_amount
uninvoiced__uninvoiced_expenses	NUMERIC	uninvoiced.uninvoiced_expenses	uninvoiced.uninvoiced_expenses
uninvoiced__uninvoiced_hours	NUMERIC	uninvoiced.uninvoiced_hours	uninvoiced.uninvoiced_hours

Harvest user_assignments fields

The user_assignments report of the Harvest connector includes 10 fields.

ID	Type	Name	Description
user_assignments__budget	NUMERIC	user_assignments.budget	user_assignments.budget
user_assignments__created_at	TEXT	user_assignments.created_at	user_assignments.created_at
user_assignments__hourly_rate	NUMERIC	user_assignments.hourly_rate	user_assignments.hourly_rate
user_assignments__id	NUMERIC	user_assignments.id	user_assignments.id
user_assignments__is_active	BOOLEAN	user_assignments.is_active	user_assignments.is_active
user_assignments__is_project_manager	BOOLEAN	user_assignments.is_project_manager	user_assignments.is_project_manager
user_assignments__project	OBJECT	user_assignments.project	user_assignments.project
user_assignments__updated_at	TEXT	user_assignments.updated_at	user_assignments.updated_at
user_assignments__use_default_rates	BOOLEAN	user_assignments.use_default_rates	user_assignments.use_default_rates
user_assignments__user	OBJECT	user_assignments.user	user_assignments.user

Harvest users fields

The users report of the Harvest connector includes 23 fields.

ID	Type	Name	Description
users__avatar_url	TEXT	users.avatar_url	users.avatar_url
users__calendar_integration_enabled	BOOLEAN	users.calendar_integration_enabled	users.calendar_integration_enabled
users__calendar_integration_source	TEXT	users.calendar_integration_source	users.calendar_integration_source
users__can_create_invoices	BOOLEAN	users.can_create_invoices	users.can_create_invoices
users__can_create_projects	BOOLEAN	users.can_create_projects	users.can_create_projects
users__can_see_rates	BOOLEAN	users.can_see_rates	users.can_see_rates
users__cost_rate	NUMERIC	users.cost_rate	users.cost_rate
users__created_at	TEXT	users.created_at	users.created_at
users__default_hourly_rate	NUMERIC	users.default_hourly_rate	users.default_hourly_rate
users__email	TEXT	users.email	users.email
users__first_name	TEXT	users.first_name	users.first_name
users__has_access_to_all_future_projects	BOOLEAN	users.has_access_to_all_future_projects	users.has_access_to_all_future_projects
users__id	NUMERIC	users.id	users.id
users__is_active	BOOLEAN	users.is_active	users.is_active
users__is_admin	BOOLEAN	users.is_admin	users.is_admin
users__is_contractor	BOOLEAN	users.is_contractor	users.is_contractor
users__is_project_manager	BOOLEAN	users.is_project_manager	users.is_project_manager
users__last_name	TEXT	users.last_name	users.last_name
users__roles	OBJECT	users.roles	users.roles
users__telephone	TEXT	users.telephone	users.telephone
users__timezone	TEXT	users.timezone	users.timezone
users__updated_at	TEXT	users.updated_at	users.updated_at
users__weekly_capacity	NUMERIC	users.weekly_capacity	users.weekly_capacity

Harvest other fields

The Harvest connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date

API Connectors