Hello, ${name}!

This page is rendered using Hono on Val Town.

\n View Source\n

\n \n \n `);\n});\n\nexport default async function(req: Request): Promise {\n return app.fetch(req);\n}",[],[194],{"_104":202,"_95":203,"_154":204,"_156":-5,"_157":139,"_158":101,"_160":22,"_106":205,"_100":178,"_163":164,"_165":206,"_167":22,"_168":-5,"_169":207,"_98":208},"6fbf0622-3865-11f0-934c-9e149126039e","notion_db.tsx","8b23afd0-3860-11f0-b829-9e149126039e",["D",1748066876604],"import { Client } from \"npm:@notionhq/client@2.2.3\";\n\n// Types for Notion database operations\ninterface NotionPage {\n id: string;\n properties: Record;\n created_time: string;\n last_edited_time: string;\n}\n\ninterface DatabaseQueryOptions {\n filter?: any;\n sorts?: any[];\n start_cursor?: string;\n page_size?: number;\n}\n\nclass NotionDatabase {\n private client: Client;\n \n constructor() {\n const token = Deno.env.get('NOTION_TOKEN');\n if (!token) {\n throw new Error('NOTION_TOKEN environment variable is required');\n }\n this.client = new Client({ auth: token });\n }\n\n /**\n * Query a database with optional filters and sorting\n */\n async queryDatabase(databaseId: string, options: DatabaseQueryOptions = {}): Promise {\n try {\n const response = await this.client.databases.query({\n database_id: databaseId,\n filter: options.filter,\n sorts: options.sorts,\n start_cursor: options.start_cursor,\n page_size: options.page_size || 100,\n });\n\n return response.results as NotionPage[];\n } catch (error) {\n console.error('Error querying database:', error);\n throw error;\n }\n }\n\n /**\n * Get database schema/structure\n */\n async getDatabaseSchema(databaseId: string) {\n try {\n const response = await this.client.databases.retrieve({\n database_id: databaseId,\n });\n return response.properties;\n } catch (error) {\n console.error('Error getting database schema:', error);\n throw error;\n }\n }\n\n\n\n /**\n * Get a specific page by ID\n */\n async getPage(pageId: string) {\n try {\n const response = await this.client.pages.retrieve({\n page_id: pageId,\n });\n return response;\n } catch (error) {\n console.error('Error getting page:', error);\n throw error;\n }\n }\n\n /**\n * Search for pages across the workspace\n */\n async searchPages(query: string, filter?: any) {\n try {\n const response = await this.client.search({\n query,\n filter,\n });\n return response.results;\n } catch (error) {\n console.error('Error searching pages:', error);\n throw error;\n }\n }\n}\n\n// HTTP endpoint for testing\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const action = url.searchParams.get('action') || 'query';\n \n try {\n // Check environment variables first\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (action === 'debug') {\n return new Response(JSON.stringify({\n environment_check: {\n notion_token_exists: !!notionToken,\n notion_token_length: notionToken?.length || 0,\n notion_token_prefix: notionToken?.substring(0, 10) + '...' || 'not set',\n database_id_exists: !!databaseId,\n database_id_length: databaseId?.length || 0,\n database_id_prefix: databaseId?.substring(0, 10) + '...' || 'not set'\n }\n }, null, 2), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n \n if (!notionToken) {\n return new Response(JSON.stringify({\n error: 'NOTION_TOKEN environment variable is required',\n setup_instructions: {\n step1: 'Go to https://www.notion.so/my-integrations',\n step2: 'Create a new integration',\n step3: 'Copy the Internal Integration Token',\n step4: 'Set NOTION_TOKEN environment variable in Val Town',\n step5: 'Share your database with the integration'\n }\n }), {\n status: 400,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n \n if (!databaseId) {\n return new Response(JSON.stringify({\n error: 'NOTION_DATABASE_ID environment variable is required',\n setup_instructions: {\n step1: 'Open your Notion database',\n step2: 'Copy the database ID from the URL',\n step3: 'URL format: https://notion.so/[workspace]/[DATABASE_ID]?v=...',\n step4: 'Set NOTION_DATABASE_ID environment variable in Val Town'\n }\n }), {\n status: 400,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n const notion = new NotionDatabase();\n let result;\n\n switch (action) {\n case 'schema':\n // Get database schema\n result = await notion.getDatabaseSchema(databaseId);\n break;\n \n case 'query':\n // Query all pages (default action)\n const pages = await notion.queryDatabase(databaseId);\n result = {\n total_pages: pages.length,\n pages: pages\n };\n break;\n \n case 'example':\n // Run the full example\n result = await exampleUsage();\n break;\n \n case 'create':\n // Create a test page\n result = await notion.createPage({\n parent: { database_id: databaseId },\n properties: {\n // Adjust these property names to match your actual database schema\n \"Name\": NotionPropertyHelpers.title(`Test Page ${new Date().toISOString()}`),\n \"Description\": NotionPropertyHelpers.richText(\"Created via API test\"),\n \"Created\": NotionPropertyHelpers.date(new Date().toISOString().split('T')[0])\n }\n });\n break;\n \n default:\n return new Response(JSON.stringify({\n error: 'Invalid action',\n available_actions: ['query', 'schema', 'create', 'example', 'debug'],\n usage: {\n debug: '?action=debug - Check environment variables',\n query: '?action=query - Get all pages from database',\n schema: '?action=schema - Get database structure',\n create: '?action=create - Create a test page',\n example: '?action=example - Run full example'\n }\n }), {\n status: 400,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(JSON.stringify(result, null, 2), {\n headers: { 'Content-Type': 'application/json' }\n });\n\n } catch (error) {\n console.error('Notion API Error:', error);\n return new Response(JSON.stringify({\n error: error.message,\n error_type: error.constructor.name,\n stack: error.stack,\n troubleshooting: {\n common_issues: [\n 'Invalid API token - check NOTION_TOKEN',\n 'Database not shared with integration',\n 'Invalid database ID - check NOTION_DATABASE_ID',\n 'Integration lacks proper permissions'\n ]\n }\n }, null, 2), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n}\n\n// Export for direct usage\nexport { NotionDatabase };",[],[203],{"_104":210,"_95":99,"_154":211,"_156":-5,"_157":139,"_158":212,"_160":22,"_106":213,"_100":188,"_163":164,"_165":214,"_167":22,"_168":-5,"_169":215,"_98":216},"cf1ca294-293f-11f0-942b-569c3dd06744","b26e9ab2-293f-11f0-ab82-569c3dd06744",21,["D",1746401448283],"export default function server(request: Request): Response {\n const randomNumber = Math.floor(Math.random() * 100) + 1;\n const responseData = { randomNumber: randomNumber };\n\n return new Response(JSON.stringify(responseData, null, 2), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}",[],[99],"files",[151,172,182,192,201,209],"counts",{"_221":32,"_222":223,"_224":32,"_225":226},"pulls","branches",1,"forks","envVars",{"_227":228,"_229":32},"count",2,"emptyCount","contents",[],"file",{"_104":210,"_95":99,"_154":211,"_156":-5,"_157":139,"_158":212,"_160":22,"_106":234,"_100":188,"_163":164,"_165":214,"_167":22,"_168":-5,"_98":235},["D",1746401448283],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":244,"_149":249,"_217":268,"_232":269,"_230":271,"_272":-5,"_273":-5,"_274":-5,"_275":-5,"_276":277},{"_104":105,"_95":96,"_106":245,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":118,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":246,"_133":247,"_136":248,"_148":22},["D",1746324657181],{"_93":94,"_131":132},{"_93":94,"_135":132,"_14":114},{"_100":138,"_95":43,"_104":139,"_140":105,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[250,253,256,259,262,265],{"_104":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":22,"_106":161,"_100":162,"_163":164,"_165":166,"_167":22,"_168":-5,"_169":251,"_98":252},[],[153],{"_104":173,"_95":174,"_154":175,"_156":-5,"_157":139,"_158":176,"_160":22,"_106":177,"_100":178,"_163":164,"_165":179,"_167":22,"_168":-5,"_169":254,"_98":255},[],[174],{"_104":183,"_95":184,"_154":185,"_156":-5,"_157":139,"_158":186,"_160":22,"_106":187,"_100":188,"_163":164,"_165":189,"_167":22,"_168":-5,"_169":257,"_98":258},[],[184],{"_104":193,"_95":194,"_154":195,"_156":-5,"_157":139,"_158":196,"_160":22,"_106":197,"_100":188,"_163":164,"_165":198,"_167":22,"_168":-5,"_169":260,"_98":261},[],[194],{"_104":202,"_95":203,"_154":204,"_156":-5,"_157":139,"_158":101,"_160":22,"_106":205,"_100":178,"_163":164,"_165":206,"_167":22,"_168":-5,"_169":263,"_98":264},[],[203],{"_104":210,"_95":99,"_154":211,"_156":-5,"_157":139,"_158":212,"_160":22,"_106":213,"_100":188,"_163":164,"_165":214,"_167":22,"_168":-5,"_169":266,"_98":267},[],[99],[250,253,256,259,262,265],{"_104":210,"_95":99,"_154":211,"_156":-5,"_157":139,"_158":212,"_160":22,"_106":234,"_100":188,"_163":164,"_165":214,"_167":22,"_168":-5,"_98":270},[99],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

chadparker

notion