ADO.NET Provider for FreshBooks

Build 20.0.7654


A list of time entries associated with a FreshBooks account. Staff can only create new time entries for projects they are assigned to.

Table Specific Information


The Classic API allows only a subset of columns to be used as filter criteria in the WHERE clause. The following columns can be used:

  • TimeEntryId

Other filters are processed client side by the provider. See SupportEnhancedSQL for more information.


The ProjectId and TaskId fields are required when inserting.


Name Type ReadOnly Description
TimeEntryId [KEY] String True

The unique identifier for a time entry.

StaffId String False

The Id for a staff member associated with a time entry. If not specified, will default to the current staff's Id.

ProjectId String False

The Id for a project associated with a time entry.

TaskId String False

The Id for a task associated with a time entry.

Hours Decimal False

The number of hours listed for a time entry.

Date Datetime False

The date associated for a time entry.

Notes String False

A custom note for a time entry.

Billed Boolean True

The billed status of a time entry.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654