Integrations
Harvest datasets and fields
The 4 datasets Maven lands from Harvest, every field in them, and how the connection syncs.
Maven lands 4 datasets from Harvest in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Harvest integration page.
Connection and sync#
You connect Harvest by signing in to it and approving access, so nobody shares a password.
The first Harvest sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.
Datasets#
Time entries#
Time tracking entries — hours, rates, billing per user per project.
| Field | Type |
|---|---|
| entry ID | Integer |
| date | Text |
| hours | Number |
| project ID | Integer |
| project name | Text |
| task ID | Integer |
| task name | Text |
| client ID | Integer |
| client name | Text |
| user ID | Integer |
| user name | Text |
| is billed | True/false |
| is running | True/false |
| billable | True/false |
| billable rate | Number |
| cost rate | Number |
| billable amount | Number |
| cost amount | Number |
| notes | Text |
| updated at | Timestamp |
Invoices#
Invoice records — amounts, due dates, payment status.
| Field | Type |
|---|---|
| invoice ID | Integer |
| client ID | Integer |
| client name | Text |
| number | Text |
| amount | Number |
| due amount | Number |
| tax | Number |
| tax amount | Number |
| state | Text |
| issue date | Text |
| due date | Text |
| sent at | Text |
| paid at | Text |
| currency | Text |
| date | Date |
| updated at | Timestamp |
Projects#
Project snapshot with client linkage and billing configuration.
| Field | Type |
|---|---|
| project ID | Integer |
| name | Text |
| client ID | Integer |
| client name | Text |
| code | Text |
| is active | True/false |
| is billable | True/false |
| budget | Number |
| budget by | Text |
| hourly rate | Number |
| created at | Timestamp |
| updated at | Timestamp |
| date | Date |
Clients#
Client snapshot used to attach authoritative billing currency to time-entry value.
| Field | Type |
|---|---|
| client ID | Integer |
| name | Text |
| is active | True/false |
| currency | Text |
| created at | Timestamp |
| updated at | Timestamp |
| date | Date |