\n \n

\n `;\n};\n\n// Helper function to generate HTML from pages\nconst generateHtml = (pages: any[], title: string, additionalInfo: string = \"\") => {\n return `\n \n \n \n \n \n Showcase Pages\n \n \n \n

${title}

\n Found ${pages.length} pages ${additionalInfo}\n

\n ${page.name} \n ${page.status}\n
\n ${page.url}\n ${isYouTubeUrl(page.url) ? generateYouTubeEmbed(page.url) : ''}\n

\n \n \n `;\n};\n\n// Endpoint to get all pages from a specified database\napp.get(\"/:id\", async (c) => {\n try {\n const databaseId = c.req.param(\"id\");\n\n if (!databaseId) {\n return c.html(`\n \n \n

Error

Missing required parameter: database ID

\n \n \n `, 400);\n }\n\n // Query the database without any filters to get all pages\n const response = await notion.databases.query({\n database_id: databaseId,\n // No filter - return all pages\n });\n\n // Extract only the requested properties from each page\n const pages = response.results.map(page => {\n const properties = page.properties;\n\n return {\n id: page.id,\n name: extractTextValue(properties.Name),\n url: extractTextValue(properties.URL),\n status: extractTextValue(properties.Status),\n };\n });\n\n const html = generateHtml(pages, \"All Showcase Pages\");\n return c.html(html);\n } catch (error) {\n console.error(\"Error querying database:\", error);\n return c.html(`\n \n \n

Error

Failed to query database: ${error.message}

\n \n \n `, 500);\n }\n});\n\n// Optional filtered endpoint to get pages with specific status\napp.get(\"/:id/filtered\", async (c) => {\n try {\n const databaseId = c.req.param(\"id\");\n const statusValue = c.req.query(\"status\") || \"Embed ready\";\n\n if (!databaseId) {\n return c.html(`\n \n \n

Error

Missing required parameter: database ID

\n \n \n `, 400);\n }\n\n // Query the database with a filter for the specified status\n // Using select type for the Status property\n const response = await notion.databases.query({\n database_id: databaseId,\n filter: {\n property: \"Status\",\n select: {\n equals: statusValue,\n },\n },\n });\n\n // Extract only the requested properties from each page\n const pages = response.results.map(page => {\n const properties = page.properties;\n\n return {\n id: page.id,\n name: extractTextValue(properties.Name),\n url: extractTextValue(properties.URL),\n status: extractTextValue(properties.Status),\n };\n });\n\n const html = generateHtml(pages, `Filtered Showcase Pages`, `with status \"${statusValue}\"`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error querying database:\", error);\n return c.html(`\n \n \n

Error

Failed to query database: ${error.message}

\n \n \n `, 500);\n }\n});\n\n// Simple test endpoint\napp.get(\"/\", async (c) => {\n return c.html(`\n \n \n

Showcase HTML API

Use /showcase-html/:database_id to get all pages from a database as HTML

\n \n \n `);\n});\n\nexport default app;","deleted","label",[170,153],"routes","permalink","https://www.val.town/x/yawnxyz/bragreel/code/routes/showcaseHTML.tsx","extension","actionData","errors"]