Power BI Connector for FreshBooks

Build 20.0.7587

Contractors

A list of contractors associated with a FreshBooks account. Available only to account administrator, not staff members.

Table Specific Information

Insert

To insert, the Email and TaskId fields are required.

Project Aggregate

You can use the ProjectAggregate field to flatten project items into a single field. This XML aggregate contains the ProjectId for all projects to which the Contractor is assigned and can be inserted and updated directly using the proper XML formatting, as indicated by the example below:

INSERT INTO Contractors (Email, TaskId, ProjectAggregate)
VALUES ('jane.doe@abccorp.com', '12345',
'<project><project_id>789</project_id></project>')

Note: Updating this field will remove all previously stored contact information.

Columns

Name Type ReadOnly Description
ContractorId [KEY] String True

The unique identifier for a contractor.

Name String False

The user name associated with a contractor.

Email String False

The email address of a contractor.

Status String True

The status of a contractor. (Invited or Accepted)

Rate Decimal False

The billing rate associated with a contractor.

TaskId String False

The unique identifier for a task assigned to a contractor.

ProjectAggregate String False

An aggregate containing additional project information about a contractor. See the help file for the Contractors table for more details.

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