Power BI Connector for FreshBooks

Build 20.0.7587

Staff

A list of staff associated with a FreshBooks account. Staff members can only access their own information.

Table Specific Information

Select

The Classic API only allows a subset of columns to be used as filter criteria in the WHERE clause. The following columns can be used:

  • StaffId

Other filters are processed client side by the connector. See SupportEnhancedSQL for more information.

Columns

Name Type ReadOnly Description
StaffId [KEY] String True

The unique identifier for a staff member.

Username String True

The user name associated with a staff member.

FirstName String True

The first name of a staff member.

LastName String True

The last name of a staff member.

Email String True

The email address of a staff member.

BusinessPhone String True

The business phone number associated with a staff member.

MobilePhone String True

The mobile phone number associated with a staff member.

Rate Decimal True

The billing rate associated with a staff member.

LastLogin String True

The last login date associated with a staff member.

NumberOfLogins String True

The number of logins associated with a staff member.

SingupDate Datetime True

The sign-up date associated with a staff member.

Street1 String True

The first street line associated with a staff member.

Street2 String True

The second street line associated with a staff member.

City String True

The city associated with a staff member.

State String True

The state associated with a staff member.

Country String True

The country associated with a staff member.

Code String True

The code associated with a staff member.

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