CData Excel Add-In for FreshBooks 2019 - Online Help
Questions / Feedback?

TimeEntries

CData Excel Add-In for FreshBooks 2019 - Build 19.0.7354

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

Select

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 add-in. See SupportEnhancedSQL for more information.

Insert

The ProjectId and TaskId fields are required when inserting.

Columns

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 19.0.7354.0