Error

Failed to query database: ${error.message}

\n \n \n `,\n 500,\n );\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 \n

Error

Missing required parameter: database ID

\n \n \n `,\n 400,\n );\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 \n

Error

Failed to query database: ${error.message}

\n \n \n `,\n 500,\n );\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",[168,150],"routes","permalink","https://www.val.town/x/lightweight/bragreel/code/routes/showcaseHTML.tsx","extension","actionData","errors"]