ProjectActivities
Query the Project Activities in TSheets.
Table Specific Information
Select
Query the ProjectActivities table. The connector will use the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports the '=,IN'
- ProjectId supports the '='
- ActivityType supports the '='
- LastModified supports the '<,<=,>,>='
- SupplementalData supports the '='
For example, the following queries are processed server side:
SELECT * FROM ProjectActivities WHERE ProjectId = 2056676 SELECT * FROM ProjectActivities WHERE ProjectId = 2056676 AND Id = 8375474
Columns
| Name | Type | Description |
| Id [KEY] | Integer | ID of this project activity. |
| UserId | Integer | Id of the associated user. |
| ProjectId | Integer | Id of the associated project. |
| Active | Boolean | Boolean value. If false, this project activity is considered archive. |
| UnreadRepliesCount | Integer | The count of unread replies. |
| Following | Boolean | Following. |
| ActivityType | String | Activity type. |
| LastModified | Datetime | Date/time when this project was last modified, in ISO 8601 format. |
| Created | Datetime | Date/time when this project was created, in ISO 8601 format. |
| ProjectActivityMetadata | String | Project activity metadata. |
| LinkedObjects | String | A key/value map of all the objects linked to this project and the corresponding object ids. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SupplementalData | Boolean | Default value is 'yes'. Indicates whether supplemental data should be specified. |