Power BI Connector for FreshBooks

Build 20.0.7587

TimeEntries

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