getProjectsPeopleUtilization
Analyze team utilization metrics across projects to track billable time, availability, and resource allocation for informed workforce management decisions.
Instructions
Return the user utilization data. This endpoint provides detailed information about user utilization, including billable and non-billable time, availability, and various utilization metrics.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| zoom | No | determine the type of zoom filter used to display on the report | |
| startDate | No | filter by start date | |
| sortOrder | No | order mode | |
| sort | No | sort by (deprecated, use orderBy) | |
| searchTerm | No | filter by user first or last name | |
| reportFormat | No | define the format of the report | |
| orderMode | No | group by | |
| orderBy | No | sort by | |
| groupBy | No | group by | |
| endDate | No | filter by end date | |
| pageSize | No | number of items in a page | |
| page | No | page number | |
| skipCounts | No | skip doing counts on a list API endpoint for performance reasons | |
| legacyResponse | No | return response without summary and its legacy body structure | |
| isReportDownload | No | generate a report document | |
| isCustomDateRange | No | determine if the query is for a custom date range | |
| includeUtilizations | No | adds report rows for individual entities | |
| includeTotals | No | adds report summary to response | |
| includeCollaborators | No | include collaborators | |
| includeClients | No | include client users | |
| includeArchivedProjects | No | include archived projects | |
| IncludeCompletedTasks | No | include completed tasks | |
| userIds | No | filter by userIds | |
| teamIds | No | filter by team ids | |
| selectedColumns | No | customise the report by selecting columns to be displayed | |
| projectIds | No | filter by project ids | |
| jobRoleIds | No | filter by jobrole ids | |
| include | No | include additional data | |
| fieldsUtilizations | No | Query parameter: fields[utilizations] - specific utilization fields to include | |
| fieldsUsers | No | Query parameter: fields[users] - specific user fields to include | |
| companyIds | No | filter by company ids |
Implementation Reference
- The MCP tool handler that adapts input parameters (mapping camelCase to API fields), invokes the getPeopleUtilization service, and returns the JSON response as text content or an error response.export async function handleGetProjectsPeopleUtilization(input: any) { // Map camelCase field names back to API format const apiInput: Record<string, any> = { ...input }; // Define the mapping for fields[...] parameters const fieldMappings: Record<string, string> = { fieldsUtilizations: "fields[utilizations]", fieldsUsers: "fields[users]", }; for (const [camelCaseKey, apiKey] of Object.entries(fieldMappings)) { if (apiInput[camelCaseKey] !== undefined) { apiInput[apiKey] = apiInput[camelCaseKey]; delete apiInput[camelCaseKey]; } } try { const response = await getPeopleUtilization(apiInput); return { content: [{ type: "text", text: JSON.stringify(response, null, 2) }] }; } catch (error: any) { return createErrorResponse(error, 'Getting people utilization'); } }
- The tool's input schema definition, including detailed properties for filters, sorting, pagination, and report options matching the API parameters.export const getProjectsPeopleUtilizationDefinition = { name: "getProjectsPeopleUtilization", description: "Return the user utilization data. This endpoint provides detailed information about user utilization, including billable and non-billable time, availability, and various utilization metrics.", inputSchema: { type: 'object', properties: { zoom: { type: 'string', description: 'determine the type of zoom filter used to display on the report', enum: [ 'week', 'month', 'last3months', 'quarterbyweek', 'quarterbymonth' ] }, startDate: { type: 'string', description: 'filter by start date' }, sortOrder: { type: 'string', description: 'order mode', enum: [ 'asc', 'desc' ] }, sort: { type: 'string', description: 'sort by (deprecated, use orderBy)', enum: [ 'name', 'percentutilization', 'percentestimatedutilization', 'availableminutes', 'unavailableminutes', 'loggedminutes', 'billableminutes', 'unbillableminutes', 'billableutilization', 'nonbillableutilization' ] }, searchTerm: { type: 'string', description: 'filter by user first or last name' }, reportFormat: { type: 'string', description: 'define the format of the report', enum: [ 'pdf' ] }, orderMode: { type: 'string', description: 'group by', enum: [ 'weekly', 'monthly' ] }, orderBy: { type: 'string', description: 'sort by', enum: [ 'name', 'percentutilization', 'percentestimatedutilization', 'availableminutes', 'unavailableminutes', 'loggedminutes', 'billableminutes', 'unbillableminutes', 'companycount', 'achieved', 'target', 'allocatedutilization', 'totalworkingminutes', 'availableutilization', 'unavailableutilization' ] }, groupBy: { type: 'string', description: 'group by', enum: [ 'day', 'week', 'month' ] }, endDate: { type: 'string', description: 'filter by end date' }, pageSize: { type: 'integer', description: 'number of items in a page' }, page: { type: 'integer', description: 'page number' }, skipCounts: { type: 'boolean', description: 'skip doing counts on a list API endpoint for performance reasons' }, legacyResponse: { type: 'boolean', description: 'return response without summary and its legacy body structure' }, isReportDownload: { type: 'boolean', description: 'generate a report document' }, isCustomDateRange: { type: 'boolean', description: 'determine if the query is for a custom date range' }, includeUtilizations: { type: 'boolean', description: 'adds report rows for individual entities' }, includeTotals: { type: 'boolean', description: 'adds report summary to response' }, includeCollaborators: { type: 'boolean', description: 'include collaborators' }, includeClients: { type: 'boolean', description: 'include client users' }, includeArchivedProjects: { type: 'boolean', description: 'include archived projects' }, IncludeCompletedTasks: { type: 'boolean', description: 'include completed tasks' }, userIds: { type: 'array', items: { type: 'integer' }, description: 'filter by userIds' }, teamIds: { type: 'array', items: { type: 'integer' }, description: 'filter by team ids' }, selectedColumns: { type: 'array', items: { type: 'string' }, description: 'customise the report by selecting columns to be displayed' }, projectIds: { type: 'array', items: { type: 'integer' }, description: 'filter by project ids' }, jobRoleIds: { type: 'array', items: { type: 'integer' }, description: 'filter by jobrole ids' }, include: { type: 'array', items: { type: 'string' }, description: 'include additional data' }, fieldsUtilizations: { type: 'array', items: { type: 'string' }, description: 'Query parameter: fields[utilizations] - specific utilization fields to include' }, fieldsUsers: { type: 'array', items: { type: 'string' }, description: 'Query parameter: fields[users] - specific user fields to include' }, companyIds: { type: 'array', items: { type: 'integer' }, description: 'filter by company ids' } } }, annotations: { title: "Get the Utilization of People in Projects", readOnlyHint: false, destructiveHint: false, openWorldHint: false } };
- src/tools/index.ts:95-95 (registration)Registration of the tool by pairing its definition and handler in the toolPairs array, which is used to generate toolDefinitions array and toolHandlersMap for MCP tool exposure.{ definition: getProjectsPeopleUtilization, handler: handleGetProjectsPeopleUtilization },
- Supporting service utility that performs the actual API request to retrieve people utilization data using the v3 API client.export async function getPeopleUtilization(params: GetPeopleUtilizationParams = {}) { const api = getApiClientForVersion('v3'); const response = await api.get('/people/utilization.json', { params }); return response.data; }