[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_252":253,"_254":255},"routes/_app.x.$handle.$name",{"_106":105,"_32":50,"_114":93,"_27":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_21":-5,"_126":127,"_128":129,"_130":25,"_131":132,"_133":65,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_36":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":60,"_18":61,"_62":63,"_64":65,"_66":65,"_67":-5,"_68":69,"_70":71,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":25},"version",3,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","shared","latestPath","fileId","baf47cf4-e60d-4061-b269-5deb74833310","name","fileType","directory","content","createdAt",["D",1748331357498],"branchVersion","branchId","4ac8d10e-3acc-11f0-96de-9e149126039e",{"_30":43,"_32":44,"_33":45,"_35":46,"_36":47,"_38":14,"_39":40,"_24":25},"shared/types.ts","3aa4bc38-3acd-11f0-a81c-9e149126039e","types.ts","script","/**\n * Shared types for the Book Lookup application\n */\n\nexport interface BookMetadata {\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n publisher?: string;\n pageCount?: number;\n description?: string;\n subtitle?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: any;\n}\n\nexport interface SearchRequest {\n type: 'title-author' | 'isbn';\n title?: string;\n author?: string;\n isbn?: string;\n}\n\nexport interface SearchResponse {\n success: boolean;\n book?: BookMetadata;\n error?: string;\n}\n\nexport interface BulkSearchRequest {\n requests: SearchRequest[];\n}\n\nexport interface BulkSearchResponse {\n success: boolean;\n books: (BookMetadata | null)[];\n errors?: string[];\n}",["D",1748331357498],"id","4ac6931c-3acc-11f0-96de-9e149126039e","book-lookup-browser",["D",1748330955065],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","web app that lets you look up books with title+author or ISBN","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aec0d867-386b-46da-2bf8-34b815d05400/square512?exp=1789725586&sig=accdf13dc6ef7c15fea6e1a382750489634b3a27421e33aa3f2b69a80d48d4b5","56a0f9e0-375a-11f0-a39d-3380429e1c83","pinnedFileId","9ccb0ede-d286-490c-b572-1a5c352fdf6d","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","c07a30e6-b724-410c-b54c-45df602d6743","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_106":105,"_113":109},"org",{"_106":105,"_107":-5,"_108":109,"_18":61,"_110":111,"_112":25},"branch",{"_13":92,"_32":93,"_48":40,"_94":49,"_95":96,"_97":98,"_99":55,"_100":101,"_102":71,"_103":50,"_104":105},"isOwned",36,"main","projectId","forkedBranchId","e2a912a0-375b-11f0-b362-9e149126039e","forkedBranchVersion",78,"forkedProjectPrivacy","forkedProjectId","e2a8e384-375b-11f0-b362-9e149126039e","forkedProjectOrgId","projectName","userHandle","nucky","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4VHNLcXVkc2Yxc3RjbzRvSloxRW5OQ1FYRCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":248,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":60,"_18":61,"_62":63,"_64":65,"_66":65,"_67":-5,"_68":69,"_70":71,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":249,"_87":250,"_89":251,"_91":25},"tree",[185,190,192,194],"files",[185,186,187,188,189,190,191,192,193,194],"counts",{"_175":69,"_176":156,"_177":69,"_178":179,"_180":181},"contents",[148,149,150,151],"upstreamProject",{"_48":101,"_32":144,"_57":145,"_59":146,"_54":55,"_85":147},"upstreamBranch",{"_48":96,"_36":138,"_139":140,"_32":93,"_94":101,"_13":141,"_95":-5,"_97":-5,"_142":143,"_52":-5,"_91":25,"_54":55,"_104":105,"_70":71,"_103":144},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1747952823274],"updatedAt",["D",1748332408384],81,"lockfileKey","1748373639899-esm.town_v_nucky_book-lookup-notion@81-main","book-lookup-notion","use google book api to look up bibliographic metadata elements","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/b264b89e-466c-4d55-8eb9-e8a9baa1af00/square512?exp=1789725586&sig=4b981eafc26929b7a5bc495aade2a965ffd48094c13a96cba2a77795b2ed8c51",{"_106":105,"_113":109},{"_48":170,"_32":171,"_30":172,"_155":-5,"_39":40,"_38":156,"_157":65,"_36":173,"_13":69,"_33":34,"_35":-5,"_24":25,"_160":-5,"_27":174},{"_48":165,"_32":166,"_30":167,"_155":-5,"_39":40,"_38":156,"_157":65,"_36":168,"_13":69,"_33":34,"_35":-5,"_24":25,"_160":-5,"_27":169},{"_48":162,"_32":28,"_30":31,"_155":-5,"_39":40,"_38":14,"_157":65,"_36":163,"_13":69,"_33":34,"_35":-5,"_24":25,"_160":-5,"_27":164},{"_48":152,"_32":153,"_30":154,"_155":-5,"_39":40,"_38":156,"_157":25,"_36":158,"_13":69,"_33":21,"_35":159,"_24":25,"_160":-5,"_27":161},"4acbe718-3acc-11f0-96de-9e149126039e","README.md","6d0aa768-60d5-4e1d-a315-add145394d58","parentId",1,"latest",["D",1748330955065],"# 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. **NEW:** Find records with ISBN but missing Title + Author\n3. Search Google Books API for metadata\n4. Fill in the empty fields automatically\n\n## Current Workflow\n\n### Your Enhanced Setup:\n1. **Add books** to \"val Book Lookup\" → Enter either:\n - **Title + Author** (traditional method), OR\n - **Just ISBN** (new method!)\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### Two Ways to Add Books:\n\n**Method 1: Title + Author** (your existing workflow)\n- Add Title and Author to a new record\n- Script finds ISBN, year, page count, publisher, etc.\n\n**Method 2: ISBN Only** (new capability!)\n- Add just the ISBN to a new record\n- Script finds Title, Author, year, page count, publisher, etc.\n- Perfect for when you have a book in hand but don't want to type the details\n### Your Enhanced Setup:\n1. **Add books** to \"val Book Lookup\" → Enter either:\n - **Title + Author** (traditional method), OR\n - **Just ISBN** (new method!)\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### Two Ways to Add Books:\n\n**Method 1: Title + Author** (your existing workflow)\n- Add Title and Author to a new record\n- Script finds ISBN, year, page count, publisher, etc.\n\n**Method 2: ISBN Only** (new capability!)\n- Add just the ISBN to a new record\n- Script finds Title, Author, year, page count, publisher, etc.\n- Perfect for when you have a book in hand but don't want to type the details\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",[153],"3aa4c35e-3acd-11f0-a81c-9e149126039e",["D",1748331357498],[28],"4acbe1d2-3acc-11f0-96de-9e149126039e","frontend","00d91712-92af-4962-9d8b-e5d66351f408",["D",1748330955065],[166],"4acbd9b2-3acc-11f0-96de-9e149126039e","backend","a81f9b10-9c08-417e-af75-49139ef976df",["D",1748330955065],[171],"pulls","branches","forks","envVars",{"_182":69,"_184":69},"connections",{"_182":69,"_183":69},"count","unfilledCount","emptyCount",{"_48":170,"_32":171,"_30":172,"_155":-5,"_39":40,"_38":156,"_157":65,"_36":245,"_13":69,"_33":34,"_35":-5,"_24":25,"_160":-5,"_196":246,"_27":247},{"_48":238,"_32":239,"_30":240,"_155":172,"_39":40,"_38":156,"_157":65,"_36":241,"_13":69,"_33":45,"_35":242,"_24":25,"_160":-5,"_196":243,"_27":244},{"_48":231,"_32":232,"_30":63,"_155":172,"_39":40,"_38":156,"_157":25,"_36":233,"_13":69,"_33":234,"_35":235,"_24":25,"_160":-5,"_196":236,"_27":237},{"_48":224,"_32":225,"_30":226,"_155":172,"_39":40,"_38":156,"_157":65,"_36":227,"_13":69,"_33":45,"_35":228,"_24":25,"_160":-5,"_196":229,"_27":230},{"_48":217,"_32":218,"_30":219,"_155":172,"_39":40,"_38":156,"_157":65,"_36":220,"_13":69,"_33":45,"_35":221,"_24":25,"_160":-5,"_196":222,"_27":223},{"_48":165,"_32":166,"_30":167,"_155":-5,"_39":40,"_38":156,"_157":65,"_36":214,"_13":69,"_33":34,"_35":-5,"_24":25,"_160":-5,"_196":215,"_27":216},{"_48":206,"_32":207,"_30":208,"_155":167,"_39":40,"_38":209,"_157":25,"_36":210,"_13":156,"_33":21,"_35":211,"_24":25,"_160":-5,"_196":212,"_27":213},{"_48":162,"_32":28,"_30":31,"_155":-5,"_39":40,"_38":14,"_157":65,"_36":203,"_13":69,"_33":34,"_35":-5,"_24":25,"_160":-5,"_196":204,"_27":205},{"_48":199,"_32":44,"_30":43,"_155":31,"_39":40,"_38":14,"_157":65,"_36":200,"_13":69,"_33":45,"_35":46,"_24":25,"_160":-5,"_196":201,"_27":202},{"_48":152,"_32":153,"_30":154,"_155":-5,"_39":40,"_38":156,"_157":25,"_36":195,"_13":69,"_33":21,"_35":159,"_24":25,"_160":-5,"_196":197,"_27":198},["D",1748330955065],"children",[],[153],"3aa4bb5c-3acd-11f0-a81c-9e149126039e",["D",1748331357498],[],[28,44],["D",1748331357498],[193],[28],"342a2b22-3acd-11f0-8375-9e149126039e","index.html","272c942a-fa9d-46bc-b374-c25fad14e7c5",2,["D",1748331346631],"\n\n\n \n \n Book Lookup Tool\n \n \n \n\n\n

\n \n

📚 Book Lookup Tool

Search by Title/Author or ISBN to get comprehensive book information

\n\n \n

\n \n

Search by Title & Author

\n Book Title\n \n

\n Author\n \n

\n \n

\n\n \n

Search by ISBN

\n ISBN\n \n

Enter ISBN with or without hyphens

Example: 9780123456789 or 978-0-123-45678-9

\n \n

\n\n \n

Bulk Input

\n \n Paste data from spreadsheet (Title, Author, ISBN - one per line)\n \n \n

• Separate columns with tabs (copy from Excel/Sheets)

• Leave Title/Author empty if you only have ISBN

• Leave ISBN empty if you only have Title/Author

\n \n

\n\n \n

Searching for book information...

\n\n \n

\n \n

Results (0 books)

\n \n \n \n

\n\n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Title	Author	ISBN	Year	Publisher	Pages	Summary

\n\n \n

⚠️

Error

\n\n \n\n",[],[166,207],["D",1748330955065],[191],[166],"4acbd246-3acc-11f0-96de-9e149126039e","processor.ts","e9c20ba9-005c-440b-83ea-4fa58408031b",["D",1748330955065],"/**\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 // Determine search strategy based on available data\n const hasTitle = record.title && record.title.trim();\n const hasAuthor = record.author && record.author.trim();\n const hasISBN = record.isbn && record.isbn.trim();\n\n if (!hasTitle && !hasAuthor && !hasISBN) {\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, author, and ISBN - need at least one'\n });\n continue;\n }\n\n try {\n let metadata: BookMetadata | null = null;\n\n // Strategy 1: If we have title and author, search by those\n if (hasTitle && hasAuthor) {\n console.log(`Processing: \"${record.title}\" by \"${record.author}\"`);\n \n // Try exact search first\n 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 // Strategy 2: If we have ISBN but missing title/author, search by ISBN\n else if (hasISBN && (!hasTitle || !hasAuthor)) {\n console.log(`Processing by ISBN: ${record.isbn} (missing title/author)`);\n metadata = await searchBookMetadataByISBN(record.isbn);\n }\n // Strategy 3: If we only have ISBN and already have title/author, still try ISBN search for missing metadata\n else if (hasISBN) {\n console.log(`Processing by ISBN: ${record.isbn} for additional metadata`);\n metadata = await searchBookMetadataByISBN(record.isbn);\n }\n\n if (!metadata) {\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\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 // Update title if missing and found\n if (!record.title && metadata.title) {\n updateMetadata.title = metadata.title;\n }\n \n // Update author if missing and found\n if (!record.author && metadata.author) {\n updateMetadata.author = metadata.author;\n }\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 // Include additional metadata for the update function to handle\n // (it will try to update these separately and skip if properties don't exist)\n if (metadata.subtitle) {\n updateMetadata.subtitle = metadata.subtitle;\n }\n \n if (metadata.description) {\n updateMetadata.description = metadata.description;\n }\n \n if (metadata.categories) {\n updateMetadata.categories = metadata.categories;\n }\n \n if (metadata.averageRating) {\n updateMetadata.averageRating = metadata.averageRating;\n }\n \n if (metadata.ratingsCount) {\n updateMetadata.ratingsCount = metadata.ratingsCount;\n }\n \n if (metadata.language) {\n updateMetadata.language = metadata.language;\n }\n \n if (metadata.publishedDate) {\n updateMetadata.publishedDate = metadata.publishedDate;\n }\n \n if (metadata.previewLink) {\n updateMetadata.previewLink = metadata.previewLink;\n }\n \n if (metadata.infoLink) {\n updateMetadata.infoLink = metadata.infoLink;\n }\n \n if (metadata.imageLinks) {\n updateMetadata.imageLinks = metadata.imageLinks;\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 || metadata.title || 'Unknown'}\"`);\n \n result.successful++;\n result.details.push({\n id: record.id,\n title: record.title || metadata.title || 'Unknown',\n author: record.author || metadata.author || 'Unknown',\n status: 'success',\n metadata: updateMetadata\n });\n } else {\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: '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 || record.isbn || 'Unknown'}\":`, error);\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\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}",[],[171,218],"4acbabcc-3acc-11f0-96de-9e149126039e","notion.ts","8403850d-e3b7-4180-8437-5fc2759e2ffc",["D",1748330955065],"/**\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 ISBN\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 property: 'ISBN',\n rich_text: {\n is_empty: true\n }\n }\n ]\n },\n // Records with Title + Author but missing Year Published\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 property: 'Year Published',\n number: {\n is_empty: true\n }\n }\n ]\n },\n // Records with Title + Author but missing Page Count\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 property: 'Page Count',\n number: {\n is_empty: true\n }\n }\n ]\n },\n // Records with Title + Author but missing Publisher\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 property: 'Publisher',\n rich_text: {\n is_empty: true\n }\n }\n ]\n },\n // Records with ISBN but missing Title\n {\n and: [\n {\n property: 'ISBN',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Title',\n title: {\n is_empty: true\n }\n }\n ]\n },\n // Records with ISBN but missing Author\n {\n and: [\n {\n property: 'ISBN',\n rich_text: {\n is_not_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 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 // We'll try to update these separately to avoid failing the core update\n const additionalProperties: any = {};\n \n if (metadata.subtitle) {\n additionalProperties.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 additionalProperties.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 additionalProperties.Categories = {\n multi_select: metadata.categories.slice(0, 10).map(cat => ({ name: cat }))\n };\n }\n\n if (metadata.averageRating) {\n additionalProperties['Average Rating'] = {\n number: metadata.averageRating\n };\n }\n\n if (metadata.ratingsCount) {\n additionalProperties['Ratings Count'] = {\n number: metadata.ratingsCount\n };\n }\n\n if (metadata.language) {\n additionalProperties.Language = {\n rich_text: [\n {\n text: {\n content: metadata.language\n }\n }\n ]\n };\n }\n\n if (metadata.publishedDate) {\n additionalProperties['Published Date'] = {\n rich_text: [\n {\n text: {\n content: metadata.publishedDate\n }\n }\n ]\n };\n }\n\n if (metadata.previewLink) {\n additionalProperties['Preview Link'] = {\n url: metadata.previewLink\n };\n }\n\n if (metadata.infoLink) {\n additionalProperties['Info Link'] = {\n url: metadata.infoLink\n };\n }\n\n if (metadata.imageLinks) {\n additionalProperties['Image Links'] = {\n rich_text: [\n {\n text: {\n content: JSON.stringify(metadata.imageLinks)\n }\n }\n ]\n };\n }\n\n // First, update core properties only\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\n // Then try to update additional properties one by one\n // This way if some properties don't exist, others can still be updated\n for (const [propName, propValue] of Object.entries(additionalProperties)) {\n try {\n const additionalResponse = 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 [propName]: propValue\n }\n })\n });\n \n if (!additionalResponse.ok) {\n console.log(`Property \"${propName}\" doesn't exist in database, skipping...`);\n }\n } catch (error) {\n console.log(`Failed to update property \"${propName}\", skipping...`);\n }\n }\n}",[],[171,225],"4acba3f2-3acc-11f0-96de-9e149126039e","index.ts",["D",1748330955065],"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;",[],[171,232],"4acb76ac-3acc-11f0-96de-9e149126039e","books.ts","532f33ce-2447-46e5-a112-05f2c4cb4e8e",["D",1748330955065],"/**\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}",[],[171,239],["D",1748330955065],[186,187,188,189],[171],["D",1748330955065],{"_106":105,"_113":109},{"_106":105,"_107":-5,"_108":109,"_18":61,"_110":111,"_112":25},{"_13":92,"_32":93,"_48":40,"_94":49,"_95":96,"_97":98,"_99":55,"_100":101,"_102":71,"_103":50,"_104":105},"ctx",{"_85":-5,"_135":285,"_286":287,"_288":289,"_290":25,"_291":25,"_292":25,"_293":65,"_294":-5,"_295":-7,"_296":-7,"_297":69,"_298":25,"_299":25,"_300":-5,"_301":25,"_302":25,"_303":25,"_304":-5},"ENV",{"_256":257,"_258":259,"_260":93,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v3