list_projects
Retrieve and filter ServiceNow projects by state, assignment group, or timeframe to manage project visibility and track progress.
Instructions
List projects from ServiceNow
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| assignment_group | No | Filter by assignment group | |
| limit | No | Maximum number of records to return | |
| offset | No | Offset to start from | |
| query | No | Additional query string | |
| state | No | Filter by state | |
| timeframe | No | Filter by timeframe (upcoming, in-progress, completed) |
Implementation Reference
- The main handler function that implements the list_projects tool. It validates input parameters using ListProjectsParams, builds a ServiceNow REST API query based on filters like state, assignment_group, timeframe, and query, then fetches and returns the list of projects.def list_projects( config: ServerConfig, # Changed from auth_manager auth_manager: AuthManager, # Changed from server_config params: Dict[str, Any], ) -> Dict[str, Any]: """ List projects from ServiceNow. Args: config: The server configuration. auth_manager: The authentication manager. params: The parameters for listing projects. Returns: A list of projects. """ # Unwrap and validate parameters result = _unwrap_and_validate_params( params, ListProjectsParams ) if not result["success"]: return result validated_params = result["params"] # Build the query query_parts = [] if validated_params.state: query_parts.append(f"state={validated_params.state}") if validated_params.assignment_group: query_parts.append(f"assignment_group={validated_params.assignment_group}") # Handle timeframe filtering if validated_params.timeframe: now = datetime.now().strftime("%Y-%m-%d %H:%M:%S") if validated_params.timeframe == "upcoming": query_parts.append(f"start_date>{now}") elif validated_params.timeframe == "in-progress": query_parts.append(f"start_date<{now}^end_date>{now}") elif validated_params.timeframe == "completed": query_parts.append(f"end_date<{now}") # Add any additional query string if validated_params.query: query_parts.append(validated_params.query) # Combine query parts query = "^".join(query_parts) if query_parts else "" # Get the instance URL instance_url = _get_instance_url(auth_manager, config) if not instance_url: return { "success": False, "message": "Cannot find instance_url in either server_config or auth_manager", } # Get the headers headers = _get_headers(auth_manager, config) if not headers: return { "success": False, "message": "Cannot find get_headers method in either auth_manager or server_config", } # Make the API request url = f"{instance_url}/api/now/table/pm_project" params = { "sysparm_limit": validated_params.limit, "sysparm_offset": validated_params.offset, "sysparm_query": query, "sysparm_display_value": "true", } try: response = requests.get(url, headers=headers, params=params) response.raise_for_status() result = response.json() # Handle the case where result["result"] is a list projects = result.get("result", []) count = len(projects) return { "success": True, "projects": projects, "count": count, "total": count, # Use count as total if total is not provided } except requests.exceptions.RequestException as e: logger.error(f"Error listing projects: {e}") return { "success": False, "message": f"Error listing projects: {str(e)}", }
- Pydantic BaseModel defining the input schema for the list_projects tool, including optional parameters for pagination, filtering by state, group, timeframe, and custom query.class ListProjectsParams(BaseModel): """Parameters for listing projects.""" limit: Optional[int] = Field(10, description="Maximum number of records to return") offset: Optional[int] = Field(0, description="Offset to start from") state: Optional[str] = Field(None, description="Filter by state") assignment_group: Optional[str] = Field(None, description="Filter by assignment group") timeframe: Optional[str] = Field(None, description="Filter by timeframe (upcoming, in-progress, completed)") query: Optional[str] = Field(None, description="Additional query string")
- src/servicenow_mcp/utils/tool_utils.py:938-944 (registration)Tool registration in get_tool_definitions dictionary, associating the aliased list_projects_tool function, ListProjectsParams schema, description, and serialization handling."list_projects": ( list_projects_tool, ListProjectsParams, str, # Expects JSON string "List projects from ServiceNow", "json", # Tool returns list/dict ),
- src/servicenow_mcp/utils/tool_utils.py:326-335 (registration)Import and alias of the list_projects handler and ListProjectsParams schema from project_tools.py for use in tool registration.from servicenow_mcp.tools.project_tools import ( CreateProjectParams, UpdateProjectParams, ListProjectsParams, ) from servicenow_mcp.tools.project_tools import ( create_project as create_project_tool, update_project as update_project_tool, list_projects as list_projects_tool, )
- src/servicenow_mcp/tools/__init__.py:110-114 (registration)Import of list_projects into the tools package __init__.py for exposure to other modules.from servicenow_mcp.tools.project_tools import ( create_project, update_project, list_projects, )