Connectors

/

Harvest

Data replication

Sync Harvest data anywhere.

Harvest is a provider of time tracking and online invoicing services for freelancers and small businesses. Harvest focuses on providing simple to use web-based software for professional services. Customers range from freelancers to creative services businesses, to team within Fortune 500 organizations and non-profits.

  • Certified
  • Generally available
  • 32 streams
  • 18 entities
Sync Harvest dataRead the docs
Harvest

One connector

Everything Harvest can do in Airbyte

  • Sync to your warehouse

    Land 32 Harvest tables in 50+ destinations on a schedule you control.

  • Context store search

    Query synced Harvest data with filters, sorting and semantic search, without spending Harvest API rate limits.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate Harvest once. The same connection powers scheduled syncs and runtime actions.

Specifications

What to know before you sync Harvest

  • Support levelCertified
  • Available onCloud, Self-Managed Enterprise
  • Connector version1.2.49
  • Release stageGenerally available

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 10 steps

  1. Open the Airbyte UI and navigate to the "Sources" tab.
  2. Click on the "New Source" button and select "Harvest" from the list of available connectors.
  3. Enter a name for the Harvest source connector and click on the "Next" button.
  4. Enter your Harvest account credentials, including your subdomain, email address, and password.
  5. Click on the "Test" button to ensure that the connection is successful.
  6. Once the connection is successful, select the data you want to replicate from Harvest.
  7. Choose the replication frequency and the destination where you want to store the data.
  8. Click on the "Create Source" button to save the Harvest source connector.
  9. You can now run the connector to start replicating data from Harvest to your destination.
  10. You can also monitor the replication status and troubleshoot any issues using the Airbyte UI.

32 streams

Every table you can sync from Harvest

  • Client Contacts

  • Clients

  • Company

  • Invoice Messages

  • Invoice Payments

  • Invoices

  • Invoice Item Categories

  • Estimate Messages

  • Estimates

  • Estimate Item Categories

  • Expenses

  • Expense Categories

  • Tasks

  • Time Entries

  • Project User Assignments

  • Project Task Assignments

  • Projects

  • Roles

  • Users

  • User Billable Rates

  • User Cost Rates

  • User Project Assignments

  • Expense Clients Report

  • Expense Projects Report

  • Expense Categories Report

  • Expense Team Report

  • Uninvoiced Report

  • Time Clients Report

  • Time Projects Report

  • Time Tasks Report

  • Time Team Report

  • Project Budget Report

3 actions

Supported Harvest actions

  • List

    Read live records straight from the Harvest API.

  • Get

    Fetch a single record by ID.

  • Context Store Search

    Query synced data with filters and sorting, with no API rate limits.

Full parameter-level details live in the Harvest entity reference.

Authentication

Authenticate Harvest once

    • Recommended

    Authenticate via Harvest (OAuth)

  • Authenticate with Personal Access Token

Use cases

What teams build with Harvest

List all users in Harvest

Show me all active projects

List all clients

Show me recent time entries

List all invoices

Show me all tasks

List all expense categories

Get company information

How many hours were logged last week?

Which projects have the most time entries?

Show me all unbilled time entries

What are the active projects for a specific client?

List all overdue invoices

Which users logged the most hours this month?

Explore

Related connectors

HellobatonFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
HibobFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
HoorayHRFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
HubplannerFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
InflowinventoryFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
InsightfulFinance & Ops AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

No. One Harvest authorization powers both the scheduled syncs that land data in your destination and the entity actions your agents call at runtime.

No. Entity actions read and write through the Harvest API as they are called, so they work immediately. Context store search is the exception: it queries data Airbyte has already synced, which is what lets it filter and sort without spending API rate limits.

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Harvest's API provides access to a wide range of data related to time tracking, invoicing, and project management. The following are the categories of data that can be accessed through Harvest's API:

1. Time tracking data: This includes information about the time spent on tasks, projects, and clients.

2. Invoicing data: This includes information about invoices, payments, and expenses.

3. Project management data: This includes information about projects, tasks, and team members.

4. Client data: This includes information about clients, contacts, and projects associated with them.

5. User data: This includes information about users, their roles, and permissions.

6. Reports data: This includes information about various reports generated by Harvest, such as time reports, expense reports, and project reports.

7. Account data: This includes information about the Harvest account, such as account settings, plan details, and billing information.

Overall, Harvest's API provides a comprehensive set of data that can be used to automate various business processes and gain insights into the performance of projects and teams.

1. Open the Airbyte UI and navigate to the "Sources" tab.

2. Click on the "New Source" button and select "Harvest" from the list of available connectors.

3. Enter a name for the Harvest source connector and click on the "Next" button.

4. Enter your Harvest account credentials, including your subdomain, email address, and password.

5. Click on the "Test" button to ensure that the connection is successful.

6. Once the connection is successful, select the data you want to replicate from Harvest.

7. Choose the replication frequency and the destination where you want to store the data.

8. Click on the "Create Source" button to save the Harvest source connector.

9. You can now run the connector to start replicating data from Harvest to your destination.

10. You can also monitor the replication status and troubleshoot any issues using the Airbyte UI.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Harvest data today

Free for 14 days on Airbyte Cloud. One connection powers your scheduled syncs and your live Harvest actions.

Try it freeTalk to sales