Harvest
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Harvest to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Harvest account ID and a personal access token to sync your time tracking and invoicing data into the PostHog Data warehouse.
Create a token at id.getharvest.com/developers, which shows the account ID alongside it. The token inherits the permissions of the user who created it, so connect a user who can see the data you want to sync. Listing users and roles needs an administrator.
Configuration
| Option | Type | Required |
|---|---|---|
Account ID | text | Yes |
Personal access token | password | Yes |
Linking Harvest to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Harvest
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
clients | Clients you track time and bill against. | Incremental, Full refresh | updated_at | — |
contacts | Contact people belonging to a client. | Incremental, Full refresh | updated_at | — |
estimate_item_categories | Categories available for estimate line items. | Incremental, Full refresh | updated_at | — |
estimates | Estimates sent to clients, including their line items. | Incremental, Full refresh | updated_at | — |
expense_categories | Categories expenses can be filed under. | Incremental, Full refresh | updated_at | — |
expenses | Expenses logged against projects. | Incremental, Full refresh | updated_at | — |
invoice_item_categories | Categories available for invoice line items. | Incremental, Full refresh | updated_at | — |
invoices | Invoices issued to clients, including their line items. | Incremental, Full refresh | updated_at | — |
projects | Projects time and expenses are tracked against. | Incremental, Full refresh | updated_at | — |
roles | Roles and the users assigned to them. Full refresh only - the roles endpoint has no server-side modified-since filter. | Full refresh | — | — |
task_assignments | Tasks assigned to projects, with their billable rate and budget. | Incremental, Full refresh | updated_at | — |
tasks | Tasks that can be assigned to projects. | Incremental, Full refresh | updated_at | — |
time_entries | Tracked time, one row per entry. | Incremental, Full refresh | updated_at | — |
user_assignments | Users assigned to projects, with their rate and budget. | Incremental, Full refresh | updated_at | — |
users | People in the Harvest account. | Incremental, Full refresh | updated_at | — |