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

Items

CData Excel Add-In for FreshBooks 2019 - Build 19.0.7354

A list of items stored in FreshBooks.

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:

  • ItemId
  • Folder

Note: ItemId and Folder cannot be used at the same time.

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

Columns

Name Type ReadOnly Description
ItemId [KEY] String True

The unique identifier of an item.

Name String False

The name of an item.

Description String False

The description of an item.

UnitCost Decimal False

The unit cost of an item.

Quantity Double False

The quantity of an item.

Folder String True

The folder category for an item.

Inventory Decimal False

Inventory value of an item. Blank by default.

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