[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_208":209,"_210":211},"routes/_app.x.$handle.$name",{"_99":98,"_32":46,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":61,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":61,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",70,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/processor.ts","latestPath","fileId","7ba8aaa6-375c-11f0-9948-9e149126039e","name","processor.ts","fileType","script","content","/**\n * Main processing logic for enriching book records\n */\n\nimport { getIncompleteRecords, updateBookRecord, NotionBookRecord, BookMetadata } from './notion.ts';\nimport { searchBookMetadata, searchBookMetadataRelaxed } from './books.ts';\n\nexport interface ProcessingResult {\n totalProcessed: number;\n successful: number;\n failed: number;\n skipped: number;\n details: Array<{\n id: string;\n title: string;\n author: string;\n status: 'success' | 'failed' | 'skipped';\n metadata?: BookMetadata;\n error?: string;\n }>;\n}\n\n/**\n * Process all incomplete book records\n */\nexport async function processIncompleteRecords(): Promise {\n const result: ProcessingResult = {\n totalProcessed: 0,\n successful: 0,\n failed: 0,\n skipped: 0,\n details: []\n };\n\n try {\n console.log('Fetching incomplete records from Notion...');\n const records = await getIncompleteRecords();\n \n console.log(`Found ${records.length} records to process`);\n result.totalProcessed = records.length;\n\n for (const record of records) {\n if (!record.title || !record.author) {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\n status: 'skipped',\n error: 'Missing title or author'\n });\n continue;\n }\n\n try {\n console.log(`Processing: \"${record.title}\" by \"${record.author}\"`);\n \n // Try exact search first\n let metadata = await searchBookMetadata(record.title, record.author);\n \n // If no results, try relaxed search\n if (!metadata) {\n console.log('Exact search failed, trying relaxed search...');\n metadata = await searchBookMetadataRelaxed(record.title, record.author);\n }\n\n if (!metadata) {\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'failed',\n error: 'No metadata found'\n });\n continue;\n }\n\n // Only update fields that are currently empty\n const updateMetadata: BookMetadata = {};\n \n if (!record.isbn && metadata.isbn) {\n updateMetadata.isbn = metadata.isbn;\n }\n \n if (!record.yearPublished && metadata.yearPublished) {\n updateMetadata.yearPublished = metadata.yearPublished;\n }\n \n if (!record.pageCount && metadata.pageCount) {\n updateMetadata.pageCount = metadata.pageCount;\n }\n \n if (!record.publisher && metadata.publisher) {\n updateMetadata.publisher = metadata.publisher;\n }\n\n // Only update if we have something to update\n if (Object.keys(updateMetadata).length > 0) {\n await updateBookRecord(record.id, updateMetadata);\n console.log(`Successfully updated: \"${record.title}\"`);\n \n result.successful++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'success',\n metadata: updateMetadata\n });\n } else {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'skipped',\n error: 'All fields already populated'\n });\n }\n\n // Add a small delay to be respectful to APIs\n await new Promise(resolve => setTimeout(resolve, 500));\n\n } catch (error) {\n console.error(`Error processing \"${record.title}\":`, error);\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'failed',\n error: error instanceof Error ? error.message : 'Unknown error'\n });\n }\n }\n\n console.log(`Processing complete: ${result.successful} successful, ${result.failed} failed, ${result.skipped} skipped`);\n return result;\n\n } catch (error) {\n console.error('Error in processIncompleteRecords:', error);\n throw error;\n }\n}\n\n/**\n * Process a single book record by ID\n */\nexport async function processSingleRecord(recordId: string): Promise {\n // This would require fetching a single record from Notion\n // For now, we'll process all and filter, but this could be optimized\n const allResults = await processIncompleteRecords();\n \n const singleResult = allResults.details.find(detail => detail.id === recordId);\n \n if (!singleResult) {\n return {\n totalProcessed: 0,\n successful: 0,\n failed: 1,\n skipped: 0,\n details: [{\n id: recordId,\n title: 'Unknown',\n author: 'Unknown',\n status: 'failed',\n error: 'Record not found or already complete'\n }]\n };\n }\n\n return {\n totalProcessed: 1,\n successful: singleResult.status === 'success' ? 1 : 0,\n failed: singleResult.status === 'failed' ? 1 : 0,\n skipped: singleResult.status === 'skipped' ? 1 : 0,\n details: [singleResult]\n };\n}","/**\n * Main processing logic for enriching book records\n */\n\nimport { getIncompleteRecords, updateBookRecord, NotionBookRecord, BookMetadata } from './notion.ts';\nimport { searchBookMetadata, searchBookMetadataRelaxed, searchBookMetadataByISBN } from './books.ts';\n\nexport interface ProcessingResult {\n totalProcessed: number;\n successful: number;\n failed: number;\n skipped: number;\n details: Array<{\n id: string;\n title: string;\n author: string;\n status: 'success' | 'failed' | 'skipped';\n metadata?: BookMetadata;\n error?: string;\n }>;\n}\n\n/**\n * Process all incomplete book records\n */\nexport async function processIncompleteRecords(): Promise {\n const result: ProcessingResult = {\n totalProcessed: 0,\n successful: 0,\n failed: 0,\n skipped: 0,\n details: []\n };\n\n try {\n console.log('Fetching incomplete records from Notion...');\n const records = await getIncompleteRecords();\n \n console.log(`Found ${records.length} records to process`);\n result.totalProcessed = records.length;\n\n for (const record of records) {\n if (!record.title || !record.author) {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\n status: 'skipped',\n error: 'Missing title or author'\n });\n continue;\n }\n\n try {\n console.log(`Processing: \"${record.title}\" by \"${record.author}\"`);\n \n // Try exact search first\n let metadata = await searchBookMetadata(record.title, record.author);\n \n // If no results, try relaxed search\n if (!metadata) {\n console.log('Exact search failed, trying relaxed search...');\n metadata = await searchBookMetadataRelaxed(record.title, record.author);\n }\n\n if (!metadata) {\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'failed',\n error: 'No metadata found'\n });\n continue;\n }\n\n // Only update fields that are currently empty\n const updateMetadata: BookMetadata = {};\n \n if (!record.isbn && metadata.isbn) {\n updateMetadata.isbn = metadata.isbn;\n }\n \n if (!record.yearPublished && metadata.yearPublished) {\n updateMetadata.yearPublished = metadata.yearPublished;\n }\n \n if (!record.pageCount && metadata.pageCount) {\n updateMetadata.pageCount = metadata.pageCount;\n }\n \n if (!record.publisher && metadata.publisher) {\n updateMetadata.publisher = metadata.publisher;\n }\n\n // Only update if we have something to update\n if (Object.keys(updateMetadata).length > 0) {\n await updateBookRecord(record.id, updateMetadata);\n console.log(`Successfully updated: \"${record.title}\"`);\n \n result.successful++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'success',\n metadata: updateMetadata\n });\n } else {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'skipped',\n error: 'All fields already populated'\n });\n }\n\n // Add a small delay to be respectful to APIs\n await new Promise(resolve => setTimeout(resolve, 500));\n\n } catch (error) {\n console.error(`Error processing \"${record.title}\":`, error);\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'failed',\n error: error instanceof Error ? error.message : 'Unknown error'\n });\n }\n }\n\n console.log(`Processing complete: ${result.successful} successful, ${result.failed} failed, ${result.skipped} skipped`);\n return result;\n\n } catch (error) {\n console.error('Error in processIncompleteRecords:', error);\n throw error;\n }\n}\n\n/**\n * Process a single book record by ID\n */\nexport async function processSingleRecord(recordId: string): Promise {\n // This would require fetching a single record from Notion\n // For now, we'll process all and filter, but this could be optimized\n const allResults = await processIncompleteRecords();\n \n const singleResult = allResults.details.find(detail => detail.id === recordId);\n \n if (!singleResult) {\n return {\n totalProcessed: 0,\n successful: 0,\n failed: 1,\n skipped: 0,\n details: [{\n id: recordId,\n title: 'Unknown',\n author: 'Unknown',\n status: 'failed',\n error: 'Record not found or already complete'\n }]\n };\n }\n\n return {\n totalProcessed: 1,\n successful: singleResult.status === 'success' ? 1 : 0,\n failed: singleResult.status === 'failed' ? 1 : 0,\n skipped: singleResult.status === 'skipped' ? 1 : 0,\n details: [singleResult]\n };\n}","createdAt",["D",1747963378964],"branchVersion","branchId","e2a912a0-375b-11f0-b362-9e149126039e","id","e2a8e384-375b-11f0-b362-9e149126039e","book-lookup-notion",["D",1747952823274],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","use google book api to look up bibliographic metadata elements","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/b264b89e-466c-4d55-8eb9-e8a9baa1af00/square512?exp=1789617157&sig=9b22fd5da5cdb449c74af4102088551c596583091483fdb310b0c1de2eea7933","56a0f9e0-375a-11f0-a39d-3380429e1c83","pinnedFileId","866870fc-375c-11f0-a2c2-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","c07a30e6-b724-410c-b54c-45df602d6743","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":57,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",81,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nucky","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4VHNLcXVkc2Yxc3RjbzRvSloxRW5OQ1FYRCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":204,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":61,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":205,"_83":206,"_85":207,"_87":25},"tree",[160,165],"files",[160,161,162,163,164,165],"counts",{"_150":147,"_151":65,"_152":65,"_153":154,"_155":156},"contents",[129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":142,"_32":143,"_30":144,"_134":-5,"_42":43,"_41":145,"_136":61,"_39":146,"_13":147,"_34":148,"_36":-5,"_24":25,"_140":-5,"_27":149},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":135,"_136":25,"_39":137,"_13":138,"_34":20,"_36":139,"_24":25,"_140":-5,"_27":141},"e5b6e066-3770-11f0-9b69-9e149126039e","README.md","58f49894-375c-11f0-a0b7-9e149126039e","parentId",65,"latest",["D",1747961847826],10,"# Notion Book Database Auto-Populator\n\nThis Val automatically enriches your existing \"val Book Lookup\" database by fetching comprehensive metadata from Google Books API.\n\n## How It Works\n\nYou already have the perfect setup! Your \"val Book Lookup\" database contains:\n- **Title** ✓\n- **Author** ✓ \n- **ISBN** ✓\n- **Year Published** ✓\n- **Page Count** ✓\n- **Publisher** ✓\n\nThe Val will:\n1. Find records with Title + Author but missing other data\n2. Search Google Books API for metadata\n3. Fill in the empty fields automatically\n\n## Current Workflow\n\n### Your Current Setup (Perfect!):\n1. **Add books** to \"val Book Lookup\" → Enter Title + Author\n2. **Press the button** (visit your Val URL) → It fills in all available metadata\n3. **Link to your main Books database** via Relations/Rollups\n\n### Metadata Currently Being Captured:\nYour script pulls comprehensive data from Google Books API:\n\n**Core Fields** (currently in your table):\n- ✅ **ISBN** - Prefers ISBN-13, falls back to ISBN-10\n- ✅ **Year Published** - Extracted from publication date\n- ✅ **Page Count** - Direct from Google Books\n- ✅ **Publisher** - Direct from Google Books\n- ✅ **Description** - Available (add column to see it)\n\n**Rich Metadata Available** (add these columns to capture):\n- **Subtitle** (Rich text) - Book subtitle\n- **Categories** (Multi-select) - Genre/subject categories\n- **Average Rating** (Number) - Google Books rating\n- **Ratings Count** (Number) - Number of ratings\n- **Language** (Rich text) - Book language\n- **Published Date** (Rich text) - Full publication date\n- **Preview Link** (URL) - Google Books preview\n- **Info Link** (URL) - Google Books info page\n- **Image Links** (Rich text) - Book cover images (JSON)\n\n## Setup (Already Done!)\n\nYour system is already configured! Just make sure:\n- `NOTION_API_TOKEN` points to your integration\n- `NOTION_DATABASE_ID` points to your \"val Book Lookup\" database\n\n## Usage\n\n### Manual Processing (Your Current Setup)\n**To process all incomplete records:**\nVisit: `https://your-val-url.web.val.run/`\n\n**To check system status:**\nVisit: `https://your-val-url.web.val.run/status`\n\n**To process a specific record:**\nVisit: `https://your-val-url.web.val.run/process/RECORD_ID`\n\n**To see all available endpoints:**\nVisit: `https://your-val-url.web.val.run/help`\n\n## Linking to Your Main Books Database\n\nTo connect your \"val Book Lookup\" to your main reading database:\n\n1. **Add Relation Property** to your main Books database:\n - Name: \"Book Info\" \n - Type: Relation\n - Related database: \"val Book Lookup\"\n\n2. **Add Rollup Properties** to show metadata:\n - **ISBN**: Rollup → Book Info → ISBN\n - **Year**: Rollup → Book Info → Year Published \n - **Pages**: Rollup → Book Info → Page Count\n - **Publisher**: Rollup → Book Info → Publisher\n\nNow when you add a book to your main database, just link it to the corresponding record in \"val Book Lookup\"!\n\n## API Endpoints\n\n- `GET /` - Process all incomplete records\n- `GET /status` - Check configuration\n- `GET /process/:recordId` - Process specific record\n- `GET /health` - Health check\n\n## Files\n\n- `/backend/index.ts` - Main HTTP handler with manual trigger\n- `/backend/notion.ts` - Notion API integration with comprehensive metadata support\n- `/backend/books.ts` - Google Books API with extensive metadata extraction\n- `/backend/processor.ts` - Processing logic for enriching records\n\n## Benefits\n\n✅ **Works with your existing setup** \n✅ **Comprehensive Google Books metadata** (15+ fields available)\n✅ **Smart matching algorithm** (exact + relaxed search)\n✅ **Only fills empty fields** (preserves your data)\n✅ **Manual button-press execution** (no unwanted automation)\n✅ **Links to your reading database** via Relations/Rollups\n✅ **Expandable with more metadata columns** (just add them to Notion)","label",[132],"62ee15c8-375c-11f0-8c16-9e149126039e","backend","ba931684-cf88-4b01-bc83-bc2015e23f85",2,["D",1747953038469],0,"directory",[143],"pulls","branches","forks","envVars",{"_157":145,"_159":147},"connections",{"_157":147,"_158":147},"count","unfilledCount","emptyCount",{"_44":142,"_32":143,"_30":144,"_134":-5,"_42":43,"_41":145,"_136":61,"_39":201,"_13":147,"_34":148,"_36":-5,"_24":25,"_140":-5,"_167":202,"_27":203},{"_44":192,"_32":193,"_30":194,"_134":144,"_42":43,"_41":195,"_136":61,"_39":196,"_13":197,"_34":35,"_36":198,"_24":25,"_140":-5,"_167":199,"_27":200},{"_44":183,"_32":184,"_30":59,"_134":144,"_42":43,"_41":185,"_136":61,"_39":186,"_13":187,"_34":188,"_36":189,"_24":25,"_140":-5,"_167":190,"_27":191},{"_44":174,"_32":175,"_30":176,"_134":144,"_42":43,"_41":177,"_136":25,"_39":178,"_13":179,"_34":35,"_36":180,"_24":25,"_140":-5,"_167":181,"_27":182},{"_44":170,"_32":33,"_30":31,"_134":144,"_42":43,"_41":14,"_136":25,"_39":171,"_13":65,"_34":35,"_36":38,"_24":25,"_140":-5,"_167":172,"_27":173},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":135,"_136":25,"_39":166,"_13":138,"_34":20,"_36":139,"_24":25,"_140":-5,"_167":168,"_27":169},["D",1747961847826],"children",[],[132],"76587bae-3774-11f0-b826-9e149126039e",["D",1747963378964],[],[143,33],"72d357f6-3774-11f0-af4f-9e149126039e","notion.ts","62edf002-375c-11f0-8c16-9e149126039e",69,["D",1747963373059],31,"/**\n * Notion API integration for book database\n */\n\nexport interface NotionBookRecord {\n id: string;\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n // Additional Google Books metadata\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: string; // Store as JSON string\n // Status tracking\n processed?: boolean;\n lastUpdated?: string;\n}\n\nexport interface BookMetadata {\n // Core fields (mapped to Notion database)\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n \n // Additional Google Books fields (available for future use)\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: {\n smallThumbnail?: string;\n thumbnail?: string;\n small?: string;\n medium?: string;\n large?: string;\n extraLarge?: string;\n };\n}\n\nconst NOTION_API_BASE = 'https://api.notion.com/v1';\n\n/**\n * Get records from Notion database that need metadata enrichment\n * This includes:\n * 1. Records with Title + Author but missing other metadata\n * 2. Records with ISBN but missing Title + Author\n */\nexport async function getIncompleteRecords(): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (!token || !databaseId) {\n throw new Error('Missing NOTION_API_TOKEN or NOTION_DATABASE_ID environment variables');\n }\n\n console.log('Debug info:', {\n tokenPrefix: token.substring(0, 10) + '...',\n databaseIdLength: databaseId.length,\n databaseIdPrefix: databaseId.substring(0, 8) + '...'\n });\n\n const response = await fetch(`${NOTION_API_BASE}/databases/${databaseId}/query`, {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n filter: {\n or: [\n // Records with Title + Author but missing other metadata\n {\n and: [\n {\n property: 'Title',\n title: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n or: [\n {\n property: 'ISBN',\n rich_text: {\n is_empty: true\n }\n },\n {\n property: 'Year Published',\n number: {\n is_empty: true\n }\n },\n {\n property: 'Page Count',\n number: {\n is_empty: true\n }\n },\n {\n property: 'Publisher',\n rich_text: {\n is_empty: true\n }\n }\n ]\n }\n ]\n },\n // Records with ISBN but missing Title + Author\n {\n and: [\n {\n property: 'ISBN',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n or: [\n {\n property: 'Title',\n title: {\n is_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_empty: true\n }\n }\n ]\n }\n ]\n }\n ]\n }\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error('Notion API Error Details:', {\n status: response.status,\n statusText: response.statusText,\n errorText,\n headers: Object.fromEntries(response.headers.entries())\n });\n throw new Error(`Notion API error: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n const data = await response.json();\n \n return data.results.map((page: any) => ({\n id: page.id,\n title: page.properties.Title?.title?.[0]?.text?.content,\n author: page.properties.Author?.rich_text?.[0]?.text?.content,\n isbn: page.properties.ISBN?.rich_text?.[0]?.text?.content,\n yearPublished: page.properties['Year Published']?.number,\n pageCount: page.properties['Page Count']?.number,\n publisher: page.properties.Publisher?.rich_text?.[0]?.text?.content,\n // Optional additional fields (if they exist)\n subtitle: page.properties.Subtitle?.rich_text?.[0]?.text?.content,\n description: page.properties.Description?.rich_text?.[0]?.text?.content,\n categories: page.properties.Categories?.multi_select?.map((cat: any) => cat.name),\n averageRating: page.properties['Average Rating']?.number,\n ratingsCount: page.properties['Ratings Count']?.number,\n language: page.properties.Language?.rich_text?.[0]?.text?.content,\n publishedDate: page.properties['Published Date']?.rich_text?.[0]?.text?.content,\n previewLink: page.properties['Preview Link']?.url,\n infoLink: page.properties['Info Link']?.url,\n imageLinks: page.properties['Image Links']?.rich_text?.[0]?.text?.content,\n processed: page.properties.Processed?.checkbox,\n lastUpdated: page.properties['Last Updated']?.last_edited_time,\n }));\n}\n\n/**\n * Update a Notion record with book metadata\n */\nexport async function updateBookRecord(recordId: string, metadata: BookMetadata): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n \n if (!token) {\n throw new Error('Missing NOTION_API_TOKEN environment variable');\n }\n\n const properties: any = {};\n\n // Core metadata fields (always try to update these)\n if (metadata.title) {\n properties.Title = {\n title: [\n {\n text: {\n content: metadata.title\n }\n }\n ]\n };\n }\n\n if (metadata.author) {\n properties.Author = {\n rich_text: [\n {\n text: {\n content: metadata.author\n }\n }\n ]\n };\n }\n\n if (metadata.isbn) {\n properties.ISBN = {\n rich_text: [\n {\n text: {\n content: metadata.isbn\n }\n }\n ]\n };\n }\n\n if (metadata.yearPublished) {\n properties['Year Published'] = {\n number: metadata.yearPublished\n };\n }\n\n if (metadata.pageCount) {\n properties['Page Count'] = {\n number: metadata.pageCount\n };\n }\n\n if (metadata.publisher) {\n properties.Publisher = {\n rich_text: [\n {\n text: {\n content: metadata.publisher\n }\n }\n ]\n };\n }\n\n // Additional Google Books metadata (only if columns exist)\n // These will silently fail if the properties don't exist, which is fine\n try {\n if (metadata.subtitle) {\n properties.Subtitle = {\n rich_text: [\n {\n text: {\n content: metadata.subtitle\n }\n }\n ]\n };\n }\n\n if (metadata.description) {\n const truncatedDescription = metadata.description.length > 2000 \n ? metadata.description.substring(0, 1997) + \"...\"\n : metadata.description;\n \n properties.Description = {\n rich_text: [\n {\n text: {\n content: truncatedDescription\n }\n }\n ]\n };\n }\n\n if (metadata.categories && metadata.categories.length > 0) {\n properties.Categories = {\n multi_select: metadata.categories.slice(0, 10).map(cat => ({ name: cat }))\n };\n }\n\n if (metadata.averageRating) {\n properties['Average Rating'] = {\n number: metadata.averageRating\n };\n }\n\n if (metadata.ratingsCount) {\n properties['Ratings Count'] = {\n number: metadata.ratingsCount\n };\n }\n\n if (metadata.language) {\n properties.Language = {\n rich_text: [\n {\n text: {\n content: metadata.language\n }\n }\n ]\n };\n }\n\n if (metadata.publishedDate) {\n properties['Published Date'] = {\n rich_text: [\n {\n text: {\n content: metadata.publishedDate\n }\n }\n ]\n };\n }\n\n if (metadata.previewLink) {\n properties['Preview Link'] = {\n url: metadata.previewLink\n };\n }\n\n if (metadata.infoLink) {\n properties['Info Link'] = {\n url: metadata.infoLink\n };\n }\n\n if (metadata.imageLinks) {\n properties['Image Links'] = {\n rich_text: [\n {\n text: {\n content: JSON.stringify(metadata.imageLinks)\n }\n }\n ]\n };\n }\n } catch (error) {\n // Additional properties don't exist in database, that's fine\n console.log('Some additional properties not found in database, skipping...');\n }\n\n const response = await fetch(`${NOTION_API_BASE}/pages/${recordId}`, {\n method: 'PATCH',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n properties\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Failed to update Notion record: ${response.status} ${response.statusText} - ${errorText}`);\n }\n}",[],[143,175],"1f6ae754-3770-11f0-888c-9e149126039e","index.ts",60,["D",1747961515134],5,"http","/**\n * Notion Book Database Auto-Populator\n * Main HTTP handler and API endpoints\n */\n\nimport { Hono } from 'https://esm.sh/hono@3.11.7';\nimport { processIncompleteRecords, processSingleRecord } from './processor.ts';\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n/**\n * Main endpoint - process all incomplete records\n */\napp.get('/', async (c) => {\n try {\n console.log('Starting book metadata enrichment process...');\n const result = await processIncompleteRecords();\n \n return c.json({\n success: true,\n message: 'Processing completed',\n result,\n timestamp: new Date().toISOString()\n });\n } catch (error) {\n console.error('Error in main process:', error);\n \n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n timestamp: new Date().toISOString()\n }, 500);\n }\n});\n\n/**\n * Status endpoint - check configuration and system status\n */\napp.get('/status', async (c) => {\n const hasNotionToken = !!Deno.env.get('NOTION_API_TOKEN');\n const hasNotionDatabase = !!Deno.env.get('NOTION_DATABASE_ID');\n \n const status = {\n configured: hasNotionToken && hasNotionDatabase,\n notion_token: hasNotionToken ? 'Set' : 'Missing',\n notion_database: hasNotionDatabase ? 'Set' : 'Missing',\n timestamp: new Date().toISOString()\n };\n\n if (!status.configured) {\n return c.json({\n success: false,\n message: 'System not properly configured',\n status,\n setup_instructions: {\n notion_token: 'Set NOTION_API_TOKEN environment variable with your Notion integration token',\n notion_database: 'Set NOTION_DATABASE_ID environment variable with your book database ID'\n }\n }, 400);\n }\n\n return c.json({\n success: true,\n message: 'System ready',\n status\n });\n});\n\n/**\n * Process a specific record by ID\n */\napp.get('/process/:recordId', async (c) => {\n const recordId = c.req.param('recordId');\n \n if (!recordId) {\n return c.json({\n success: false,\n error: 'Record ID is required'\n }, 400);\n }\n\n try {\n const result = await processSingleRecord(recordId);\n \n return c.json({\n success: true,\n message: 'Record processing completed',\n result,\n timestamp: new Date().toISOString()\n });\n } catch (error) {\n console.error(`Error processing record ${recordId}:`, error);\n \n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n timestamp: new Date().toISOString()\n }, 500);\n }\n});\n\n/**\n * Debug endpoint - check environment variables (remove in production)\n */\napp.get('/debug', (c) => {\n const token = Deno.env.get('NOTION_API_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n return c.json({\n token_info: {\n exists: !!token,\n length: token?.length || 0,\n prefix: token?.substring(0, 10) + '...' || 'N/A'\n },\n database_info: {\n exists: !!databaseId,\n length: databaseId?.length || 0,\n prefix: databaseId?.substring(0, 8) + '...' || 'N/A'\n }\n });\n});\n\n/**\n * Test Open Library endpoint for debugging\n */\napp.get('/test-worldcat/:title/:author', async (c) => {\n const title = c.req.param('title');\n const author = c.req.param('author');\n \n try {\n const query = `title:\"${title.trim()}\" author:\"${author.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://openlibrary.org/search.json?q=${encodedQuery}&limit=5`\n );\n\n const data = await response.json();\n \n return c.json({\n query,\n status: response.status,\n resultCount: data.docs?.length || 0,\n firstResult: data.docs?.[0] || null\n });\n } catch (error) {\n return c.json({\n error: error instanceof Error ? error.message : 'Unknown error'\n }, 500);\n }\n});\n\n/**\n * Health check endpoint\n */\napp.get('/health', (c) => {\n return c.json({\n status: 'healthy',\n timestamp: new Date().toISOString()\n });\n});\n\n/**\n * Help endpoint with usage instructions\n */\napp.get('/help', (c) => {\n return c.json({\n title: 'Notion Book Database Auto-Populator',\n description: 'Automatically enriches your Notion book database with metadata from Google Books API',\n endpoints: {\n 'GET /': 'Process all incomplete records',\n 'GET /status': 'Check system configuration and status',\n 'GET /process/:recordId': 'Process a specific record by ID',\n 'GET /health': 'Health check',\n 'GET /help': 'This help message'\n },\n setup: {\n step1: 'Create a Notion integration at https://www.notion.so/my-integrations',\n step2: 'Copy the integration token and set it as NOTION_API_TOKEN environment variable',\n step3: 'Share your book database with the integration',\n step4: 'Copy the database ID from the URL and set it as NOTION_DATABASE_ID environment variable',\n step5: 'Ensure your database has these properties: Title (title), Author (rich text), ISBN (rich text), Year Published (number), Page Count (number), Publisher (rich text)'\n },\n database_properties: {\n required: ['Title (title)', 'Author (rich text)'],\n populated: ['ISBN (rich text)', 'Year Published (number)', 'Page Count (number)', 'Publisher (rich text)'],\n optional: ['Rating (number)', 'Progress (select)', 'Start Date (date)', 'Finish Date (date)', 'Notes (rich text)']\n }\n });\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[143,184],"558cdee2-3774-11f0-94c7-9e149126039e","books.ts","70297fca-375c-11f0-b228-9e149126039e",66,["D",1747963323943],12,"/**\n * Google Books API integration for comprehensive book metadata\n */\n\nimport { BookMetadata } from './notion.ts';\n\n/**\n * Search for book metadata using Google Books API\n */\nexport async function searchBookMetadata(title: string, author: string): Promise {\n return await searchGoogleBooks(title, author);\n}\n\n/**\n * Search for book metadata using ISBN\n */\nexport async function searchBookMetadataByISBN(isbn: string): Promise {\n try {\n console.log(`Searching Google Books by ISBN: ${isbn}`);\n \n // Clean the ISBN (remove hyphens, spaces)\n const cleanISBN = isbn.replace(/[-\\s]/g, '');\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=isbn:${cleanISBN}`\n );\n\n if (!response.ok) {\n console.error(`Google Books API error: ${response.status} ${response.statusText}`);\n return null;\n }\n\n const data = await response.json();\n console.log(`Google Books found ${data.totalItems || 0} results for ISBN ${isbn}`);\n \n if (!data.items || data.items.length === 0) {\n console.log(`No books found for ISBN: ${isbn}`);\n return null;\n }\n\n // ISBN search should return exact match, so take the first result\n const item = data.items[0];\n const volumeInfo = item.volumeInfo;\n \n if (!volumeInfo) {\n return null;\n }\n\n console.log(`Found: \"${volumeInfo.title}\" by ${volumeInfo.authors?.[0]}`);\n\n // Extract all available metadata\n const publishedDate = volumeInfo.publishedDate;\n let year = null;\n if (publishedDate) {\n const yearMatch = publishedDate.match(/^\\d{4}/);\n if (yearMatch) {\n year = parseInt(yearMatch[0]);\n }\n }\n\n // Get ISBN (prefer ISBN-13, fallback to ISBN-10)\n let foundISBN = null;\n if (volumeInfo.industryIdentifiers) {\n const isbn13 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_13');\n const isbn10 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_10');\n foundISBN = isbn13?.identifier || isbn10?.identifier;\n }\n\n // Return comprehensive metadata object\n const metadata: BookMetadata = {};\n \n // Include title and author since they might be missing from the record\n if (volumeInfo.title) {\n metadata.title = volumeInfo.title;\n }\n \n if (volumeInfo.authors && volumeInfo.authors.length > 0) {\n metadata.author = volumeInfo.authors[0]; // Take first author\n }\n \n if (year) {\n metadata.yearPublished = year;\n }\n \n if (volumeInfo.publisher) {\n metadata.publisher = volumeInfo.publisher;\n }\n\n if (volumeInfo.pageCount) {\n metadata.pageCount = volumeInfo.pageCount;\n }\n\n if (foundISBN) {\n metadata.isbn = foundISBN;\n }\n\n // Additional fields\n if (volumeInfo.subtitle) {\n metadata.subtitle = volumeInfo.subtitle;\n }\n\n if (volumeInfo.description) {\n metadata.description = volumeInfo.description;\n }\n\n if (volumeInfo.categories && volumeInfo.categories.length > 0) {\n metadata.categories = volumeInfo.categories;\n }\n\n if (volumeInfo.averageRating) {\n metadata.averageRating = volumeInfo.averageRating;\n }\n\n if (volumeInfo.ratingsCount) {\n metadata.ratingsCount = volumeInfo.ratingsCount;\n }\n\n if (volumeInfo.language) {\n metadata.language = volumeInfo.language;\n }\n\n if (volumeInfo.publishedDate) {\n metadata.publishedDate = volumeInfo.publishedDate;\n }\n\n if (volumeInfo.previewLink) {\n metadata.previewLink = volumeInfo.previewLink;\n }\n\n if (volumeInfo.infoLink) {\n metadata.infoLink = volumeInfo.infoLink;\n }\n\n if (volumeInfo.imageLinks) {\n metadata.imageLinks = volumeInfo.imageLinks;\n }\n\n return metadata;\n } catch (error) {\n console.error('Error searching Google Books by ISBN:', error);\n return null;\n }\n}\n\n/**\n * Search Google Books API for comprehensive book data\n */\nasync function searchGoogleBooks(title: string, author: string): Promise {\n try {\n console.log(`Searching Google Books for: \"${title}\" by \"${author}\"`);\n \n // Google Books API search with title and author\n const query = `intitle:\"${title.trim()}\" inauthor:\"${author.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=${encodedQuery}&maxResults=20&printType=books`\n );\n\n if (!response.ok) {\n console.error(`Google Books API error: ${response.status} ${response.statusText}`);\n return null;\n }\n\n const data = await response.json();\n console.log(`Google Books found ${data.totalItems || 0} results`);\n \n if (!data.items || data.items.length === 0) {\n console.log(`No books found for: \"${title}\" by \"${author}\"`);\n return null;\n }\n\n return findBestGoogleBooksMatch(data.items, title, author);\n } catch (error) {\n console.error('Error searching Google Books:', error);\n return null;\n }\n}\n\n/**\n * Find the best matching book from Google Books results\n */\nfunction findBestGoogleBooksMatch(items: any[], targetTitle: string, targetAuthor: string): BookMetadata | null {\n const normalize = (s: string) => s.toLowerCase().replace(/[^\\w\\s]/g, '').trim();\n const normalizedTargetTitle = normalize(targetTitle);\n const normalizedTargetAuthor = normalize(targetAuthor);\n\n const candidates = [];\n\n for (const item of items) {\n const volumeInfo = item.volumeInfo;\n if (!volumeInfo.title || !volumeInfo.authors) continue;\n\n const bookTitle = normalize(volumeInfo.title);\n const bookAuthors = volumeInfo.authors.map((author: string) => normalize(author));\n\n // Check for title and author match\n const titleMatch = bookTitle.includes(normalizedTargetTitle) || normalizedTargetTitle.includes(bookTitle);\n const authorMatch = bookAuthors.some((author: string) => \n author.includes(normalizedTargetAuthor) || normalizedTargetAuthor.includes(author)\n );\n\n if (titleMatch && authorMatch) {\n // Extract all available metadata\n const publishedDate = volumeInfo.publishedDate;\n let year = null;\n if (publishedDate) {\n const yearMatch = publishedDate.match(/^\\d{4}/);\n if (yearMatch) {\n year = parseInt(yearMatch[0]);\n }\n }\n\n // Get ISBN (prefer ISBN-13, fallback to ISBN-10)\n let isbn = null;\n if (volumeInfo.industryIdentifiers) {\n const isbn13 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_13');\n const isbn10 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_10');\n isbn = isbn13?.identifier || isbn10?.identifier;\n }\n\n candidates.push({\n title: volumeInfo.title,\n subtitle: volumeInfo.subtitle,\n authors: volumeInfo.authors,\n publisher: volumeInfo.publisher,\n publishedDate: volumeInfo.publishedDate,\n year: year,\n description: volumeInfo.description,\n pageCount: volumeInfo.pageCount,\n categories: volumeInfo.categories,\n averageRating: volumeInfo.averageRating,\n ratingsCount: volumeInfo.ratingsCount,\n maturityRating: volumeInfo.maturityRating,\n language: volumeInfo.language,\n previewLink: volumeInfo.previewLink,\n infoLink: volumeInfo.infoLink,\n canonicalVolumeLink: volumeInfo.canonicalVolumeLink,\n isbn: isbn,\n imageLinks: volumeInfo.imageLinks,\n score: (titleMatch ? 2 : 0) + (authorMatch ? 2 : 0)\n });\n\n console.log(`Candidate: \"${volumeInfo.title}\" by ${volumeInfo.authors?.[0]} (${year}, ${volumeInfo.publisher})`);\n }\n }\n\n if (candidates.length === 0) {\n return null;\n }\n\n // Sort by score first, then by publication year (prefer earlier for classics)\n candidates.sort((a, b) => {\n if (a.score !== b.score) return b.score - a.score;\n if (!a.year && !b.year) return 0;\n if (!a.year) return 1;\n if (!b.year) return -1;\n return a.year - b.year;\n });\n\n const best = candidates[0];\n console.log(`Selected: \"${best.title}\" by ${best.authors?.[0]} (${best.year}, ${best.publisher})`);\n\n // Return comprehensive metadata object\n const metadata: BookMetadata = {};\n \n if (best.year) {\n metadata.yearPublished = best.year;\n }\n \n if (best.publisher) {\n metadata.publisher = best.publisher;\n }\n\n if (best.pageCount) {\n metadata.pageCount = best.pageCount;\n }\n\n if (best.isbn) {\n metadata.isbn = best.isbn;\n }\n\n // Additional fields that might be useful\n if (best.subtitle) {\n metadata.subtitle = best.subtitle;\n }\n\n if (best.description) {\n metadata.description = best.description;\n }\n\n if (best.categories && best.categories.length > 0) {\n metadata.categories = best.categories;\n }\n\n if (best.averageRating) {\n metadata.averageRating = best.averageRating;\n }\n\n if (best.ratingsCount) {\n metadata.ratingsCount = best.ratingsCount;\n }\n\n if (best.language) {\n metadata.language = best.language;\n }\n\n if (best.publishedDate) {\n metadata.publishedDate = best.publishedDate;\n }\n\n if (best.previewLink) {\n metadata.previewLink = best.previewLink;\n }\n\n if (best.infoLink) {\n metadata.infoLink = best.infoLink;\n }\n\n if (best.imageLinks) {\n metadata.imageLinks = best.imageLinks;\n }\n\n return metadata;\n}\n\n/**\n * Alternative search with relaxed criteria if exact search fails\n */\nexport async function searchBookMetadataRelaxed(title: string, author: string): Promise {\n try {\n console.log(`Relaxed Google Books search for: \"${title}\"`);\n \n // Try with just the title\n const query = `intitle:\"${title.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=${encodedQuery}&maxResults=30&printType=books`\n );\n\n if (!response.ok) {\n return null;\n }\n\n const data = await response.json();\n \n if (!data.items || data.items.length === 0) {\n return null;\n }\n\n return findBestGoogleBooksMatch(data.items, title, author);\n } catch (error) {\n console.error('Error in relaxed Google Books search:', error);\n return null;\n }\n}",[],[143,193],["D",1747953038469],[161,162,163,164],[143],["D",1747952823274],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":57,"_103":104,"_105":25},{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_126":241,"_242":243,"_244":245,"_246":25,"_247":25,"_248":25,"_249":61,"_250":-5,"_251":-7,"_252":-7,"_253":147,"_254":25,"_255":25,"_256":-5,"_257":25,"_258":25,"_259":25,"_260":-5},"ENV",{"_212":213,"_214":215,"_216":89,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v70