Connectors

/

Harvest

Harvest

Finance & Ops Analytics

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
  • 32Streams
  • 18Entities
  • 3Actions
  • 50+Destinations
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.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version1.2.49

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

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

  • Authenticate via Harvest (OAuth)

    Recommended

  • 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

FAQ

Common questions

Do I need more than one Harvest connection?

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

Do Harvest entity actions need a sync to run first?

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.

What is ETL?

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.

What data can you extract from Harvest?

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.

How do I transfer data from Harvest?

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.

What are top ETL tools to transfer data from Harvest?

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.

What is ELT?

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.

Difference between ETL and ELT?

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.

Explore
All connectors

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