Harvest: Most-used fields
The table below gives information about most-used fields that you can import from Harvest. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
access_rolesDimension
The access role(s) that define the user's permissions within Harvest.
approval_statusDimension
The approval status of the time entry, which can be "unsubmitted", "submitted", or "approved".
avatar_urlDimension
The URL for the user's avatar image.
billableDimension
Indicates whether the project is billable.
billable_rateMetric
The hourly rate used for projects billed by a project hourly rate.
client.currencyDimension
The currency code associated with the client.
client.idDimension
The unique identifier for the client.
client.nameDimension
The name of the client.
cost_rateDimension
The cost rate used for a user in calculating a project's costs versus the billable amount.
created_atDimension
The date and time when the record was created.
dateDimension
The date associated with the record, such as the date a time entry was spent or an expense occurred.
default_hourly_rateDimension
The default billable hourly rate for the user when assigned to a project.
emailDimension
The email address of the user.
ended_timeDimension
The time when the time entry ended.
external_referenceDimension
An object containing details of an external reference associated with the time entry.
first_nameDimension
The first name of the user.
has_access_to_all_future_projectsDimension
Indicates whether the user is automatically added to all future projects.
hoursMetric
The number of hours tracked in a time entry.
hours_without_timerMetric
The number of hours tracked in a time entry before the timer was last started.
idMetric
The unique identifier for the record.
invoiceDimension
An object containing information about the associated invoice once the record has been invoiced.
is_activeDimension
Indicates whether the record is active or archived.
is_billedDimension
Indicates whether the time entry has been marked as invoiced.
is_contractorDimension
Indicates whether the user is a contractor or an employee.
is_lockedDimension
Indicates whether the time entry has been locked.
is_runningDimension
Indicates whether the time entry timer is currently running.
last_nameDimension
The last name of the user.
locked_reasonDimension
The reason why the time entry has been locked.
notesDimension
Any textual notes or description associated with the record.
permissions_profileDimension
An array of strings representing the access roles assigned to a user, which determine their permissions within Harvest. Examples include administrator, manager, or member, with managers having additional specific permissions like project creator or billable rates manager.
project.codeDimension
The code assigned to the associated project.
project.idDimension
The unique identifier for the associated project.
project.nameDimension
The name of the associated project.
rolesDimension
Descriptive business roles assigned to the user, used for filtering reports.
rounded_hoursMetric
The rounded number of hours tracked in a time entry, used in summary reports and invoices based on Time Rounding settings.
spent_dateDimension
The date on which the time entry was spent or the expense occurred.
started_timeDimension
The time when the time entry started.
task.idMetric
The unique identifier for the associated task.
task.nameDimension
The name of the associated task.
task_assignment.billableDimension
Indicates whether the task assignment is billable.
task_assignment.budgetDimension
The budget allocated for the task assignment when the project's budgeting method is by task or task fees.
task_assignment.created_atDimension
The date and time when the task assignment was created.
task_assignment.hourly_rateMetric
The hourly rate used for the task assignment when the project's billing method is by tasks.
task_assignment.idMetric
The unique identifier for the task assignment.
task_assignment.is_activeDimension
Indicates whether the task assignment is active or archived.
task_assignment.updated_atDimension
The date and time when the task assignment was last updated.
telephoneDimension
The user's telephone number.
timer_started_atDimension
The date and time when the running timer for a time entry was started.
timezoneDimension
The user's timezone.
updated_atDimension
The date and time when the record was last updated.
user.idDimension
The unique identifier for the associated user.
user.nameDimension
The name of the associated user.
user_assignment.budgetMetric
The budget allocated for the user assignment when the project's budgeting method is by person.
user_assignment.created_atDimension
The date and time when the user assignment was created.
user_assignment.hourly_rateDimension
The custom hourly rate used for the user assignment when the project bills by people and does not use default rates.
user_assignment.idMetric
The unique identifier for the user assignment.
user_assignment.is_activeDimension
Indicates whether the user assignment is active or archived.
user_assignment.is_project_managerDimension
Indicates whether the user has Project Manager permissions for the associated project.
user_assignment.updated_atDimension
The date and time when the user assignment was last updated.
user_assignment.use_default_ratesDimension
Determines if the user's default billable rates or custom rates from the user assignment are used for a project billed by people.
weekly_capacityMetric
The number of hours per week a user is available to work, expressed in seconds.