A list of projects associated with a FreshBooks account. Staff members can access all projects they're assigned to, but can only edit projects for which they are the Project Manager.
Table Specific Information
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:
Other filters are processed client side by the connector. See SupportEnhancedSQL for more information.
The Name and BillMethod columns are required when inserting.
Use the TaskAggregate field to flatten task items into a single field. This XML aggregate contains Ids and rates for tasks associated with a project and can be inserted and updated directly using the proper XML formatting, as indicated by the example below:
INSERT INTO Projects (Name, BillMethod, TaskAggregate) VALUES ('Website Redesign', 'project-rate', '<task><task_id>12</task_id></task> <task><task_id>13</task_id><rate>25</rate></task> <task><task_id>24</task_id><rate>25</rate></task>')
Note: Updating this field will remove all previously stored task information.
The unique identifier for a project.
The name associated with a project.
The description for a project.
The rate associated with a project.
The billing method associated with a project.
The Id for a client associated with a project.
The hour budget associated with a project.
An aggregate of tasks associated with a project. See the help file for the Projects table for more information.
An aggregate of staff associated with a project. See the help file for the Projects table for more information.