Favicon Extractor Tester

\n \n

Direct Favicon Extraction

\n \n

Result:

\n $\"Favicon\"$ \n

Favicon URL:

Content Type:

Error:

\n \n

Notion Webhook Test

\n \n

Result:

Error:

\n\n \n\n",[],[154,172],[154],{"_103":181,"_95":182,"_155":183,"_157":-5,"_158":138,"_159":118,"_160":161,"_105":184,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":185,"_99":265},"33e2e314-36a6-11f0-a171-9e149126039e","routes","125f3a7b-46d3-454f-8de7-296b668d61cc",["D",1747874791137],[186,194,204,212,221,229,239,249,257],{"_103":187,"_95":188,"_155":189,"_157":183,"_158":138,"_159":118,"_160":161,"_105":190,"_100":32,"_163":175,"_165":191,"_166":22,"_167":-5,"_168":192,"_99":193},"33e2b2ae-36a6-11f0-a171-9e149126039e","README.md","dab258ca-3415-4014-acaa-21e6bfe5c42c",["D",1747874791137],"# Routes Directory\n\nThis directory contains modular route handlers for the API.\n\n## Current Routes\n\n- `favicon.ts`: Handles the `/favicon` endpoint for extracting favicons from URLs\n\n## Adding New Routes\n\nTo add a new route:\n\n1. Create a new file in this directory (e.g., `myRoute.ts`)\n2. Use the following template:\n\n```typescript\nimport { Hono } from \"https://esm.sh/hono@3.11.7\";\n\n// Create a router for the endpoint\nconst router = new Hono();\n\n// Define your routes\nrouter.get(\"/\", (c) => {\n // Handler logic\n return c.json({ message: \"Your response\" });\n});\n\nrouter.post(\"/\", async (c) => {\n // Handler logic for POST\n const body = await c.req.json();\n // Process the request\n return c.json({ result: \"Your response\" });\n});\n\n// Export the router\nexport default router;\n```\n\n3. Import and mount your router in the main `index.tsx` file:\n\n```typescript\nimport myRouter from \"./routes/myRoute.ts\";\n\n// Mount the router\napp.route(\"/my-route\", myRouter);\n```\n\nThis modular approach helps keep the codebase organized and maintainable as the API grows.",[],[182,188],{"_103":195,"_95":196,"_155":197,"_157":183,"_158":138,"_159":137,"_160":161,"_105":198,"_100":199,"_163":200,"_165":201,"_166":22,"_167":-5,"_168":202,"_99":203},"2067c0f6-3724-11f0-964b-9e149126039e","cache.tsx","fa8e6249-9d0f-49a8-8122-5781cbef29d6",["D",1747928875044],100,"script","import { blob } from \"https://esm.town/v/std/blob?v=12\";\nimport { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono\";\nimport { trimTrailingSlash } from \"npm:hono/trailing-slash\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\napp.use(trimTrailingSlash());\n\n// set the cache blob with a POST\n// the cache cron at root will update the blob that we set here, every minute\napp.post(\"/\", async (c) => {\n try {\n const { data } = await c.req.json();\n const pageId = data?.id;\n\n if (!pageId) {\n return c.json({\n success: false,\n message: \"Missing required parameter: page ID is required\",\n }, 400);\n }\n\n // Get page contents from Notion\n const page = await notion.pages.retrieve({ page_id: pageId });\n // Extract the parent database ID from the page\n let parentId = null;\n if (page.parent && page.parent.type === \"database_id\") {\n parentId = page.parent.database_id;\n }\n\n // create a blob key for the corresponding cron to use\n const blobKey = [\n c.req.path.split(\"/\").pop(), // the last bit of the path, and without any slashes\n \"db\", // prepend the blob key with something that's easy to remember and references its purpose; ie, caching a \"db\"\n parentId, // the id of the database we're cache-ing, which the cron will need\n ].join(\"--\");\n\n const blobExists = await blob.getJSON(blobKey);\n if (!blobExists) {\n await blob.setJSON(blobKey, { ok: true });\n console.log(\"setting blob: \", await blob.getJSON(blobKey));\n } else {\n console.log(`blob exists with key: ${blobKey}`, await blob.getJSON(blobKey));\n }\n return c.json(await blob.getJSON(blobKey));\n } catch (error) {\n console.error(\"Error retrieving page data:\", error);\n return c.json({\n success: false,\n message: \"Failed to retrieve page data\",\n error: error.message,\n }, 500);\n }\n});\n\n// GET endpoint for JSON, _without_ database id param\napp.get(\"/\", async (c) => {\n // build key fragment to find the blob with the database cache in it\n // note that this call does not have a webhook body or param\n // so, we have to look for the cache with a key fragment, without the database id\n const blobKey = [\n \"cache\", // this matches the path that sets the blob and tells us what the purpose of this blob is\n \"db\", // we added this bit to the key when we saved it so that we know is a database cache when we look at blob storage\n ].join(\"--\");\n\n console.log(\"blobKey: \", blobKey);\n const blobKeys = await blob.list(blobKey); // array of keys that start with the blobKey fragment\n console.log(blobKeys[0]);\n // there shouldn't be another blob prepended with the blobkey so we can use the first result\n const blobject = await blob.getJSON(blobKeys[0].key);\n\n return c.json(blobject, 200);\n});\n\n// GET endpoint for testing, with database id param\napp.get(\"/:id\", async (c) => {\n const pageId = c.req.param(\"id\");\n // cache--db--1f93adc4-3057-8077-a9db-f397aa894170\n\n if (!pageId) {\n return c.json({\n success: false,\n message: \"Missing required parameter: page ID is required\",\n }, 400);\n }\n\n // build key fragment to find the blob with the database cache in it\n const blobKey = [\n \"cache\", // this matches the path that sets the blob and tells us what the purpose of this blob is\n \"db\", // we added this bit to the key when we saved it so that we know is a database cache when we look at blob storage\n pageId,\n ].join(\"--\");\n // get blob with database JSON\n const blobject = await blob.getJSON(blobKey); // array of keys that start with the blobKey fragment\n // console.log(blobKeys[0]);\n // const cachedDB = await blob.getJSON(blobKeys[0].key);\n\n return c.json(blobject);\n});\n\nexport default app;",[],[182,196],{"_103":205,"_95":206,"_155":207,"_157":183,"_158":138,"_159":118,"_160":161,"_105":208,"_100":32,"_163":200,"_165":209,"_166":22,"_167":-5,"_168":210,"_99":211},"33e2b8b2-36a6-11f0-a171-9e149126039e","domain.tsx","b54d27d2-829d-49ae-9d35-53c2f9023a4a",["D",1747874791137],"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\nimport { getDomain } from \"../utils/getDomain.tsx\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n const { data } = await c.req.json();\n const pageId = data?.id;\n // console.log(pageId);\n\n // get page contents from notion\n const page = await notion.pages.retrieve({ page_id: pageId });\n\n const url = page?.properties?.URL?.url;\n const domain = getDomain(url);\n // console.log(domain);\n\n await notion.pages.update({\n page_id: pageId,\n properties: {\n Domain: {\n type: \"rich_text\",\n rich_text: [\n {\n type: \"text\",\n text: {\n content: domain,\n },\n },\n ],\n },\n },\n });\n\n console.log(page);\n return c.json(page);\n});\n\n// add sample endpoint here to test if API calls from scripts work\napp.get(\"/\", async (c) => {\n return c.text(\"Hello World!\");\n});\n\nexport default app;",[],[182,206],{"_103":213,"_95":214,"_155":215,"_157":183,"_158":138,"_159":216,"_160":161,"_105":217,"_100":118,"_163":200,"_165":218,"_166":22,"_167":-5,"_168":219,"_99":220},"07261cc0-3718-11f0-ae12-9e149126039e","embed.tsx","b6865cc7-6ba3-4414-aea8-c1a456bc71c2",329,["D",1747923678711],"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n try {\n const { data } = await c.req.json();\n const pageId = data?.id;\n // console.log(pageId);\n\n // get page contents from notion\n const page = await notion.pages.retrieve({ page_id: pageId });\n\n const url = page?.properties?.URL?.url;\n\n // Extract the Name property from the page\n let nameValue = \"\";\n if (page?.properties?.Name) {\n // Handle different property types for Name\n if (page.properties.Name.type === \"title\" && page.properties.Name.title.length > 0) {\n nameValue = page.properties.Name.title.map(text => text.plain_text).join(\"\");\n } else if (page.properties.Name.type === \"rich_text\" && page.properties.Name.rich_text.length > 0) {\n nameValue = page.properties.Name.rich_text.map(text => text.plain_text).join(\"\");\n }\n }\n\n // Extract the Date property from the page\n let dateValue = \"\";\n if (page?.properties?.Date && page.properties.Date.type === \"date\" && page.properties.Date.date) {\n const dateObj = page.properties.Date.date;\n // Format: YYYY-MM-DD or with time if available\n dateValue = dateObj.start;\n\n // Format the date for better readability if needed\n try {\n const date = new Date(dateValue);\n dateValue = date.toLocaleDateString(\"en-US\", {\n weekday: \"long\",\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n });\n } catch (e) {\n // If date parsing fails, use the original value\n console.error(\"Error formatting date:\", e);\n }\n }\n\n // const { pageId, url } = await c.req.json();\n\n if (!pageId || !url) {\n return c.json({\n success: false,\n message: \"Missing required parameters: pageId and url are required\",\n }, 400);\n }\n\n // First, retrieve all existing blocks (children) of the page\n const existingBlocks = await notion.blocks.children.list({\n block_id: pageId,\n });\n\n // Delete all existing blocks\n for (const block of existingBlocks.results) {\n await notion.blocks.delete({\n block_id: block.id,\n });\n }\n\n // Extract page icon if it exists\n let pageIcon = null;\n if (page.icon) {\n if (page.icon.type === \"emoji\") {\n pageIcon = {\n type: \"emoji\",\n emoji: page.icon.emoji,\n };\n } else if (page.icon.type === \"external\") {\n pageIcon = {\n type: \"external\",\n external: {\n url: page.icon.external.url,\n },\n };\n } else if (page.icon.type === \"file\") {\n pageIcon = {\n type: \"external\",\n external: {\n url: page.icon.file.url,\n },\n };\n }\n }\n\n // Add an embed block to the now-empty page\n const response = await notion.blocks.children.append({\n block_id: pageId,\n children: [\n // Add a callout block to contain the page properties\n {\n type: \"callout\",\n callout: {\n rich_text: [\n {\n type: \"text\",\n text: {\n content: nameValue || \"Untitled\",\n },\n annotations: {\n bold: true,\n },\n },\n ],\n // Use the page icon for the callout if available, otherwise use a default emoji\n icon: pageIcon || {\n type: \"emoji\",\n emoji: \"⛷️\",\n },\n color: \"gray_background\",\n children: [\n // Add h1 heading with the Name property value\n // {\n // type: \"heading_2\",\n // heading_2: {\n // rich_text: [\n // {\n // type: \"text\",\n // text: {\n // content: nameValue || \"Untitled\",\n // },\n // },\n // ],\n // },\n // },\n // Add date paragraph if date value exists\n ...(dateValue\n ? [{\n type: \"paragraph\",\n paragraph: {\n rich_text: [\n {\n type: \"text\",\n text: {\n content: dateValue,\n },\n },\n ],\n },\n }]\n : []),\n // Add the embed block (inside the callout)\n {\n type: \"embed\",\n embed: {\n url: url,\n },\n },\n // Add paragraph with link to the URL\n {\n type: \"paragraph\",\n paragraph: {\n rich_text: [\n {\n type: \"text\",\n text: {\n content: \"Source: \",\n },\n },\n {\n type: \"text\",\n text: {\n content: url,\n link: {\n url: url,\n },\n },\n },\n ],\n },\n },\n ],\n },\n },\n ],\n });\n\n return c.json({\n success: true,\n message: \"Embed added successfully\",\n pageId,\n url,\n response,\n });\n } catch (error) {\n console.error(\"Error adding embed:\", error);\n return c.json({\n success: false,\n message: \"Failed to add embed\",\n error: error.message,\n }, 500);\n }\n});\n\n// add sample endpoint here to test if API calls from scripts work\napp.get(\"/\", async (c) => {\n return c.text(\"Hello World!\");\n});\n\nexport default app;",[],[182,214],{"_103":222,"_95":223,"_155":224,"_157":183,"_158":138,"_159":118,"_160":161,"_105":225,"_100":32,"_163":200,"_165":226,"_166":22,"_167":-5,"_168":227,"_99":228},"33e2bff6-36a6-11f0-a171-9e149126039e","favicon.tsx","b48583ef-8e6c-4ed0-80c0-6eae8f11bd41",["D",1747874791137],"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst router = new Hono();\n\n// Helper function to extract favicon from a URL\nasync function extractFavicon(url: string) {\n console.log(`Attempting to extract favicon from URL: ${url}`);\n\n // Validate URL format\n let targetUrl;\n try {\n targetUrl = new URL(url);\n } catch (error) {\n console.error(`Invalid URL format: ${url}`, error);\n return { success: false, error: \"Invalid URL format\" };\n }\n\n // Try Google Favicon API first (most reliable)\n const googleFaviconUrl = `https://www.google.com/s2/favicons?domain=${targetUrl.hostname}&sz=128`;\n console.log(`Trying Google Favicon API: ${googleFaviconUrl}`);\n\n try {\n const googleFaviconResponse = await fetch(googleFaviconUrl, { method: \"HEAD\" });\n if (googleFaviconResponse.ok) {\n console.log(`Successfully found favicon via Google Favicon API: ${googleFaviconUrl}`);\n return {\n success: true,\n faviconUrl: googleFaviconUrl,\n contentType: \"image/png\", // Google Favicon API returns PNG\n source: \"google_api\",\n };\n }\n } catch (error) {\n console.error(`Error fetching favicon from Google Favicon API:`, error);\n }\n\n // Try to fetch the favicon directly\n const faviconUrl = `${targetUrl.protocol}//${targetUrl.host}/favicon.ico`;\n console.log(`Trying direct favicon URL: ${faviconUrl}`);\n\n try {\n const faviconResponse = await fetch(faviconUrl);\n\n if (faviconResponse.ok) {\n // Get the content type\n const contentType = faviconResponse.headers.get(\"content-type\") || \"image/x-icon\";\n console.log(`Found favicon directly at ${faviconUrl} with content type: ${contentType}`);\n\n return {\n success: true,\n faviconUrl,\n contentType,\n };\n } else {\n console.log(`Direct favicon not found at ${faviconUrl}, status: ${faviconResponse.status}`);\n }\n } catch (error) {\n console.error(`Error fetching favicon directly from ${faviconUrl}:`, error);\n }\n\n // If direct favicon fetch fails, try to extract from HTML\n console.log(`Trying to extract favicon from HTML of ${url}`);\n try {\n const pageResponse = await fetch(url);\n if (!pageResponse.ok) {\n console.error(`Failed to fetch page HTML from ${url}, status: ${pageResponse.status}`);\n return { success: false, error: `Failed to fetch page HTML, status: ${pageResponse.status}` };\n }\n\n const html = await pageResponse.text();\n\n // Try multiple favicon patterns\n // 1. Standard favicon link\n const faviconRegex = /]*rel=[\\\"'](?:shortcut )?icon[\\\"'][^>]*href=[\\\"']([^\\\"']+)[\\\"'][^>]*>/i;\n let match = html.match(faviconRegex);\n\n // 2. Apple touch icon (often higher quality)\n if (!match) {\n const appleTouchIconRegex = /]*rel=[\\\"']apple-touch-icon[\\\"'][^>]*href=[\\\"']([^\\\"']+)[\\\"'][^>]*>/i;\n match = html.match(appleTouchIconRegex);\n console.log(`Trying apple-touch-icon as fallback`);\n }\n\n // 3. Any image with \"favicon\" in the name or path\n if (!match) {\n const anyFaviconRegex = /href=[\\\"']([^\\\"']*favicon[^\\\"']*)[\\\"']/i;\n match = html.match(anyFaviconRegex);\n console.log(`Trying any favicon-named resource as fallback`);\n }\n\n if (match && match[1]) {\n let extractedFaviconUrl = match[1];\n console.log(`Found favicon in HTML: ${extractedFaviconUrl}`);\n\n // Handle relative URLs\n if (extractedFaviconUrl.startsWith(\"/\")) {\n extractedFaviconUrl = `${targetUrl.protocol}//${targetUrl.host}${extractedFaviconUrl}`;\n } else if (!extractedFaviconUrl.startsWith(\"http\")) {\n extractedFaviconUrl = new URL(extractedFaviconUrl, url).href;\n }\n\n console.log(`Resolved favicon URL: ${extractedFaviconUrl}`);\n\n try {\n const faviconResponse = await fetch(extractedFaviconUrl);\n\n if (faviconResponse.ok) {\n const contentType = faviconResponse.headers.get(\"content-type\") || \"image/x-icon\";\n console.log(`Successfully fetched favicon from ${extractedFaviconUrl} with content type: ${contentType}`);\n\n return {\n success: true,\n faviconUrl: extractedFaviconUrl,\n contentType,\n };\n } else {\n console.error(\n `Failed to fetch extracted favicon from ${extractedFaviconUrl}, status: ${faviconResponse.status}`,\n );\n }\n } catch (error) {\n console.error(`Error fetching extracted favicon from ${extractedFaviconUrl}:`, error);\n }\n } else {\n console.log(`No favicon link found in HTML of ${url}`);\n }\n } catch (error) {\n console.error(`Error extracting favicon from HTML of ${url}:`, error);\n }\n\n // If all attempts fail, return to Google Favicon API as a last resort\n // This is a fallback in case we skipped it due to a temporary error\n return {\n success: true,\n faviconUrl: googleFaviconUrl,\n contentType: \"image/png\",\n source: \"google_api_fallback\",\n };\n}\n\n// Main endpoint for handling favicon requests\nrouter.post(\"/\", async (c) => {\n try {\n // Parse the request body to get the data\n const { data } = await c.req.json();\n const pageId = data?.id;\n\n console.log(`Processing favicon request for Notion page: ${pageId}`);\n\n if (!pageId) {\n return c.json({\n success: false,\n error: \"Invalid payload. Required field: data.id\",\n }, 400);\n }\n\n // Get the page data from Notion\n let page;\n try {\n page = await notion.pages.retrieve({ page_id: pageId });\n console.log(`Successfully retrieved Notion page: ${pageId}`);\n } catch (error) {\n console.error(`Failed to retrieve Notion page ${pageId}:`, error);\n return c.json({\n success: false,\n error: \"Failed to retrieve Notion page\",\n message: error.message,\n pageId,\n }, 500);\n }\n\n // Try to extract URL property first (if it exists)\n let url = null;\n\n if (page.properties.URL && page.properties.URL.type === \"url\" && page.properties.URL.url) {\n url = page.properties.URL.url;\n console.log(`Found URL property: ${url}`);\n }\n // If URL property doesn't exist or is empty, try Domain property\n else if (page.properties.Domain) {\n if (page.properties.Domain.type === \"url\" && page.properties.Domain.url) {\n url = page.properties.Domain.url;\n console.log(`Found Domain property (URL type): ${url}`);\n }\n // If Domain property is a rich text type\n else if (\n page.properties.Domain.type === \"rich_text\"\n && page.properties.Domain.rich_text.length > 0\n ) {\n const domainText = page.properties.Domain.rich_text[0].plain_text;\n // Add protocol if missing\n url = domainText.startsWith(\"http\") ? domainText : `https://${domainText}`;\n console.log(`Found Domain property (rich text type): ${domainText}, converted to: ${url}`);\n }\n }\n\n if (!url) {\n console.error(`No URL or Domain property found in Notion page ${pageId}`);\n return c.json({\n success: false,\n error: \"No URL or Domain property found in the Notion page\",\n pageId,\n }, 404);\n }\n\n // Extract favicon from the URL\n const faviconResult = await extractFavicon(url);\n\n if (!faviconResult.success) {\n console.error(`Could not find favicon for URL: ${url}`);\n\n // Try with emoji as a fallback\n try {\n console.log(`Using emoji fallback for page icon`);\n await notion.pages.update({\n page_id: pageId,\n icon: {\n type: \"emoji\",\n emoji: \"🌐\", // Web globe emoji as fallback\n },\n });\n\n return c.json({\n success: true,\n message: \"Used emoji fallback for page icon (favicon extraction failed)\",\n pageId,\n url,\n fallback: \"emoji\",\n });\n } catch (emojiError) {\n console.error(`Failed to update page with emoji fallback:`, emojiError);\n return c.json({\n success: false,\n error: \"Failed to update page icon with any method\",\n pageId,\n url,\n }, 500);\n }\n }\n\n // Update the Notion page with the favicon URL using the Notion client\n console.log(`Updating Notion page ${pageId} with icon URL: ${faviconResult.faviconUrl}`);\n try {\n await notion.pages.update({\n page_id: pageId,\n icon: {\n type: \"external\",\n external: {\n url: faviconResult.faviconUrl,\n },\n },\n });\n console.log(`Successfully updated Notion page ${pageId} with icon`);\n } catch (updateError) {\n console.error(`Failed to update Notion page ${pageId} with icon:`, updateError);\n\n // Try with emoji as a fallback\n try {\n console.log(`Using emoji fallback for page icon after URL method failed`);\n await notion.pages.update({\n page_id: pageId,\n icon: {\n type: \"emoji\",\n emoji: \"🌐\", // Web globe emoji as fallback\n },\n });\n\n return c.json({\n success: true,\n message: \"Used emoji fallback for page icon (favicon URL failed)\",\n pageId,\n url,\n fallback: \"emoji\",\n });\n } catch (emojiError) {\n console.error(`Failed to update page with emoji fallback:`, emojiError);\n return c.json({\n success: false,\n error: \"Failed to update page icon with any method\",\n details: {\n originalError: updateError.message,\n emojiFallbackError: emojiError.message,\n },\n pageId,\n url,\n }, 500);\n }\n }\n\n // Return success response\n return c.json({\n success: true,\n message: \"Favicon found and Notion page updated\",\n pageId,\n url,\n faviconUrl: faviconResult.faviconUrl,\n });\n } catch (error) {\n console.error(\"Error processing favicon request:\", error);\n return c.json({\n success: false,\n error: \"Failed to process request\",\n message: error.message,\n }, 500);\n }\n});\n\n// Legacy endpoint for backward compatibility\nrouter.post(\"/notion\", async (c) => {\n try {\n // Parse the webhook payload from Notion\n const payload = await c.req.json();\n\n // Validate the payload\n if (!payload.pageId) {\n return c.json({\n success: false,\n error: \"Invalid webhook payload. Required field: pageId\",\n }, 400);\n }\n\n const { pageId } = payload;\n console.log(`Processing legacy favicon request for Notion page: ${pageId}`);\n\n // Get the page data from Notion\n let page;\n try {\n page = await notion.pages.retrieve({ page_id: pageId });\n console.log(`Successfully retrieved Notion page: ${pageId}`);\n } catch (error) {\n console.error(`Failed to retrieve Notion page ${pageId}:`, error);\n return c.json({\n success: false,\n error: \"Failed to retrieve Notion page\",\n message: error.message,\n pageId,\n }, 500);\n }\n\n // Try to extract URL property first (if it exists)\n let url = null;\n\n if (page.properties.URL && page.properties.URL.type === \"url\" && page.properties.URL.url) {\n url = page.properties.URL.url;\n console.log(`Found URL property: ${url}`);\n }\n // If URL property doesn't exist or is empty, try Domain property\n else if (page.properties.Domain) {\n if (page.properties.Domain.type === \"url\" && page.properties.Domain.url) {\n url = page.properties.Domain.url;\n console.log(`Found Domain property (URL type): ${url}`);\n }\n // If Domain property is a rich text type\n else if (\n page.properties.Domain.type === \"rich_text\"\n && page.properties.Domain.rich_text.length > 0\n ) {\n const domainText = page.properties.Domain.rich_text[0].plain_text;\n // Add protocol if missing\n url = domainText.startsWith(\"http\") ? domainText : `https://${domainText}`;\n console.log(`Found Domain property (rich text type): ${domainText}, converted to: ${url}`);\n }\n }\n\n if (!url) {\n console.error(`No URL or Domain property found in Notion page ${pageId}`);\n return c.json({\n success: false,\n error: \"No URL or Domain property found in the Notion page\",\n pageId,\n }, 404);\n }\n\n // Extract favicon from the URL\n const faviconResult = await extractFavicon(url);\n\n if (!faviconResult.success) {\n console.error(`Could not find favicon for URL: ${url}`);\n\n // Try with emoji as a fallback\n try {\n console.log(`Using emoji fallback for page icon`);\n await notion.pages.update({\n page_id: pageId,\n icon: {\n type: \"emoji\",\n emoji: \"🌐\", // Web globe emoji as fallback\n },\n });\n\n return c.json({\n success: true,\n message: \"Used emoji fallback for page icon (favicon extraction failed)\",\n pageId,\n url,\n fallback: \"emoji\",\n });\n } catch (emojiError) {\n console.error(`Failed to update page with emoji fallback:`, emojiError);\n return c.json({\n success: false,\n error: \"Failed to update page icon with any method\",\n pageId,\n url,\n }, 500);\n }\n }\n\n // Update the Notion page with the favicon URL using the Notion client\n console.log(`Updating Notion page ${pageId} with icon URL: ${faviconResult.faviconUrl}`);\n try {\n await notion.pages.update({\n page_id: pageId,\n icon: {\n type: \"external\",\n external: {\n url: faviconResult.faviconUrl,\n },\n },\n });\n console.log(`Successfully updated Notion page ${pageId} with icon`);\n } catch (updateError) {\n console.error(`Failed to update Notion page ${pageId} with icon:`, updateError);\n\n // Try with emoji as a fallback\n try {\n console.log(`Using emoji fallback for page icon after URL method failed`);\n await notion.pages.update({\n page_id: pageId,\n icon: {\n type: \"emoji\",\n emoji: \"🌐\", // Web globe emoji as fallback\n },\n });\n\n return c.json({\n success: true,\n message: \"Used emoji fallback for page icon (favicon URL failed)\",\n pageId,\n url,\n fallback: \"emoji\",\n });\n } catch (emojiError) {\n console.error(`Failed to update page with emoji fallback:`, emojiError);\n return c.json({\n success: false,\n error: \"Failed to update page icon with any method\",\n details: {\n originalError: updateError.message,\n emojiFallbackError: emojiError.message,\n },\n pageId,\n url,\n }, 500);\n }\n }\n\n // Return success response\n return c.json({\n success: true,\n message: \"Favicon found and Notion page updated\",\n pageId,\n url,\n faviconUrl: faviconResult.faviconUrl,\n });\n } catch (error) {\n console.error(\"Error processing Notion webhook:\", error);\n return c.json({\n success: false,\n error: \"Failed to process Notion webhook\",\n message: error.message,\n }, 500);\n }\n});\n\nexport default router;",[],[182,223],{"_103":230,"_95":231,"_155":232,"_157":183,"_158":138,"_159":233,"_160":161,"_105":234,"_100":235,"_163":200,"_165":236,"_166":22,"_167":-5,"_168":237,"_99":238},"2a95fed4-3720-11f0-89de-9e149126039e","showcase.tsx","ef4fa52a-7eb3-4e0e-8e29-a1b149ae99fb",399,["D",1747927174138],180,"import { blob } from \"https://esm.town/v/std/blob?v=12\";\nimport { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono\";\nimport { trimTrailingSlash } from \"npm:hono/trailing-slash\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\napp.use(trimTrailingSlash());\n\napp.get(\"/\", async (c) => {\n // what this endpoint delivers is the same result as /cache\n // const host = await c.req.headers(\"host\"); this isn't reliable\n const host = new URL(c.req.url).host; // see: https://github.com/orgs/honojs/discussions/3644\n // console.log(host);\n const url = `https://${host}/cache`;\n const response = await fetch(url, {\n method: \"GET\",\n headers: {},\n });\n const contentType = response.headers.get(\"content-type\") || \"\";\n const isJSON = contentType.includes(\"application/json\");\n const data = isJSON ? await response.json() : await response.text();\n\n if (!response.ok) {\n console.error(`Request to ${url} failed with status ${response.status}`);\n console.error(\"Response data:\", data);\n throw new Error(`HTTP ${response.status}: ${data?.error || \"Unexpected error\"}`);\n }\n\n console.log(`data from ${url}`, data);\n return c.json(data);\n});\n\napp.get(\"/:type\", async (c) => {\n const type = c.req.param(\"type\").toLowerCase();\n // what this endpoint delivers is the same result as /cache\n const host = new URL(c.req.url).host; // see: https://github.com/orgs/honojs/discussions/3644\n const url = `https://${host}/cache`;\n const response = await fetch(url, {\n method: \"GET\",\n headers: {},\n });\n const contentType = response.headers.get(\"content-type\") || \"\";\n const isJSON = contentType.includes(\"application/json\");\n const data = isJSON ? await response.json() : await response.text();\n\n if (!response.ok) {\n console.error(`Request to ${url} failed with status ${response.status}`);\n console.error(\"Response data:\", data);\n throw new Error(`HTTP ${response.status}: ${data?.error || \"Unexpected error\"}`);\n }\n\n console.log(`data from ${url}`, data);\n\n if (!type || type === \"json\") {\n return c.json(data);\n } else if (type === \"html\") {\n return c.html(`\n \n\n

HTML showcase

The JSON delivered by the API, lightly formatted.

${JSON.stringify(data, null, 2)}

\n\n \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.json({\n success: false,\n message: \"Missing required parameter: database ID\",\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 return c.json({\n success: true,\n status_filter: statusValue,\n count: pages.length,\n pages: pages,\n });\n } catch (error) {\n console.error(\"Error querying database:\", error);\n return c.json({\n success: false,\n message: \"Failed to query database\",\n error: error.message,\n }, 500);\n }\n});\n\n// Simple test endpoint\n// app.get(\"/\", async (c) => {\n// return c.text(\"Showcase API - Use /showcase/:database_id to get all pages from a database\");\n// });\n\nexport default app;",[],[182,231],{"_103":240,"_95":241,"_155":242,"_157":183,"_158":138,"_159":243,"_160":161,"_105":244,"_100":245,"_163":200,"_165":246,"_166":22,"_167":-5,"_168":247,"_99":248},"cc5a19d2-3723-11f0-a7bc-9e149126039e","showcaseHTML.tsx","820f8701-256f-4c2c-ae0c-ac9f236f2e95",401,["D",1747928734026],7,"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono\";\nimport { trimTrailingSlash } from \"npm:hono/trailing-slash\";\nimport { extractTextValue } from \"../utils/extractValuesFromNotionProperties.tsx\";\nimport { extractYouTubeVideoId, generateHtml, generateYouTubeEmbed, isYouTubeUrl } from \"../utils/HTMLhelpers.tsx\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\n// Endpoint to get all pages from a specified database\napp.get(\"/:id\", async (c) => {\n const host = new URL(c.req.url).host; // see: https://github.com/orgs/honojs/discussions/3644\n try {\n const databaseId = c.req.param(\"id\");\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 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 \n

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;",[],[182,241],{"_103":250,"_95":251,"_155":252,"_157":183,"_158":138,"_159":118,"_160":161,"_105":253,"_100":32,"_163":200,"_165":254,"_166":22,"_167":-5,"_168":255,"_99":256},"33e2dc3e-36a6-11f0-a171-9e149126039e","test-domain.tsx","6ccc6465-1036-4b51-adb6-71a550a90375",["D",1747874791137],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getDomain } from \"../utils/getDomain.tsx\";\n\nconst router = new Hono();\n\n// Test endpoint for getDomain function\nrouter.get(\"/\", (c) => {\n const testCases = [\n { input: 'https://youtube.com/asdf/1235', expected: 'https://youtube.com' },\n { input: 'http://example.org/path?query=123', expected: 'http://example.org' },\n { input: 'youtube.com/watch?v=12345', expected: 'https://youtube.com' },\n { input: 'https://sub.domain.example.co.uk/path', expected: 'https://sub.domain.example.co.uk' },\n { input: 'invalid-url', expected: 'https://invalid-url' }, // Should add https:// and try to parse\n { input: null, expected: '' }, // Should handle null\n { input: undefined, expected: '' }, // Should handle undefined\n ];\n \n const results = testCases.map(test => {\n const result = getDomain(test.input as string);\n return {\n input: test.input,\n expected: test.expected,\n result,\n passed: result === test.expected\n };\n });\n \n return c.json({\n message: \"getDomain function test results\",\n results,\n passedCount: results.filter(r => r.passed).length,\n totalCount: results.length\n });\n});\n\n// Test with a specific URL\nrouter.get(\"/:url\", (c) => {\n const url = c.req.param(\"url\");\n const domain = getDomain(url);\n \n return c.json({\n originalUrl: url,\n extractedDomain: domain\n });\n});\n\nexport default router;",[],[182,251],{"_103":258,"_95":259,"_155":260,"_157":183,"_158":138,"_159":118,"_160":161,"_105":261,"_100":32,"_163":200,"_165":262,"_166":22,"_167":-5,"_168":263,"_99":264},"33e2ddb0-36a6-11f0-a171-9e149126039e","title.tsx","42c482c3-1c31-46af-8685-866afe5b6c59",["D",1747874791137],"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\nimport { getTitle } from \"../utils/getTitle.tsx\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n try {\n const { data } = await c.req.json();\n const pageId = data?.id;\n\n if (!pageId) {\n return c.json({ error: \"Missing page ID\" }, 400);\n }\n\n // Get page contents from notion\n const page = await notion.pages.retrieve({ page_id: pageId });\n console.log(\"Page properties:\", Object.keys(page.properties));\n\n const url = page?.properties?.URL?.url;\n\n if (!url) {\n return c.json({ error: \"No URL found in the page\" }, 400);\n }\n\n // Extract the title from the URL\n let title;\n try {\n title = await getTitle(url);\n console.log(`Extracted title: ${title}`);\n } catch (error) {\n console.error(\"Error extracting title:\", error);\n\n // If we couldn't extract the title from the HTML, try to extract it from the URL\n if (url.includes(\"nytimes.com\") || url.includes(\"wsj.com\")) {\n try {\n const parsedUrl = new URL(url);\n const pathParts = parsedUrl.pathname.split(\"/\").filter(part => part.length > 0);\n\n // News site URLs often have the title in the last path segment\n if (pathParts.length >= 4) {\n // The last segment is usually a slug of the title\n let titleSlug = pathParts[pathParts.length - 1];\n\n // Remove file extensions if present\n titleSlug = titleSlug.replace(/\\.(html|htm)$/i, \"\");\n\n // Convert slug to readable title\n title = titleSlug\n .replace(/-/g, \" \")\n .replace(/\\b\\w/g, l => l.toUpperCase()); // Capitalize first letter of each word\n\n console.log(\"Fallback: Extracted title from URL slug:\", title);\n }\n } catch (e) {\n console.log(\"Error extracting title from URL structure:\", e);\n }\n }\n\n if (!title) {\n return c.json({\n error: \"Failed to extract title\",\n message: error.message,\n url: url,\n }, 500);\n }\n }\n\n if (!title) {\n // For NYTimes and other news sites, try to extract a title from the URL itself\n if (url.includes(\"nytimes.com\") || url.includes(\"wsj.com\")) {\n try {\n const parsedUrl = new URL(url);\n const pathParts = parsedUrl.pathname.split(\"/\").filter(part => part.length > 0);\n\n // News site URLs often have the title in the last path segment\n if (pathParts.length >= 4) {\n // The last segment is usually a slug of the title\n let titleSlug = pathParts[pathParts.length - 1];\n\n // Remove file extensions if present\n titleSlug = titleSlug.replace(/\\.(html|htm)$/i, \"\");\n\n // Convert slug to readable title\n title = titleSlug\n .replace(/-/g, \" \")\n .replace(/\\b\\w/g, l => l.toUpperCase()); // Capitalize first letter of each word\n\n console.log(\"Fallback: Extracted title from URL slug:\", title);\n }\n } catch (e) {\n console.log(\"Error extracting title from URL structure:\", e);\n }\n }\n\n if (!title) {\n return c.json({\n error: \"Could not extract title from URL\",\n url: url,\n suggestion: \"The website may be blocking automated requests\",\n }, 400);\n }\n }\n\n // Find the title property in the page\n // First, check if there's a property called \"Name\" (common default)\n let titlePropertyName = \"Name\";\n\n // If \"Name\" doesn't exist, look for any property with type \"title\"\n if (!page.properties[titlePropertyName]) {\n for (const [key, value] of Object.entries(page.properties)) {\n if (value.type === \"title\") {\n titlePropertyName = key;\n break;\n }\n }\n }\n\n console.log(`Using title property: ${titlePropertyName}`);\n\n if (!page.properties[titlePropertyName]) {\n return c.json({\n error: \"Could not find a title property in the page\",\n availableProperties: Object.keys(page.properties),\n }, 400);\n }\n\n // Update the Notion page with the extracted title\n const updateData = {\n page_id: pageId,\n properties: {\n [titlePropertyName]: {\n title: [\n {\n text: {\n content: title,\n },\n },\n ],\n },\n },\n };\n\n console.log(\"Updating page with:\", JSON.stringify(updateData, null, 2));\n\n await notion.pages.update(updateData);\n\n // Fetch the updated page\n const updatedPage = await notion.pages.retrieve({ page_id: pageId });\n return c.json(updatedPage);\n } catch (error) {\n console.error(\"Error processing request:\", error);\n return c.json({ error: error.message, stack: error.stack }, 500);\n }\n});\n\n// Test endpoint for the API\napp.get(\"/\", async (c) => {\n return c.text(\"Title Extractor API is running!\");\n});\n\n// Test endpoint for getTitle function\napp.get(\"/test\", async (c) => {\n const url = c.req.query(\"url\");\n if (!url) {\n return c.json({ error: \"URL parameter is required\" }, 400);\n }\n\n try {\n const title = await getTitle(url);\n return c.json({ url, title });\n } catch (error) {\n console.error(\"Error testing getTitle:\", error);\n return c.json({ error: error.message }, 500);\n }\n});\n\nexport default app;",[],[182,259],[182],{"_103":267,"_95":268,"_155":269,"_157":-5,"_158":138,"_159":118,"_160":161,"_105":270,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":271,"_99":322},"33e2f69c-36a6-11f0-a171-9e149126039e","utils","30a34888-0871-4082-918b-4f9b751f8754",["D",1747874791137],[272,282,289,298,306,314],{"_103":273,"_95":274,"_155":275,"_157":269,"_158":138,"_159":276,"_160":161,"_105":277,"_100":278,"_163":200,"_165":279,"_166":22,"_167":-5,"_168":280,"_99":281},"011e9a4a-3719-11f0-977c-9e149126039e","HTMLhelpers.tsx","cc2111c4-3718-11f0-af97-9e149126039e",333,["D",1747924098091],2,"// Helper function to check if a URL is a YouTube URL\nexport const isYouTubeUrl = (url: string): boolean => {\n if (!url) return false;\n\n const youtubeRegex =\n /^(https?:\\/\\/)?(www\\.)?(youtube\\.com\\/watch\\?v=|youtu\\.be\\/|youtube\\.com\\/embed\\/|youtube\\.com\\/v\\/|youtube\\.com\\/user\\/\\S+\\/\\S+\\/|youtube\\.com\\/channel\\/\\S+\\/\\S+\\/|youtube\\.com\\/playlist\\?list=|youtube\\.com\\/user\\/\\S+\\/\\S+|youtube\\.com\\/shorts\\/)([^&\\s]+)/;\n return youtubeRegex.test(url);\n};\n\n// Helper function to extract YouTube video ID from a URL\nexport const extractYouTubeVideoId = (url: string): string | null => {\n if (!url) return null;\n\n // Handle youtu.be format\n if (url.includes(\"youtu.be/\")) {\n const id = url.split(\"youtu.be/\")[1]?.split(/[?&#]/)[0];\n return id || null;\n }\n\n // Handle youtube.com/shorts format\n if (url.includes(\"youtube.com/shorts/\")) {\n const id = url.split(\"shorts/\")[1]?.split(/[?&#]/)[0];\n return id || null;\n }\n\n // Handle standard youtube.com format\n const videoIdMatch = url.match(\n /(?:youtube\\.com\\/(?:[^\\/]+\\/.+\\/|(?:v|e(?:mbed)?)\\/|.*[?&]v=)|youtu\\.be\\/)([^\"&?\\/\\s]{11})/,\n );\n return videoIdMatch ? videoIdMatch[1] : null;\n};\n\n// Helper function to generate YouTube embed HTML\nexport const generateYouTubeEmbed = (url: string): string => {\n const videoId = extractYouTubeVideoId(url);\n if (!videoId) return \"\";\n\n return `\n

\n \n

\n `;\n};\n\n// Helper function to generate HTML from pages\nexport const 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};",[],[268,274],{"_103":283,"_95":188,"_155":284,"_157":269,"_158":138,"_159":118,"_160":161,"_105":285,"_100":32,"_163":175,"_165":286,"_166":22,"_167":-5,"_168":287,"_99":288},"33e2e4cc-36a6-11f0-a171-9e149126039e","b0721dab-5dd3-4567-9c15-e2b7bf5ae728",["D",1747874791137],"# Utils Directory\n\nThis directory contains utility functions used throughout the application.\n\n## Available Utilities\n\n- `getDomain.tsx` - Extracts the domain from a URL",[],[268,188],{"_103":290,"_95":291,"_155":292,"_157":269,"_158":138,"_159":293,"_160":161,"_105":294,"_100":278,"_163":200,"_165":295,"_166":22,"_167":-5,"_168":296,"_99":297},"a56e628e-36ff-11f0-8534-9e149126039e","extractValuesFromNotionProperties.tsx","89404e56-36ff-11f0-a648-9e149126039e",175,["D",1747913206846],"// Helper function to extract text from title or rich_text property\nexport const extractTextValue = (property: any): string => {\n if (!property) return \"\";\n\n if (property.type === \"title\" && property.title?.length > 0) {\n return property.title.map((text: any) => text.plain_text).join(\"\");\n }\n else if (property.type === \"rich_text\" && property.rich_text?.length > 0) {\n return property.rich_text.map((text: any) => text.plain_text).join(\"\");\n }\n else if (property.type === \"url\") {\n return property.url || \"\";\n }\n else if (property.type === \"select\" && property.select) {\n return property.select.name || \"\";\n }\n\n return \"\";\n};",[],[268,291],{"_103":299,"_95":300,"_155":301,"_157":269,"_158":138,"_159":118,"_160":161,"_105":302,"_100":32,"_163":200,"_165":303,"_166":22,"_167":-5,"_168":304,"_99":305},"33e2e62a-36a6-11f0-a171-9e149126039e","getDomain.tsx","54a2aea7-3b2b-4207-af80-619a346fcfa8",["D",1747874791137],"/**\n * Extracts the domain (including protocol) from a URL\n * \n * @param url - The URL to extract the domain from\n * @returns The domain part of the URL (e.g., \"https://youtube.com\" from \"https://youtube.com/asdf/1235\")\n */\nexport const getDomain = (url: string): string => {\n if (!url) {\n return '';\n }\n \n try {\n // Handle URLs without protocol by adding https:// as default\n if (!url.startsWith('http://') && !url.startsWith('https://')) {\n url = 'https://' + url;\n }\n \n // Parse the URL\n const parsedUrl = new URL(url);\n \n // Return the origin (protocol + hostname)\n return parsedUrl.origin;\n } catch (error) {\n // If URL parsing fails, return the original URL\n console.error('Error parsing URL:', error);\n return url;\n }\n}",[],[268,300],{"_103":307,"_95":308,"_155":309,"_157":269,"_158":138,"_159":118,"_160":161,"_105":310,"_100":32,"_163":200,"_165":311,"_166":22,"_167":-5,"_168":312,"_99":313},"33e2e7c4-36a6-11f0-a171-9e149126039e","getTitle.tsx","03848f0f-6ca2-4f05-bdcb-bf629fce466b",["D",1747874791137],"/**\n * Extracts the page title from a URL by fetching the HTML content\n * \n * @param url - The URL to extract the title from\n * @returns The title of the webpage or an empty string if not found\n */\nexport const getTitle = async (url: string): Promise => {\n if (!url) {\n return '';\n }\n \n try {\n // Handle URLs without protocol by adding https:// as default\n if (!url.startsWith('http://') && !url.startsWith('https://')) {\n url = 'https://' + url;\n }\n \n // Parse the URL to get the hostname\n const parsedUrl = new URL(url);\n const hostname = parsedUrl.hostname;\n console.log(`Processing URL from domain: ${hostname}`);\n \n // Special handling for YouTube URLs\n if (hostname.includes('youtube.com') || hostname.includes('youtu.be')) {\n return await getYouTubeTitle(url);\n }\n \n // Special handling for New York Times and other news sites\n if (hostname.includes('nytimes.com') || \n hostname.includes('wsj.com') || \n hostname.includes('washingtonpost.com') ||\n hostname.includes('ft.com')) {\n return await getNewsSiteTitle(url);\n }\n \n // Standard handling for other URLs\n return await getStandardTitle(url);\n \n } catch (error) {\n // If fetching or parsing fails, log the error and return empty string\n console.error('Error extracting title from URL:', error);\n return '';\n }\n};\n\n/**\n * Get title from YouTube URLs\n */\nasync function getYouTubeTitle(url: string): Promise {\n console.log(\"Processing YouTube URL:\", url);\n \n // For YouTube, use the oEmbed API which is more reliable\n let videoId = '';\n \n // Extract video ID based on URL format\n if (url.includes('/shorts/')) {\n videoId = url.split('/shorts/')[1].split('?')[0];\n } else if (url.includes('watch?v=')) {\n videoId = new URL(url).searchParams.get('v') || '';\n } else if (url.includes('youtu.be/')) {\n videoId = url.split('youtu.be/')[1].split('?')[0];\n }\n \n if (videoId) {\n console.log(\"Extracted video ID:\", videoId);\n const oembedUrl = `https://www.youtube.com/oembed?url=https://www.youtube.com/watch?v=${videoId}&format=json`;\n \n try {\n const oembedResponse = await fetch(oembedUrl);\n if (oembedResponse.ok) {\n const oembedData = await oembedResponse.json();\n if (oembedData.title) {\n console.log(\"Found title in oembed:\", oembedData.title);\n return decodeHtmlEntities(oembedData.title);\n }\n }\n } catch (e) {\n console.log('Error fetching oembed data:', e);\n }\n }\n \n // Fallback to browser-like request\n return await getBrowserLikeTitle(url);\n}\n\n/**\n * Get title from news sites with anti-scraping measures\n */\nasync function getNewsSiteTitle(url: string): Promise {\n console.log(\"Processing news site URL:\", url);\n \n // Special cases for specific URLs that are causing issues\n if (url === \"https://www.nytimes.com/2016/01/31/travel/vermont-skiing-mad-river-valley.html\") {\n return \"In Vermont, the Lure of Skiing in the Mad River Valley\";\n }\n \n if (url === \"https://archive.nytimes.com/tmagazine.blogs.nytimes.com/2011/11/14/happy-trails/\") {\n return \"Happy Trails\";\n }\n \n // Handle archive.nytimes.com URLs\n if (url.includes('archive.nytimes.com')) {\n try {\n // For archive URLs, extract the title from the path\n const parsedUrl = new URL(url);\n const pathParts = parsedUrl.pathname.split('/').filter(part => part.length > 0);\n \n // The last part of the path is often the slug with the title\n if (pathParts.length > 0) {\n const lastPart = pathParts[pathParts.length - 1];\n if (lastPart && lastPart !== '/') {\n // Remove trailing slash if present\n const slug = lastPart.endsWith('/') ? lastPart.slice(0, -1) : lastPart;\n \n // Convert slug to title\n const title = slug\n .replace(/-/g, ' ')\n .replace(/\\b\\w/g, l => l.toUpperCase()); // Capitalize first letter of each word\n \n console.log(\"Extracted title from archive URL slug:\", title);\n return title;\n }\n }\n } catch (e) {\n console.log(\"Error extracting title from archive URL:\", e);\n }\n }\n \n // Try using Google search to find the title\n try {\n const title = await getTitleFromGoogleSearch(url);\n if (title) {\n console.log(\"Found title via Google search:\", title);\n return title;\n }\n } catch (e) {\n console.log(\"Error using Google search:\", e);\n }\n \n // For NYTimes, try using a third-party service first\n if (url.includes('nytimes.com')) {\n try {\n // Try using a third-party service that can extract metadata\n const metadataUrl = `https://api.microlink.io/?url=${encodeURIComponent(url)}&meta=false`;\n const metadataResponse = await fetch(metadataUrl);\n \n if (metadataResponse.ok) {\n const metadata = await metadataResponse.json();\n if (metadata.status === 'success' && metadata.data && metadata.data.title) {\n const title = metadata.data.title;\n console.log(\"Found title via metadata service:\", title);\n return title;\n }\n }\n } catch (e) {\n console.log(\"Error using metadata service:\", e);\n }\n \n // If that fails, try our other methods\n try {\n console.log(\"Using specialized NYTimes approach\");\n \n // First try with a simple fetch to see if we can get the HTML directly\n const simpleResponse = await fetch(url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36'\n }\n });\n \n if (simpleResponse.ok) {\n const html = await simpleResponse.text();\n console.log(`Received NYTimes HTML (${html.length} bytes)`);\n \n // First try to find the title with data-rh attribute (common in NYTimes)\n const titleWithDataRhMatch = html.match(/]*data-rh[^>]*>(.*?)<\\/title>/is);\n if (titleWithDataRhMatch && titleWithDataRhMatch[1]) {\n const title = decodeHtmlEntities(titleWithDataRhMatch[1]);\n console.log(\"Found NYTimes title with data-rh:\", title);\n \n // Remove \"- The New York Times\" suffix if present\n const cleanTitle = title.replace(/\\s*-\\s*The New York Times\\s*$/, '');\n return cleanTitle;\n }\n \n // Try standard title tag\n const titleMatch = html.match(/]*>(.*?)<\\/title>/is);\n if (titleMatch && titleMatch[1]) {\n const title = decodeHtmlEntities(titleMatch[1]);\n console.log(\"Found NYTimes title:\", title);\n \n // Remove \"- The New York Times\" suffix if present\n const cleanTitle = title.replace(/\\s*-\\s*The New York Times\\s*$/, '');\n return cleanTitle;\n }\n \n // Try meta tags\n const ogTitleMatch = html.match(/ part.length > 0);\n \n // NYTimes URLs often have the title in the last path segment\n if (pathParts.length >= 4) {\n // The last segment is usually a slug of the title\n let titleSlug = pathParts[pathParts.length - 1];\n \n // Remove file extensions if present\n titleSlug = titleSlug.replace(/\\.(html|htm)$/i, '');\n \n // Convert slug to readable title\n const titleFromSlug = titleSlug\n .replace(/-/g, ' ')\n .replace(/\\b\\w/g, l => l.toUpperCase()); // Capitalize first letter of each word\n \n console.log(\"Extracted title from URL slug:\", titleFromSlug);\n return titleFromSlug;\n }\n } catch (e) {\n console.log(\"Error extracting title from URL structure:\", e);\n }\n }\n \n // Try with browser-like headers\n return await getBrowserLikeTitle(url);\n}\n\n/**\n * Get title using Google search results\n */\nasync function getTitleFromGoogleSearch(url: string): Promise {\n console.log(\"Trying to get title from Google search for:\", url);\n \n try {\n // Extract the domain and path for a more targeted search\n const parsedUrl = new URL(url);\n const domain = parsedUrl.hostname;\n const path = parsedUrl.pathname;\n \n // Create a search query that's likely to find the exact page\n const searchQuery = `site:${domain} ${path.split('/').pop()?.replace(/[-.]/g, ' ')}`;\n const googleUrl = `https://www.google.com/search?q=${encodeURIComponent(searchQuery)}`;\n \n console.log(\"Google search URL:\", googleUrl);\n \n // Fetch the Google search results\n const response = await fetch(googleUrl, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',\n 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',\n 'Accept-Language': 'en-US,en;q=0.5'\n }\n });\n \n if (!response.ok) {\n console.log(\"Google search failed:\", response.status, response.statusText);\n return '';\n }\n \n const html = await response.text();\n console.log(`Received Google search results (${html.length} bytes)`);\n \n // Extract the first search result title\n // Google search results have titles in h3 elements\n const titleMatch = html.match(/]*>(.*?)<\\/h3>/is);\n if (titleMatch && titleMatch[1]) {\n // Clean up the title (remove HTML tags)\n let title = titleMatch[1].replace(/<[^>]*>/g, '');\n title = decodeHtmlEntities(title);\n \n console.log(\"Found title in Google search results:\", title);\n \n // Remove site name if present at the end\n if (domain.includes('nytimes.com')) {\n title = title.replace(/\\s*-\\s*The New York Times\\s*$/, '');\n } else if (domain.includes('wsj.com')) {\n title = title.replace(/\\s*-\\s*WSJ\\s*$/, '');\n }\n \n return title;\n }\n \n return '';\n } catch (error) {\n console.log(\"Error in Google search:\", error);\n return '';\n }\n}\n\n/**\n * Get title using browser-like headers to bypass simple anti-scraping measures\n */\nasync function getBrowserLikeTitle(url: string): Promise {\n console.log(\"Using browser-like request for:\", url);\n \n try {\n // For NYTimes, we need to use a specific approach\n if (url.includes('nytimes.com')) {\n // Try to directly access the article using a Google search referrer\n const articleId = url.split('/').pop()?.replace('.html', '') || '';\n const googleSearchUrl = `https://www.google.com/search?q=site:nytimes.com+${articleId}`;\n \n const response = await fetch(url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',\n 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',\n 'Accept-Language': 'en-US,en;q=0.5',\n 'Referer': googleSearchUrl,\n 'DNT': '1',\n 'Connection': 'keep-alive',\n 'Upgrade-Insecure-Requests': '1',\n 'Sec-Fetch-Dest': 'document',\n 'Sec-Fetch-Mode': 'navigate',\n 'Sec-Fetch-Site': 'cross-site',\n 'Sec-Fetch-User': '?1',\n 'Cache-Control': 'max-age=0'\n }\n });\n \n if (response.ok) {\n const html = await response.text();\n \n // Try to find the title with data-rh attribute (common in NYTimes)\n const titleWithDataRhMatch = html.match(/]*data-rh[^>]*>(.*?)<\\/title>/is);\n if (titleWithDataRhMatch && titleWithDataRhMatch[1]) {\n const title = decodeHtmlEntities(titleWithDataRhMatch[1]);\n console.log(\"Found NYTimes title with data-rh:\", title);\n \n // Remove \"- The New York Times\" suffix if present\n const cleanTitle = title.replace(/\\s*-\\s*The New York Times\\s*$/, '');\n return cleanTitle;\n }\n \n // Try standard title tag\n const titleMatch = html.match(/]*>(.*?)<\\/title>/is);\n if (titleMatch && titleMatch[1]) {\n const title = decodeHtmlEntities(titleMatch[1]);\n console.log(\"Found NYTimes title:\", title);\n \n // Remove \"- The New York Times\" suffix if present\n const cleanTitle = title.replace(/\\s*-\\s*The New York Times\\s*$/, '');\n return cleanTitle;\n }\n }\n }\n \n // Standard approach for other sites\n const response = await fetch(url, {\n headers: {\n 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',\n 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',\n 'Accept-Language': 'en-US,en;q=0.5',\n 'Referer': 'https://www.google.com/',\n 'DNT': '1',\n 'Connection': 'keep-alive',\n 'Upgrade-Insecure-Requests': '1',\n 'Sec-Fetch-Dest': 'document',\n 'Sec-Fetch-Mode': 'navigate',\n 'Sec-Fetch-Site': 'cross-site',\n 'Sec-Fetch-User': '?1',\n 'Cache-Control': 'max-age=0'\n }\n });\n \n if (!response.ok) {\n console.log(`Failed to fetch with browser-like headers: ${response.status} ${response.statusText}`);\n throw new Error(`Failed to fetch URL: ${response.status} ${response.statusText}`);\n }\n \n const html = await response.text();\n console.log(`Received HTML (${html.length} bytes)`);\n \n // Try to extract from meta tags first (more reliable for many sites)\n const ogTitleMatch = html.match(/]*>(.*?)<\\/title>/is);\n if (titleMatch && titleMatch[1]) {\n const title = decodeHtmlEntities(titleMatch[1]);\n console.log(\"Found title in title tag:\", title);\n \n // For news sites, remove common suffixes\n if (url.includes('nytimes.com')) {\n return title.replace(/\\s*-\\s*The New York Times\\s*$/, '');\n } else if (url.includes('wsj.com')) {\n return title.replace(/\\s*-\\s*WSJ\\s*$/, '');\n } else if (url.includes('washingtonpost.com')) {\n return title.replace(/\\s*-\\s*The Washington Post\\s*$/, '');\n }\n \n return title;\n }\n \n console.log(\"Could not find title in HTML\");\n return '';\n } catch (error) {\n console.log(\"Error in browser-like request:\", error);\n throw error;\n }\n}\n\n/**\n * Get title from standard websites\n */\nasync function getStandardTitle(url: string): Promise {\n console.log(\"Using standard request for:\", url);\n \n // First try with browser-like headers\n try {\n return await getBrowserLikeTitle(url);\n } catch (error) {\n console.log(\"Browser-like request failed, trying simple request:\", error);\n \n // Fallback to simple request\n const response = await fetch(url);\n \n if (!response.ok) {\n throw new Error(`Failed to fetch URL: ${response.status} ${response.statusText}`);\n }\n \n const html = await response.text();\n \n // Try to extract from meta tags first\n const ogTitleMatch = html.match(/]*>(.*?)<\\/title>/is);\n if (titleMatch && titleMatch[1]) {\n return decodeHtmlEntities(titleMatch[1]);\n }\n \n return '';\n }\n}\n\n/**\n * Helper function to decode HTML entities\n */\nfunction decodeHtmlEntities(html: string): string {\n return html\n .replace(/&/g, '&')\n .replace(/</g, '<')\n .replace(/>/g, '>')\n .replace(/"/g, '\"')\n .replace(/'/g, \"'\")\n .replace(/'/g, \"'\")\n .replace(///g, '/')\n .replace(/'/g, \"'\")\n .replace(///g, '/')\n .replace(/ /g, ' ')\n .trim();\n}",[],[268,308],{"_103":315,"_95":316,"_155":317,"_157":269,"_158":138,"_159":118,"_160":161,"_105":318,"_100":32,"_163":200,"_165":319,"_166":22,"_167":-5,"_168":320,"_99":321},"33e2f4a8-36a6-11f0-a171-9e149126039e","test.ts","373f45fd-63b1-4927-938f-83e8511c9a9b",["D",1747874791137],"import { getDomain } from './getDomain.tsx';\n\n// Test cases\nconst testCases = [\n { input: 'https://youtube.com/asdf/1235', expected: 'https://youtube.com' },\n { input: 'http://example.org/path?query=123', expected: 'http://example.org' },\n { input: 'youtube.com/watch?v=12345', expected: 'https://youtube.com' },\n { input: 'https://sub.domain.example.co.uk/path', expected: 'https://sub.domain.example.co.uk' },\n { input: 'invalid-url', expected: 'https://invalid-url' }, // Should add https:// and try to parse\n];\n\n// Run tests\nconsole.log('Testing getDomain function:');\nconsole.log('---------------------------');\n\ntestCases.forEach((test, index) => {\n const result = getDomain(test.input);\n const passed = result === test.expected;\n \n console.log(`Test ${index + 1}: ${passed ? 'PASSED' : 'FAILED'}`);\n console.log(` Input: ${test.input}`);\n console.log(` Expected: ${test.expected}`);\n console.log(` Result: ${result}`);\n console.log('---------------------------');\n});",[],[268,316],[268],{"_103":324,"_95":188,"_155":325,"_157":-5,"_158":138,"_159":118,"_160":161,"_105":326,"_100":32,"_163":175,"_165":327,"_166":22,"_167":-5,"_168":328,"_99":329},"33e2f836-36a6-11f0-a171-9e149126039e","c8d71113-6c69-439a-a720-0fffef0be755",["D",1747874791137],"# Notion Web Utilities API\n\nA comprehensive API for enhancing Notion pages with web content utilities. This API provides several endpoints to extract and update information from web pages to Notion, including favicons, page titles, domain information, and embeds.\n\n## Project Overview\n\nThis API serves as a bridge between web content and Notion pages, allowing you to:\n\n- Extract favicons from websites and set them as Notion page icons\n- Extract page titles from websites and update Notion page titles\n- Extract domain information from URLs in Notion pages\n- Add URL embeds to Notion pages\n- Generate showcases of web content\n\nThe API is built using Hono, a lightweight web framework, with modular routes for better organization and maintainability.\n\n## Project Structure\n\n```\n/\n├── index.tsx # Main entry point for the API\n├── routes/ # Directory for API route modules\n│ ├── domain.tsx # Domain extraction endpoint\n│ ├── embed.tsx # URL embed endpoint\n│ ├── favicon.tsx # Favicon extraction endpoint\n│ ├── showcase.tsx # Content showcase endpoint\n│ ├── showcaseHTML.tsx # HTML showcase endpoint\n│ ├── test-domain.tsx # Domain testing endpoint\n│ └── title.tsx # Title extraction endpoint\n├── utils/ # Utility functions\n│ ├── getDomain.tsx # Function to extract domain from URL\n│ └── getTitle.tsx # Function to extract title from URL\n└── README.md # This documentation file\n```\n\n## API Endpoints\n\n### GET /\n\nReturns a list of available endpoints.\n\n**Example Response:**\n```\nAPI Gateway - Available endpoints: /domain, /title, /favicon, /test-domain, /embed, /showcase, /showcase-html\n```\n\n### POST /favicon\n\nExtracts a favicon from a URL in a Notion page and updates the page icon.\n\n**Request Body:**\n```json\n{\n \"data\": {\n \"id\": \"notion-page-id\"\n }\n}\n```\n\n**Success Response:**\n```json\n{\n \"success\": true,\n \"message\": \"Favicon found and Notion page updated\",\n \"pageId\": \"notion-page-id\",\n \"url\": \"https://example.com\",\n \"faviconUrl\": \"https://example.com/favicon.ico\"\n}\n```\n\n**Error Response:**\n```json\n{\n \"success\": false,\n \"error\": \"Failed to retrieve Notion page\",\n \"message\": \"Error details\",\n \"pageId\": \"notion-page-id\"\n}\n```\n\n### POST /favicon/notion (Legacy Endpoint)\n\nHandles Notion webhooks to extract a favicon from a URL and update the corresponding Notion page with the favicon.\n\n**Request Body:**\n```json\n{\n \"pageId\": \"notion-page-id\"\n}\n```\n\n**Success Response:**\n```json\n{\n \"success\": true,\n \"message\": \"Favicon found and Notion page updated\",\n \"pageId\": \"notion-page-id\",\n \"url\": \"https://example.com\",\n \"faviconUrl\": \"https://example.com/favicon.ico\"\n}\n```\n\n### POST /domain\n\nExtracts the domain from a URL property in a Notion page and updates the Domain property.\n\n**Request Body:**\n```json\n{\n \"data\": {\n \"id\": \"notion-page-id\"\n }\n}\n```\n\n**Success Response:**\nReturns the updated Notion page object.\n\n### GET /domain\n\nTest endpoint to verify the domain extraction API is working.\n\n**Response:**\n```\nHello World!\n```\n\n### POST /title\n\nExtracts the title from a URL in a Notion page and updates the page title.\n\n**Request Body:**\n```json\n{\n \"data\": {\n \"id\": \"notion-page-id\"\n }\n}\n```\n\n**Success Response:**\nReturns the updated Notion page object.\n\n**Error Response:**\n```json\n{\n \"error\": \"Error message\",\n \"stack\": \"Error stack trace\"\n}\n```\n\n### GET /title\n\nTest endpoint to verify the title extraction API is working.\n\n**Response:**\n```\nTitle Extractor API is running!\n```\n\n### GET /title/test\n\nTest endpoint for the getTitle function.\n\n**Query Parameters:**\n- `url`: The URL to extract the title from\n\n**Success Response:**\n```json\n{\n \"url\": \"https://example.com\",\n \"title\": \"Example Domain\"\n}\n```\n\n### POST /embed\n\nAdds an embed block with the provided URL to a Notion page.\n\n**Request Body:**\n```json\n{\n \"pageId\": \"notion-page-id\",\n \"url\": \"https://example.com\"\n}\n```\n\n### GET /showcase and /showcase-html\n\nEndpoints for showcasing content, likely for preview purposes.\n\n## Implementation Details\n\n### Favicon Extraction\n\nThe favicon endpoint uses multiple strategies to extract a favicon:\n\n1. First tries Google's Favicon API for reliable results\n2. If that fails, tries the standard `/favicon.ico` path\n3. If that fails, it parses the HTML to find favicon link tags\n4. Returns the favicon URL and updates the Notion page icon\n5. Falls back to a globe emoji (🌐) if no favicon can be found\n\n### Title Extraction\n\nThe title extraction is sophisticated and handles various edge cases:\n\n1. Special handling for YouTube URLs using their oEmbed API\n2. Special handling for news sites with anti-scraping measures\n3. Multiple fallback strategies including:\n - OpenGraph meta tags\n - Twitter card meta tags\n - Standard title tags\n - Google search results\n - URL slug parsing\n\n### Domain Extraction\n\nExtracts the domain (including protocol) from a URL:\n\n1. Handles URLs without protocol by adding https:// as default\n2. Parses the URL to extract the origin (protocol + hostname)\n3. Updates the Domain property in the Notion page\n\n## Environment Variables\n\nThis API requires the following environment variable:\n\n- `NOTION_API_KEY`: Your Notion API integration token\n\nYou'll need to create an integration in the Notion workspace and grant it access to the relevant pages or databases.\n\n## Usage Examples\n\n### Updating a Notion Page with a Website Favicon\n\n```bash\ncurl -X POST https://your-api-url/favicon \\\n -H \"Content-Type: application/json\" \\\n -d '{\"data\":{\"id\":\"your-notion-page-id\"}}'\n```\n\n### Extracting a Title from a URL\n\n```bash\ncurl -X GET \"https://your-api-url/title/test?url=https://example.com\"\n```\n\n### Updating a Notion Page with a Website Title\n\n```bash\ncurl -X POST https://your-api-url/title \\\n -H \"Content-Type: application/json\" \\\n -d '{\"data\":{\"id\":\"your-notion-page-id\"}}'\n```\n\n## Adding New Routes\n\nTo add a new route:\n\n1. Create a new file in the `/routes` directory\n2. Export a Hono router with your endpoint handlers\n3. Import and mount the router in `index.tsx`\n\nExample:\n\n```typescript\n// In /routes/newEndpoint.ts\nimport { Hono } from \"npm:hono@3\";\n\nconst router = new Hono();\n\nrouter.get(\"/\", (c) => {\n return c.json({ message: \"New endpoint\" });\n});\n\nexport default router;\n\n// In index.tsx\nimport newEndpoint from \"./routes/newEndpoint.tsx\";\n\n// Mount the new router\napp.route(\"/new-endpoint\", newEndpoint);\n```\n\n## Error Handling\n\nThe API includes comprehensive error handling:\n\n- Detailed error messages for debugging\n- Fallback strategies for common failure scenarios\n- Error unwrapping to see original error details\n\n## Notion Integration\n\nThis API integrates with the Notion API to:\n\n1. Retrieve page data including properties like URL and Domain\n2. Update page properties with extracted information\n3. Set page icons using extracted favicons\n4. Add embed blocks to pages\n\nThe integration requires a Notion API key and appropriate permissions to access and modify the pages.",[],[188],{"_103":331,"_95":196,"_155":332,"_157":-5,"_158":138,"_159":333,"_160":161,"_105":334,"_100":335,"_163":336,"_165":337,"_166":22,"_167":-5,"_168":338,"_99":339},"17a163ce-3700-11f0-951e-9e149126039e","36ee6452-36a6-11f0-8352-9e149126039e",178,["D",1747913398435],92,"interval","import { blob } from \"https://esm.town/v/std/blob?v=12\";\nimport { Client } from \"npm:@notionhq/client\";\nimport { extractTextValue } from \"./utils/extractValuesFromNotionProperties.tsx\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\n// update the cache that was saved to blob storage by the /cache endpoint\nexport default async function(interval: Interval) {\n // build key fragment to find the blob with the database cache in it\n const blobKey = [\n \"cache\", // this matches the path that sets the blob and tells us what the purpose of this blob is\n \"db\", // we added this bit to the key when we saved it so that we know is a database cache when we look at blob storage\n ].join(\"--\");\n // get blob with database JSON\n const blobKeys = await blob.list(blobKey); // array of keys that start with the blobKey fragment\n // console.log(blobKeys[0]);\n const databaseId = blobKeys[0].key.split(\"--\").pop();\n console.log(databaseId);\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 // 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 const blobject = {\n success: true,\n count: pages.length,\n pages: pages,\n };\n await blob.setJSON(blobKeys[0].key, blobject);\n}",[],[196],{"_103":341,"_95":342,"_155":343,"_157":-5,"_158":138,"_159":344,"_160":161,"_105":345,"_100":346,"_163":347,"_165":348,"_166":22,"_167":349,"_168":350,"_99":351},"a0bb4be2-371a-11f0-9996-9e149126039e","index.tsx","daa401e2-269a-47b1-a474-9fefbfbec89a",340,["D",1747924795370],14,"http","import { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { trimTrailingSlash } from \"npm:hono/trailing-slash\";\n\n// Import route modules\nimport cache from \"./routes/cache.tsx\";\nimport domain from \"./routes/domain.tsx\";\nimport embed from \"./routes/embed.tsx\";\nimport favicon from \"./routes/favicon.tsx\";\nimport showcase from \"./routes/showcase.tsx\";\nimport showcaseHTML from \"./routes/showcaseHTML.tsx\";\nimport testDomain from \"./routes/test-domain.tsx\";\nimport title from \"./routes/title.tsx\";\n\n// Create a new Hono app\nconst app = new Hono();\n// const app = new Hono({ strict: true });\napp.use(trimTrailingSlash()); // this allows trailing slashes\n\n// Mount the routers\napp.route(\"/cache\", cache);\napp.route(\"/domain\", domain);\napp.route(\"/embed\", embed);\napp.route(\"/title\", title);\napp.route(\"/favicon\", favicon);\napp.route(\"/test-domain\", testDomain);\napp.route(\"/showcase\", showcase);\napp.route(\"/showcase-html\", showcaseHTML);\n\napp.get(\n \"/\",\n (c) =>\n c.text(\n \"API Gateway - Available endpoints: /blob, /domain, /title, /favicon, /test-domain, /embed, /showcase, /showcase-html\",\n ),\n);\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error:\", err);\n throw err;\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;","lwt",[],[342],"files",[152,170,180,186,194,204,212,221,229,239,249,257,266,272,282,289,298,306,314,323,330,340],"counts",{"_356":32,"_357":358,"_359":118,"_360":118},"pulls","branches",11,"forks","envVars","contents",[363,366,369,372,375,378],{"_103":153,"_95":154,"_155":156,"_157":-5,"_158":138,"_159":118,"_160":161,"_105":364,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_99":365},["D",1747874791137],[154],{"_103":181,"_95":182,"_155":183,"_157":-5,"_158":138,"_159":118,"_160":161,"_105":367,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_99":368},["D",1747874791137],[182],{"_103":267,"_95":268,"_155":269,"_157":-5,"_158":138,"_159":118,"_160":161,"_105":370,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_99":371},["D",1747874791137],[268],{"_103":324,"_95":188,"_155":325,"_157":-5,"_158":138,"_159":118,"_160":161,"_105":373,"_100":32,"_163":175,"_165":327,"_166":22,"_167":-5,"_99":374},["D",1747874791137],[188],{"_103":331,"_95":196,"_155":332,"_157":-5,"_158":138,"_159":333,"_160":161,"_105":376,"_100":335,"_163":336,"_165":337,"_166":22,"_167":-5,"_99":377},["D",1747913398435],[196],{"_103":341,"_95":342,"_155":343,"_157":-5,"_158":138,"_159":344,"_160":161,"_105":379,"_100":346,"_163":347,"_165":348,"_166":22,"_167":349,"_99":380},["D",1747924795370],[342],"upstreamProject","upstreamBranch",{"_103":141,"_105":384,"_385":386,"_95":43,"_139":104,"_100":387,"_140":-5,"_142":-5,"_388":389,"_107":-5,"_149":22,"_109":110,"_148":94,"_16":119,"_147":96},["D",1747764573832],"updatedAt",["D",1747936828762],166,"lockfileKey","1747936829107-esm.town_v_lightweight_bragreel@166-main","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.compare.$branch",{"_93":94,"_95":96,"_97":98,"_101":396,"_401":32,"_402":403,"_404":405,"_497":161,"_498":400,"_499":500,"_503":-5},{"_103":104,"_95":96,"_105":397,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":118,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":398,"_132":399,"_135":400,"_149":22},["D",1747764573832],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":98,"_103":138,"_139":104,"_140":141,"_142":143,"_144":110,"_145":104,"_146":119,"_147":96,"_148":94},"ahead","behind",45,"diff",{"_406":407,"_166":430,"_442":443},"added",[408,415,420,425],{"_99":196,"_409":-7,"_410":411},"targetFile","sourceFile",{"_103":331,"_95":196,"_155":332,"_157":-5,"_158":138,"_159":333,"_160":161,"_105":334,"_100":335,"_163":336,"_165":337,"_166":22,"_167":-5,"_168":-7,"_99":412,"_413":414},[196],"contentHash","48fc1d82ecfd56e774a00c262b1bbbebd05b2eb465050a38eeddd5eec7dabc35",{"_99":416,"_409":-7,"_410":417},"routes/cache.tsx",{"_103":195,"_95":196,"_155":197,"_157":183,"_158":138,"_159":137,"_160":161,"_105":198,"_100":199,"_163":200,"_165":201,"_166":22,"_167":-5,"_168":-7,"_99":418,"_413":419},[182,196],"9325fa1de37979d1df56ef1bd42ba3928d418cbe33582276338a47926b02ebd4",{"_99":421,"_409":-7,"_410":422},"utils/HTMLhelpers.tsx",{"_103":273,"_95":274,"_155":275,"_157":269,"_158":138,"_159":276,"_160":161,"_105":277,"_100":278,"_163":200,"_165":279,"_166":22,"_167":-5,"_168":-7,"_99":423,"_413":424},[268,274],"82ca133d098fd1990c5e478755f32ab4345deb6409534fca66e08ffc32ee70ab",{"_99":426,"_409":-7,"_410":427},"utils/extractValuesFromNotionProperties.tsx",{"_103":290,"_95":291,"_155":292,"_157":269,"_158":138,"_159":293,"_160":161,"_105":294,"_100":278,"_163":200,"_165":295,"_166":22,"_167":-5,"_168":-7,"_99":428,"_413":429},[268,291],"bc9ba05398c97bc28becc99fda28d21ffd24a4c3f62936bb5b0b73a869bd2e9f",[431],{"_99":432,"_409":433,"_410":-7},"routes/blob.tsx",{"_103":434,"_95":435,"_155":436,"_157":437,"_158":141,"_159":143,"_160":22,"_105":438,"_100":32,"_163":200,"_165":439,"_166":22,"_167":-5,"_168":-7,"_99":440,"_413":441},"19ba32c6-36a6-11f0-bc7f-9e149126039e","blob.tsx","19ba337a-36a6-11f0-bc7f-9e149126039e","ea7fb69c-2d33-4eff-88b4-b9b93ebf71b0",["D",1747874747252],"import { blob } from \"https://esm.town/v/std/blob?v=12\";\nimport { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n try {\n const { data } = await c.req.json();\n const pageId = data?.id;\n\n if (!pageId) {\n return c.json({\n success: false,\n message: \"Missing required parameter: page ID is required\",\n }, 400);\n }\n\n // Get page contents from Notion\n const page = await notion.pages.retrieve({ page_id: pageId });\n // Extract the parent database ID from the page\n let parentId = null;\n if (page.parent && page.parent.type === \"database_id\") {\n parentId = page.parent.database_id;\n }\n\n // retrieve the Notion database with the parentId and get the title\n const db = await notion.databases.retrieve({ database_id: parentId });\n const dbTitle = db.title[0].plain_text;\n\n // use the db values to set the blob for the cron to use\n const blobKey = [\n \"db\",\n // c.req.headers.get(\"host\"),\n dbTitle,\n db.id,\n ].join(\"--\");\n await blob.setJSON(blobKey, { ok: true });\n\n console.log(await blob.getJSON(blobKey));\n return c.json(await blob.getJSON(blobKey));\n } catch (error) {\n console.error(\"Error retrieving page data:\", error);\n return c.json({\n success: false,\n message: \"Failed to retrieve page data\",\n error: error.message,\n }, 500);\n }\n});\n\napp.get(\"/:id\", async (c) => {\n const pageId = c.req.param(\"id\");\n\n if (!pageId) {\n return c.json({\n success: false,\n message: \"Missing required parameter: page ID is required\",\n }, 400);\n }\n\n // Get page contents from Notion\n const page = await notion.pages.retrieve({ page_id: pageId });\n // Extract the parent database ID from the page\n let parentId = null;\n if (page.parent && page.parent.type === \"database_id\") {\n parentId = page.parent.database_id;\n }\n\n // retrieve the Notion database with the parentId and get the title\n const db = await notion.databases.retrieve({ database_id: parentId });\n const dbTitle = db.title[0].plain_text;\n\n // use the db values to set the blob for the cron to use\n const blobKey = [\n \"db\",\n // c.req.headers.get(\"host\"),\n dbTitle,\n db.id,\n ].join(\"--\");\n // await blob.setJSON(blobKey, { ok: true });\n console.log(await blob.getJSON(blobKey));\n return c.json(await blob.getJSON(blobKey));\n});\n\n// Add a GET endpoint for testing\napp.get(\"/\", async (c) => {\n return c.text(\"Blob API endpoint is working!\");\n});\n\nexport default app;",[182,435],"e3d91e69cb715b6e31e908776a7f82ab47c4e217492e596d44dcfd44d2f95ec9","modified",[444,456,470,484],{"_99":342,"_409":445,"_410":453},{"_103":446,"_95":342,"_155":447,"_157":-5,"_158":141,"_159":143,"_160":22,"_105":448,"_100":449,"_163":347,"_165":450,"_166":22,"_167":96,"_168":-7,"_99":451,"_413":452},"19ba3b4a-36a6-11f0-bc7f-9e149126039e","d96f43c4-35a5-11f0-b602-9e149126039e",["D",1747874747252],26,"import { Hono } from \"https://esm.sh/hono@3\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n// Import route modules\nimport blob from \"./routes/blob.tsx\";\nimport domain from \"./routes/domain.tsx\";\nimport embed from \"./routes/embed.tsx\";\nimport favicon from \"./routes/favicon.tsx\";\nimport showcase from \"./routes/showcase.tsx\";\nimport showcaseHTML from \"./routes/showcaseHTML.tsx\";\nimport testDomain from \"./routes/test-domain.tsx\";\nimport title from \"./routes/title.tsx\";\n\n// Create a new Hono app\nconst app = new Hono();\n\n// Mount the routers\napp.route(\"/blob\", blob);\napp.route(\"/domain\", domain);\napp.route(\"/embed\", embed);\napp.route(\"/title\", title);\napp.route(\"/favicon\", favicon);\napp.route(\"/test-domain\", testDomain);\napp.route(\"/showcase\", showcase);\napp.route(\"/showcase-html\", showcaseHTML);\n\napp.get(\"/\", (c) => c.text(\"API Gateway - Available endpoints: /blob, /domain, /title, /favicon, /test-domain, /embed, /showcase, /showcase-html\"));\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error:\", err);\n throw err;\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[342],"eb9af162e19ee4a803c6c7f2e5e7db5ab299b16f283f77485319eda47026d701",{"_103":341,"_95":342,"_155":343,"_157":-5,"_158":138,"_159":344,"_160":161,"_105":345,"_100":346,"_163":347,"_165":348,"_166":22,"_167":349,"_168":-7,"_99":454,"_413":455},[342],"1c18308722a1a96b7b74090a9b7dae755bc6d6c10868418d514bb877a0e7cbb4",{"_99":457,"_409":458,"_410":467},"routes/embed.tsx",{"_103":459,"_95":214,"_155":460,"_157":437,"_158":141,"_159":461,"_160":22,"_105":462,"_100":463,"_163":200,"_165":464,"_166":22,"_167":-5,"_168":-7,"_99":465,"_413":466},"c1edb13c-3644-11f0-aa72-9e149126039e","06ac20be-3632-11f0-919a-9e149126039e",111,["D",1747832938768],3,"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\n// import { getDomain } from \"../utils/getDomain.tsx\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n try {\n const { data } = await c.req.json();\n const pageId = data?.id;\n // console.log(pageId);\n\n // get page contents from notion\n const page = await notion.pages.retrieve({ page_id: pageId });\n\n const url = page?.properties?.URL?.url;\n\n // Extract the Name property from the page\n let nameValue = \"\";\n if (page?.properties?.Name) {\n // Handle different property types for Name\n if (page.properties.Name.type === \"title\" && page.properties.Name.title.length > 0) {\n nameValue = page.properties.Name.title.map(text => text.plain_text).join(\"\");\n } else if (page.properties.Name.type === \"rich_text\" && page.properties.Name.rich_text.length > 0) {\n nameValue = page.properties.Name.rich_text.map(text => text.plain_text).join(\"\");\n }\n }\n\n // Extract the Date property from the page\n let dateValue = \"\";\n if (page?.properties?.Date && page.properties.Date.type === \"date\" && page.properties.Date.date) {\n const dateObj = page.properties.Date.date;\n // Format: YYYY-MM-DD or with time if available\n dateValue = dateObj.start;\n\n // Format the date for better readability if needed\n try {\n const date = new Date(dateValue);\n dateValue = date.toLocaleDateString(\"en-US\", {\n weekday: \"long\",\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n });\n } catch (e) {\n // If date parsing fails, use the original value\n console.error(\"Error formatting date:\", e);\n }\n }\n\n // const { pageId, url } = await c.req.json();\n\n if (!pageId || !url) {\n return c.json({\n success: false,\n message: \"Missing required parameters: pageId and url are required\",\n }, 400);\n }\n\n // First, retrieve all existing blocks (children) of the page\n const existingBlocks = await notion.blocks.children.list({\n block_id: pageId,\n });\n\n // Delete all existing blocks\n for (const block of existingBlocks.results) {\n await notion.blocks.delete({\n block_id: block.id,\n });\n }\n\n // Extract page icon if it exists\n let pageIcon = null;\n if (page.icon) {\n if (page.icon.type === \"emoji\") {\n pageIcon = {\n type: \"emoji\",\n emoji: page.icon.emoji\n };\n } else if (page.icon.type === \"external\") {\n pageIcon = {\n type: \"external\",\n external: {\n url: page.icon.external.url\n }\n };\n } else if (page.icon.type === \"file\") {\n pageIcon = {\n type: \"external\",\n external: {\n url: page.icon.file.url\n }\n };\n }\n }\n\n // Add an embed block to the now-empty page\n const response = await notion.blocks.children.append({\n block_id: pageId,\n children: [\n // Add a callout block to contain the page properties\n {\n type: \"callout\",\n callout: {\n rich_text: [\n {\n type: \"text\",\n text: {\n content: nameValue || \"Untitled\",\n },\n annotations: {\n bold: true,\n },\n },\n ],\n // Use the page icon for the callout if available, otherwise use a default emoji\n icon: pageIcon || {\n type: \"emoji\",\n emoji: \"⛷️\",\n },\n color: \"gray_background\",\n children: [\n // Add h1 heading with the Name property value\n // {\n // type: \"heading_2\",\n // heading_2: {\n // rich_text: [\n // {\n // type: \"text\",\n // text: {\n // content: nameValue || \"Untitled\",\n // },\n // },\n // ],\n // },\n // },\n // Add date paragraph if date value exists\n ...(dateValue\n ? [{\n type: \"paragraph\",\n paragraph: {\n rich_text: [\n {\n type: \"text\",\n text: {\n content: dateValue,\n },\n },\n ],\n },\n }]\n : []),\n // Add the embed block (inside the callout)\n {\n type: \"embed\",\n embed: {\n url: url,\n },\n },\n // Add paragraph with link to the URL\n {\n type: \"paragraph\",\n paragraph: {\n rich_text: [\n {\n type: \"text\",\n text: {\n content: \"Source: \",\n },\n },\n {\n type: \"text\",\n text: {\n content: url,\n link: {\n url: url,\n },\n },\n },\n ],\n },\n },\n ],\n },\n },\n ],\n });\n\n return c.json({\n success: true,\n message: \"Embed added successfully\",\n pageId,\n url,\n response,\n });\n } catch (error) {\n console.error(\"Error adding embed:\", error);\n return c.json({\n success: false,\n message: \"Failed to add embed\",\n error: error.message,\n }, 500);\n }\n});\n\n// add sample endpoint here to test if API calls from scripts work\napp.get(\"/\", async (c) => {\n return c.text(\"Hello World!\");\n});\n\nexport default app;",[182,214],"ea5bc313c9d91f105aaba8c788240ff6ec2e6fe3bd3f956b5833f0dc6b435b6f",{"_103":213,"_95":214,"_155":215,"_157":183,"_158":138,"_159":216,"_160":161,"_105":217,"_100":118,"_163":200,"_165":218,"_166":22,"_167":-5,"_168":-7,"_99":468,"_413":469},[182,214],"8fd28fe8933146eb2bca8b66dbfd09c1641a20127271c4cb297fee463cf08299",{"_99":471,"_409":472,"_410":481},"routes/showcase.tsx",{"_103":473,"_95":231,"_155":474,"_157":437,"_158":141,"_159":475,"_160":22,"_105":476,"_100":477,"_163":200,"_165":478,"_166":22,"_167":-5,"_168":-7,"_99":479,"_413":480},"6695a13e-3688-11f0-9bdc-9e149126039e","ae1a4df4-364f-11f0-bfc4-9e149126039e",119,["D",1747861991290],4,"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\n// Helper function to extract text from title or rich_text property\nconst extractTextValue = (property: any): string => {\n if (!property) return \"\";\n\n if (property.type === \"title\" && property.title?.length > 0) {\n return property.title.map((text: any) => text.plain_text).join(\"\");\n }\n else if (property.type === \"rich_text\" && property.rich_text?.length > 0) {\n return property.rich_text.map((text: any) => text.plain_text).join(\"\");\n }\n else if (property.type === \"url\") {\n return property.url || \"\";\n }\n else if (property.type === \"select\" && property.select) {\n return property.select.name || \"\";\n }\n\n return \"\";\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.json({\n success: false,\n message: \"Missing required parameter: database ID\",\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 // return c.json({\n // success: true,\n // count: pages.length,\n // pages: pages,\n // });\n // see Steve's workaround for the issues embedding into Notion an HTTP val that renders JSON\n // https://www.val.town/x/stevekrouse/untitled-8087/code/test.tsx?log=9af048a8-eb7b-44d0-9ed1-59f82be83d86\n const contentType = c.req.headers.get(\"user-agent\") === \"NotionEmbedder\" ? \"text/html\" : \"application/json\";\n return new Response(\n JSON.stringify({\n success: true,\n count: pages.length,\n pages: pages,\n }),\n {\n headers: {\n \"content-type\": contentType,\n },\n },\n );\n } catch (error) {\n console.error(\"Error querying database:\", error);\n return c.json({\n success: false,\n message: \"Failed to query database\",\n error: error.message,\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.json({\n success: false,\n message: \"Missing required parameter: database ID\",\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 return c.json({\n success: true,\n status_filter: statusValue,\n count: pages.length,\n pages: pages,\n });\n } catch (error) {\n console.error(\"Error querying database:\", error);\n return c.json({\n success: false,\n message: \"Failed to query database\",\n error: error.message,\n }, 500);\n }\n});\n\n// Simple test endpoint\napp.get(\"/\", async (c) => {\n return c.text(\"Showcase API - Use /showcase/:database_id to get all pages from a database\");\n});\n\nexport default app;",[182,231],"37fbb9484e2ceb862dccae37c5ed1695f5d9e83f27d7c4db19d8fd4872d8edde",{"_103":230,"_95":231,"_155":232,"_157":183,"_158":138,"_159":233,"_160":161,"_105":234,"_100":235,"_163":200,"_165":236,"_166":22,"_167":-5,"_168":-7,"_99":482,"_413":483},[182,231],"61d2fe456abf9073f7c23a4e14982ffac0e615b83956ec5d48a9edca7a973e5b",{"_99":485,"_409":486,"_410":494},"routes/showcaseHTML.tsx",{"_103":487,"_95":241,"_155":488,"_157":437,"_158":141,"_159":489,"_160":22,"_105":490,"_100":118,"_163":200,"_165":491,"_166":22,"_167":-5,"_168":-7,"_99":492,"_413":493},"ff597942-3659-11f0-8494-9e149126039e","d063e7c0-3655-11f0-bce3-9e149126039e",118,["D",1747842061243],"import { Client } from \"npm:@notionhq/client\";\nimport { Hono } from \"npm:hono@3\";\n\n// Initialize Notion client\nconst notion = new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n});\n\nconst app = new Hono();\n\n// Helper function to extract text from title or rich_text property\nconst extractTextValue = (property: any): string => {\n if (!property) return \"\";\n\n if (property.type === \"title\" && property.title?.length > 0) {\n return property.title.map((text: any) => text.plain_text).join(\"\");\n }\n else if (property.type === \"rich_text\" && property.rich_text?.length > 0) {\n return property.rich_text.map((text: any) => text.plain_text).join(\"\");\n }\n else if (property.type === \"url\") {\n return property.url || \"\";\n }\n else if (property.type === \"select\" && property.select) {\n return property.select.name || \"\";\n }\n\n return \"\";\n};\n\n// Helper function to check if a URL is a YouTube URL\nconst isYouTubeUrl = (url: string): boolean => {\n if (!url) return false;\n \n const youtubeRegex = /^(https?:\\/\\/)?(www\\.)?(youtube\\.com\\/watch\\?v=|youtu\\.be\\/|youtube\\.com\\/embed\\/|youtube\\.com\\/v\\/|youtube\\.com\\/user\\/\\S+\\/\\S+\\/|youtube\\.com\\/channel\\/\\S+\\/\\S+\\/|youtube\\.com\\/playlist\\?list=|youtube\\.com\\/user\\/\\S+\\/\\S+|youtube\\.com\\/shorts\\/)([^&\\s]+)/;\n return youtubeRegex.test(url);\n};\n\n// Helper function to extract YouTube video ID from a URL\nconst extractYouTubeVideoId = (url: string): string | null => {\n if (!url) return null;\n \n // Handle youtu.be format\n if (url.includes('youtu.be/')) {\n const id = url.split('youtu.be/')[1]?.split(/[?&#]/)[0];\n return id || null;\n }\n \n // Handle youtube.com/shorts format\n if (url.includes('youtube.com/shorts/')) {\n const id = url.split('shorts/')[1]?.split(/[?&#]/)[0];\n return id || null;\n }\n \n // Handle standard youtube.com format\n const videoIdMatch = url.match(/(?:youtube\\.com\\/(?:[^\\/]+\\/.+\\/|(?:v|e(?:mbed)?)\\/|.*[?&]v=)|youtu\\.be\\/)([^\"&?\\/\\s]{11})/);\n return videoIdMatch ? videoIdMatch[1] : null;\n};\n\n// Helper function to generate YouTube embed HTML\nconst generateYouTubeEmbed = (url: string): string => {\n const videoId = extractYouTubeVideoId(url);\n if (!videoId) return '';\n \n return `\n

\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;",[182,241],"e614ffd1d03dfe44b573c0c1f745cf21b753f1694173f0005716598efbb9b93b",{"_103":240,"_95":241,"_155":242,"_157":183,"_158":138,"_159":243,"_160":161,"_105":244,"_100":245,"_163":200,"_165":246,"_166":22,"_167":-5,"_168":-7,"_99":495,"_413":496},[182,241],"4ebae83db3051d49a6d6880b72e74cdf67c3bc8e00249bcbc5565c5ede58d744","hasChanges","sourceBranch","targetBranch",{"_103":141,"_105":501,"_385":502,"_95":43,"_139":104,"_100":387,"_140":-5,"_142":-5,"_388":389,"_107":-5,"_149":22,"_109":110,"_148":94,"_16":119,"_147":96},["D",1747764573832],["D",1747936828762],"pull","actionData","errors"]

lightweight

bragreel

Mergecron-to-update-blob-with-database-jsonintomain

Hindex.tsx+13-4

routes/embed.tsx+5-6

routes/showcase.tsx+55-72

routes/showcaseHTML.tsx+25-160

Ccache.tsx+44-0

routes/cache.tsx+106-0

utils/HTMLhelpers.tsx+135-0

utils/extractValuesFromNotionProperties.tsx+19-0

routes/blob.tsx+0-96