Harvest
Harvest is a time tracking application that makes it easy to capture time, gain insights from past projects, and get paid for your work
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | False |
Data Schema
Loading diagram…
user_project_assignment
T
user_project_assignment
id
stringproject_id
stringclient_id
string-parent_user_id
string-is_project_manager
boolean-is_active
boolean-use_default_rates
boolean-budget
string-created_at
date-updated_at
date-hourly_rate
double-project_name
string-project_code
string-project_is_billable
boolean-client_name
string-client_currency
string-_weld_synced
dateS
task_assignments
id
stringtask_id
stringuser_project_assignment_id
string-billable
boolean-is_active
boolean-created_at
date-updated_at
date-hourly_rate
string-budget
string-task_name
string-index
doubleestimate
T
estimate
id
stringclient_id
string-client_key
string-number
double-purchase_order
double-amount
double-tax
string-tax_amount
double-tax_2
string-tax_2_amount
double-discount
double-discount_amount
double-subject
string-notes
string-state
string-issue_date
date-sent_at
string-created_at
date-updated_at
date-accepted_at
date-declined_at
string-currency
string-client_name
string-creator_id
string-creator_name
string-_weld_synced
dateS
line_items
id
stringestimate_id
string-kind
string-description
string-quantity
double-unit_price
double-amount
double-taxed
boolean-taxed_2
boolean-index
doubleinvoice
T
invoice
id
stringclient_id
string-client_key
string-number
double-purchase_order
string-amount
double-due_amount
double-tax
string-tax_amount
double-tax_2
string-tax_2_amount
double-discount
string-discount_amount
double-subject
string-notes
string-state
string-period_start
date-period_end
date-issue_date
date-due_date
date-payment_term
string-sent_at
string-paid_at
string-closed_at
string-recurring_invoice_id
string-created_at
date-updated_at
date-paid_date
string-currency
string-payment_options
string-client_name
string-estimate
string-retainer
string-creator_id
string-creator_name
string-_weld_synced
dateT
estimate_item_category
id
string-name
string-created_at
date-updated_at
date-_weld_synced
dateT
company
-base_uri
string-full_domain
string-name
string-is_active
boolean-week_start_day
string-wants_timestamp_timers
boolean-time_format
string-date_format
string-plan_type
string-expense_feature
boolean-invoice_feature
boolean-estimate_feature
boolean-team_feature
boolean-weekly_capacity
double-approval_feature
boolean-clock
string-currency
string-currency_code_display
string-currency_symbol_display
string-decimal_symbol
string-thousands_separator
string-color_scheme
string-saml_sign_in_required
boolean-day_entry_notes_required
boolean-_weld_synced
dateT
task
id
string-name
string-billable_by_default
boolean-is_default
boolean-is_active
boolean-created_at
date-updated_at
date-default_hourly_rate
string-_weld_synced
dateT
contact
-_weld_synced
dateT
time_entry
id
stringuser_id
stringclient_id
stringproject_id
stringtask_id
string-spent_date
date-hours
double-hours_without_timer
double-rounded_hours
double-notes
string-is_locked
boolean-locked_reason
string-is_closed
boolean-is_billed
boolean-timer_started_at
date-started_time
string-ended_time
string-is_running
boolean-billable
boolean-budgeted
boolean-billable_rate
double-cost_rate
string-created_at
date-updated_at
date-user_name
string-client_name
string-client_currency
string-project_name
string-project_code
string-task_name
string-user_assignment_id
string-user_assignment_is_project_manager
boolean-user_assignment_is_active
boolean-user_assignment_use_default_rates
boolean-user_assignment_budget
string-user_assignment_created_at
date-user_assignment_updated_at
date-user_assignment_hourly_rate
double-task_assignment_id
string-task_assignment_billable
boolean-task_assignment_is_active
boolean-task_assignment_created_at
date-task_assignment_updated_at
date-task_assignment_hourly_rate
string-task_assignment_budget
double-invoice
string-external_reference
string-_weld_synced
dateT
user_billable_rate
id
string-parent_user_id
string-amount
double-start_date
string-end_date
string-created_at
date-updated_at
date-_weld_synced
dateT
invoice_payment
-_weld_synced
dateT
invoice_message
-_weld_synced
dateT
project_task_assignment
id
stringproject_id
stringtask_id
string-billable
boolean-is_active
boolean-created_at
date-updated_at
date-hourly_rate
string-budget
string-project_name
string-project_code
string-task_name
string-_weld_synced
dateT
project
id
stringclient_id
string-name
string-code
string-is_active
boolean-is_billable
boolean-is_fixed_fee
boolean-bill_by
string-budget
double-budget_by
string-budget_is_monthly
boolean-notify_when_over_budget
boolean-over_budget_notification_percentage
double-show_budget_to_all
boolean-created_at
date-updated_at
date-starts_on
date-ends_on
date-over_budget_notification_date
string-notes
string-cost_budget
string-cost_budget_include_expenses
boolean-hourly_rate
string-fee
string-client_name
string-client_currency
string-_weld_synced
dateT
expense_categories_report
expense_category_id
string-expense_category_name
string-total_amount
double-billable_amount
double-currency
string-_weld_synced
dateT
project_user_assignment
id
stringproject_id
stringuser_id
string-is_project_manager
boolean-is_active
boolean-use_default_rates
boolean-created_at
date-updated_at
date-hourly_rate
double-budget
string-project_name
string-project_code
string-user_name
string-_weld_synced
dateT
expense_category
id
string-name
string-unit_name
string-unit_price
double-is_active
boolean-created_at
date-updated_at
date-_weld_synced
dateT
time_team_report
user_id
string-user_name
string-is_contractor
boolean-weekly_capacity
double-avatar_url
string-total_hours
double-billable_hours
double-currency
string-billable_amount
double-_weld_synced
dateT
expense
id
stringuser_id
stringclient_id
stringproject_id
stringexpense_category_id
string-spent_date
date-notes
string-total_cost
double-units
double-billable
boolean-receipt
string-is_closed
boolean-is_locked
boolean-is_billed
boolean-locked_reason
string-created_at
date-updated_at
date-user_name
string-client_name
string-client_currency
string-project_name
string-project_code
string-expense_category_name
string-expense_category_unit_price
double-expense_category_unit_name
string-user_assignment_id
string-user_assignment_is_project_manager
boolean-user_assignment_is_active
boolean-user_assignment_use_default_rates
boolean-user_assignment_budget
double-user_assignment_created_at
date-user_assignment_updated_at
date-user_assignment_hourly_rate
double-invoice
string-_weld_synced
dateT
time_projects_report
project_id
stringclient_id
string-project_name
string-client_name
string-total_hours
double-billable_hours
double-currency
string-billable_amount
double-_weld_synced
dateT
expense_team_report
user_id
string-user_name
string-is_contractor
boolean-total_amount
double-billable_amount
double-currency
string-_weld_synced
dateT
time_clients_report
client_id
string-client_name
string-total_hours
double-billable_hours
double-currency
string-billable_amount
double-_weld_synced
dateT
invoice_item_category
id
string-name
string-use_as_service
boolean-use_as_expense
boolean-created_at
date-updated_at
date-_weld_synced
dateT
uninvoiced_report
client_id
stringproject_id
string-client_name
string-project_name
string-currency
string-total_hours
double-uninvoiced_hours
double-uninvoiced_expenses
double-uninvoiced_amount
double-_weld_synced
dateT
expense_clients_report
client_id
string-client_name
string-total_amount
double-billable_amount
double-currency
string-_weld_synced
dateT
expense_projects_report
client_id
stringproject_id
string-client_name
string-project_name
string-total_amount
double-billable_amount
double-currency
string-_weld_synced
dateT
role
id
string-name
string-created_at
date-updated_at
date-user_ids
string-_weld_synced
dateT
time_tasks_report
task_id
string-task_name
string-total_hours
double-billable_hours
double-currency
string-billable_amount
double-_weld_synced
dateT
client
id
string-name
string-is_active
boolean-address
string-statement_key
string-created_at
date-updated_at
date-currency
string-_weld_synced
dateT
user_cost_rate
-_weld_synced
dateT
project_budget_report
project_id
stringclient_id
string-project_name
string-client_name
string-budget_is_monthly
boolean-budget_by
string-is_active
boolean-budget
double-budget_spent
double-budget_remaining
double-_weld_synced
dateT
user
id
string-first_name
string-last_name
string-email
string-telephone
string-timezone
string-weekly_capacity
double-has_access_to_all_future_projects
boolean-is_contractor
boolean-is_active
boolean-calendar_integration_enabled
boolean-calendar_integration_source
string-created_at
date-updated_at
date-can_create_projects
boolean-default_hourly_rate
double-cost_rate
string-roles
string-access_roles
string-permissions_claims
string-avatar_url
string-_weld_synced
dateT
estimate_message
id
string-parent_estimate_id
string-sent_by
string-sent_by_email
string-sent_from
string-sent_from_email
string-send_me_a_copy
boolean-created_at
date-updated_at
date-recipients
string-event_type
string-subject
string-body
string-_weld_synced
dateT
TableS
Sub tablePress enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Open full-page schema explorer
Setup Guide
Step 1 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Click Authorize to allow Weld to access your Harvest account using OAuth.
Step 2 - Approve and finalize
- Approve Weld to access your Harvest account.
- When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.
Step 3 - Connection Settings
- Select a single Harvest account that you would like to sync data from.
Step 4 - Data To Sync
- Select the pre-built tables you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 5 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Harvest account.