CData Python Connector for FreshBooks

Build 20.0.7587

Items

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 provider. 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 20.0.7587