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

Tasks

CData Excel Add-In for FreshBooks 2019 - Build 19.0.7354

A list of tasks associated with a FreshBooks account. Staff members can only use the ProjectId field for projects they're 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:

  • TaskId
  • ProjectId

Note: TaskId cannot be used at the same time as ProjectId.

Other filters are processed client side by the add-in. See SupportEnhancedSQL for more information.

Insert

The Name field is required when inserting.

Columns

Name Type ReadOnly Description
TaskId [KEY] String True

The unique identifier for a task.

ProjectId String True

The Id for a project associated with a task.

Name String False

The name of a task.

Description String False

The description of a task.

Billable Boolean False

The billable status of a task, denoted by 1 or 0.

Rate Decimal False

The rate associated with a task.

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