script_projects_get_content
Retrieve the content of a Google Apps Script project by providing its script ID to access code and files for editing or analysis.
Instructions
Get the content of a Google Apps Script project.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| scriptId | Yes | The ID of the script project to retrieve content for. | |
| versionNumber | No | The version number of the script project. | |
| fields | No | Selector specifying which fields to include in a partial response. | |
| alt | No | Data format for response. | |
| key | No | API key for the project. | |
| access_token | No | OAuth access token. | |
| prettyPrint | No | Returns response with indentations and line breaks. |
Implementation Reference
- The main handler function that performs the HTTP GET request to retrieve the content of a Google Apps Script project using OAuth authentication.const executeFunction = async ({ scriptId, versionNumber, fields, alt = "json", key, access_token, prettyPrint = "true" }) => { const baseUrl = 'https://script.googleapis.com'; const startTime = Date.now(); try { logger.info('SCRIPT_GET_CONTENT', 'Starting script content retrieval', { scriptId, versionNumber }); // Get OAuth access token const token = await getOAuthAccessToken(); // Construct the URL with query parameters const url = new URL(`${baseUrl}/v1/projects/${scriptId}/content`); if (versionNumber) url.searchParams.append('versionNumber', versionNumber); if (fields) url.searchParams.append('fields', fields); url.searchParams.append('alt', alt); if (key) url.searchParams.append('key', key); if (prettyPrint) url.searchParams.append('prettyPrint', prettyPrint); logger.debug('SCRIPT_GET_CONTENT', 'Constructed API URL', { url: url.toString(), pathSegments: url.pathname.split('/'), queryParams: Object.fromEntries(url.searchParams) }); // Set up headers for the request const headers = { 'Accept': 'application/json', 'Authorization': `Bearer ${token}` }; logger.logAPICall('GET', url.toString(), headers); // Perform the fetch request const fetchStartTime = Date.now(); const response = await fetch(url.toString(), { method: 'GET', headers }); const fetchDuration = Date.now() - fetchStartTime; const responseSize = response.headers.get('content-length') || 'unknown'; logger.logAPIResponse('GET', url.toString(), response.status, fetchDuration, responseSize); // Check if the response was successful if (!response.ok) { const errorText = await response.text(); let errorData; try { errorData = JSON.parse(errorText); } catch (parseError) { errorData = { message: errorText }; } const detailedError = { status: response.status, statusText: response.statusText, url: url.toString(), errorResponse: errorData, duration: Date.now() - startTime, scriptId, versionNumber, timestamp: new Date().toISOString() }; logger.error('SCRIPT_GET_CONTENT', 'API request failed', detailedError); console.error('❌ API Error Details:', JSON.stringify(detailedError, null, 2)); throw new Error(`API Error (${response.status}): ${errorData.error?.message || errorData.message || 'Unknown error'}`); } // Parse and return the response data const data = await response.json(); logger.info('SCRIPT_GET_CONTENT', 'Successfully retrieved script content', { scriptId, versionNumber, filesCount: data.files?.length || 0, duration: Date.now() - startTime }); console.log('✅ Successfully retrieved script content'); return data; } catch (error) { const errorDetails = { message: error.message, stack: error.stack, scriptId, versionNumber, duration: Date.now() - startTime, timestamp: new Date().toISOString(), errorType: error.name || 'Unknown' }; logger.error('SCRIPT_GET_CONTENT', 'Error getting script project content', errorDetails); console.error('❌ Error getting script project content:', errorDetails); // Return detailed error information for debugging return { error: true, message: error.message, details: errorDetails, rawError: { name: error.name, stack: error.stack } }; } };
- Defines the MCP tool schema, including the function name, description, parameters (with scriptId required), and references the handler function.const apiTool = { function: executeFunction, definition: { type: 'function', function: { name: 'script_projects_get_content', description: 'Get the content of a Google Apps Script project.', parameters: { type: 'object', properties: { scriptId: { type: 'string', description: 'The ID of the script project to retrieve content for.' }, versionNumber: { type: 'string', description: 'The version number of the script project.' }, fields: { type: 'string', description: 'Selector specifying which fields to include in a partial response.' }, alt: { type: 'string', description: 'Data format for response.' }, key: { type: 'string', description: 'API key for the project.' }, access_token: { type: 'string', description: 'OAuth access token.' }, prettyPrint: { type: 'string', description: 'Returns response with indentations and line breaks.' } }, required: ['scriptId'] } } } }; export { apiTool };
- tools/paths.js:14-14 (registration)The tool file path is listed in toolPaths array, enabling dynamic import and registration during tool discovery.'google-app-script-api/apps-script-api/script-projects-get-content.js',
- lib/tools.js:8-64 (registration)The discoverTools function dynamically imports and registers all tools, including script_projects_get_content, by loading modules from toolPaths and extracting their apiTool.export async function discoverTools() { logger.info('DISCOVERY', `Starting tool discovery for ${toolPaths.length} tool paths`); const toolPromises = toolPaths.map(async (file) => { try { logger.debug('DISCOVERY', `Loading tool from: ${file}`); const module = await import(`../tools/${file}`); if (!module.apiTool) { logger.warn('DISCOVERY', `Tool file missing apiTool export: ${file}`); return null; } const toolName = module.apiTool.definition?.function?.name; if (!toolName) { logger.warn('DISCOVERY', `Tool missing function name: ${file}`); return null; } // Wrap the original function with logging const originalFunction = module.apiTool.function; const wrappedFunction = withLogging(toolName, originalFunction); logger.debug('DISCOVERY', `Successfully loaded tool: ${toolName}`, { file, toolName, description: module.apiTool.definition?.function?.description }); return { ...module.apiTool, function: wrappedFunction, path: file, }; } catch (error) { logger.error('DISCOVERY', `Failed to load tool: ${file}`, { file, error: { message: error.message, stack: error.stack } }); return null; } }); const tools = (await Promise.all(toolPromises)).filter(Boolean); logger.info('DISCOVERY', `Tool discovery completed`, { totalPaths: toolPaths.length, successfullyLoaded: tools.length, failed: toolPaths.length - tools.length, toolNames: tools.map(t => t.definition?.function?.name).filter(Boolean) }); return tools; }