ManagedClients
Retrieves a list of managed clients available from your account.
Table Specific Information
Select
Query the ManagedClients table. The add-in 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 add-in.
- ActiveStatus filter supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM ManagedClients WHERE ActiveStatus = 'both'
Columns
Name | Type | Description |
Id [KEY] | String | Id of the managed client. |
CompanyUrl | String | URL used by the managed client to sign in to TSheets. |
CompanyName | String | Name of the managed client's company. |
Active | Boolean | Whether this client is active. If false, this client is considered archived. |
Created | Datetime | Date/time when this managed client record was created |
LastModified | Datetime | Date/time when this managed client record was last modified. |
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 |
ActiveStatus | String | Filter column for whether to fetch only active records, only archived records, or both. By default, only active records are fetched. Possible values are: yes, no, both |