[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_226":227,"_228":229},"routes/_app.x.$handle.$name",{"_96":95,"_32":44,"_104":86,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":59,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",81,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","README.md","latestPath","fileId","58f49894-375c-11f0-a0b7-9e149126039e","name","fileType","content","# 📚 Notion Book Database Auto-Populator\n\n**Automatically enrich your Notion book database with metadata from Google Books API!**\n\nThis tool can pull metadata about books into a Notion database.\n\nFill out those empty fields in your reading databasen with one click and a simple query to the Google API.\n\nConvert that note on your phone into ISBNs to upload onto StoryGraph, LibraryThing or Goodreads. \n\n## 🚀 Quick Start\n\n### Step 1: Create Your Notion Database\n\nCreate a new Notion database with these **required columns**:\n\n| Column Name | Type | Description |\n|-------------|------|-------------|\n| **Title** | Title | The book's title |\n| **Author** | Rich Text | The book's author |\n| **ISBN** | Rich Text | Book's ISBN (auto-filled) |\n| **Year Published** | Number | Publication year (auto-filled) |\n| **Page Count** | Number | Number of pages (auto-filled) |\n| **Publisher** | Rich Text | Publisher name (auto-filled) |\n\n**Optional columns** you can add for even more data:\n- **Description** (Rich Text) - Book summary\n- **Categories** (Multi-select) - Genres/subjects \n- **Average Rating** (Number) - Google Books rating\n- **Ratings Count** (Number) - Number of ratings\n- **Language** (Rich Text) - Book language\n- **Subtitle** (Rich Text) - Book subtitle\n\n### Step 2: Set Up Notion Integration\n\n1. **Create a Notion Integration:**\n - Go to [https://www.notion.so/my-integrations](https://www.notion.so/my-integrations)\n - Click \"New integration\"\n - Give it a name like \"Book Auto-Populator\"\n - Copy the **Integration Token** (starts with `secret_`)\n\n2. **Share Your Database:**\n - Open your book database in Notion\n - Click the \"...\" menu → \"Add connections\"\n - Select your integration\n\n3. **Get Your Database ID:**\n - Copy the URL of your database page\n - Extract the database ID (the long string of letters/numbers after the last `/` and before any `?`)\n - Example: `https://notion.so/myworkspace/a8aec43384f447ed84390e8e42c2e089?v=...`\n - Database ID: `a8aec43384f447ed84390e8e42c2e089`\n\n### Step 3: Configure This Val\n\n1. **Fork this Val** to your account\n2. **Set Environment Variables:**\n - `NOTION_API_TOKEN` = Your integration token from Step 2\n - `NOTION_DATABASE_ID` = Your database ID from Step 2\n\n### Step 4: Test It!\n\n1. **Add a test book** to your Notion database:\n - Enter just the **Title** and **Author** (like \"The Great Gatsby\" and \"F. Scott Fitzgerald\")\n - OR just enter an **ISBN** (like \"9780743273565\")\n\n2. **Run the enrichment:**\n - Visit your Val URL: `https://your-val-name.web.val.run/`\n - Watch as the missing fields get automatically filled in!\n\n## 📖 How to Use\n\n### Adding Books (Two Methods)\n\n**Method 1: Title + Author**\n- Add the book title and author to a new row\n- The script will find and fill in ISBN, year, page count, publisher, etc.\n\n**Method 2: ISBN Only** \n- Add just the ISBN to a new row\n- The script will find and fill in title, author, year, page count, publisher, etc.\n- Perfect when you have a book in hand but don't want to type details!\n\n### Running the Enrichment\n\n**Process all incomplete books:**\n```\nGET https://your-val-name.web.val.run/\n```\n\n**Check if everything is set up correctly:**\n```\nGET https://your-val-name.web.val.run/status\n```\n\n**Process just one specific book:**\n```\nGET https://your-val-name.web.val.run/process/NOTION_RECORD_ID\n```\n\n**See all available commands:**\n```\nGET https://your-val-name.web.val.run/help\n```\n\n## 🔗 Linking to Your Main Reading Database\n\nWant to connect this lookup database to your main reading tracker? Here's how:\n\n1. **In your main reading database**, add a new property:\n - **Name:** \"Book Info\"\n - **Type:** Relation \n - **Related database:** Your book lookup database\n\n2. **Add rollup properties** to display the 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 reading list, just link it to the enriched record!\n\n## ✨ What Gets Auto-Filled\n\nThis tool pulls metadata from Google Books API:\n\n**Always Filled:**\n- ✅ ISBN (prefers ISBN-13, falls back to ISBN-10)\n- ✅ Publication Year\n- ✅ Page Count \n- ✅ Publisher\n\n**Often Available:**\n- 📝 Description/Summary\n- 🏷️ Categories/Genres\n- ⭐ Average Rating\n- 📊 Number of Ratings\n- 🌍 Language\n- 📅 Full Publication Date\n- 🔗 Google Books Preview Link\n\n**WARNING! Check the data! Google Books is not the authorative source on publisher data, but more authorative sources charge money to use their API.** \n\nIronically, manually Googling every book has a higher certainty rate, but it's very time consuming and probably the reason why you're here.\n\n*Protip: if you want more data, pull your ISBNs, then upload them to LibraryThing.com*\n\n## 🛠️ Troubleshooting\n\n**\"System not properly configured\" error:**\n- Check that both environment variables are set correctly\n- Verify your Notion integration has access to the database\n\n**No books getting processed:**\n- Make sure you have books with Title+Author OR ISBN but missing other fields\n- Check that your database column names match exactly (case-sensitive)\n\n**Books not found:**\n- Try adding more specific author information\n- Some books may not be in Google Books database\n- Check that Title and Author are spelled correctly\n\n## 🔧 Advanced Usage\n\n**Manual Processing:** The system only processes books when you visit the URL - no automatic background processing, but you could probably set that up if you wanted.\n\n**Smart Matching:** Uses both exact and relaxed search algorithms to find the best matches, which sometimes gives false results\n\n**Data Preservation:** Only fills in empty fields - never overwrites your existing data\n\n**Expandable:** Add any of the optional columns to capture even more book metadata\n\n## 📁 Project Structure\n\n- `backend/index.ts` - Main HTTP endpoints and API\n- `backend/notion.ts` - Notion database integration \n- `backend/books.ts` - Google Books API integration\n- `backend/processor.ts` - Core processing logic\n\n---\n\n**Fork this Val and fill in your book database! 📚✨**","# 📚 Notion Book Database Auto-Populator\n\n**Automatically enrich your Notion book database with comprehensive metadata from Google Books API!**\n\nSimply add a book title + author (or just an ISBN) to your Notion database, click a button, and watch as all the missing details get filled in automatically - including ISBN, publication year, page count, publisher, description, ratings, and more.\n\n## 🚀 Quick Start\n\n### Step 1: Create Your Notion Database\n\nCreate a new Notion database with these **required columns**:\n\n| Column Name | Type | Description |\n|-------------|------|-------------|\n| **Title** | Title | The book's title |\n| **Author** | Rich Text | The book's author |\n| **ISBN** | Rich Text | Book's ISBN (auto-filled) |\n| **Year Published** | Number | Publication year (auto-filled) |\n| **Page Count** | Number | Number of pages (auto-filled) |\n| **Publisher** | Rich Text | Publisher name (auto-filled) |\n\n**Optional columns** you can add for even more data:\n- **Description** (Rich Text) - Book summary\n- **Categories** (Multi-select) - Genres/subjects \n- **Average Rating** (Number) - Google Books rating\n- **Ratings Count** (Number) - Number of ratings\n- **Language** (Rich Text) - Book language\n- **Subtitle** (Rich Text) - Book subtitle\n\n### Step 2: Set Up Notion Integration\n\n1. **Create a Notion Integration:**\n - Go to [https://www.notion.so/my-integrations](https://www.notion.so/my-integrations)\n - Click \"New integration\"\n - Give it a name like \"Book Auto-Populator\"\n - Copy the **Integration Token** (starts with `secret_`)\n\n2. **Share Your Database:**\n - Open your book database in Notion\n - Click the \"...\" menu → \"Add connections\"\n - Select your integration\n\n3. **Get Your Database ID:**\n - Copy the URL of your database page\n - Extract the database ID (the long string of letters/numbers after the last `/` and before any `?`)\n - Example: `https://notion.so/myworkspace/a8aec43384f447ed84390e8e42c2e089?v=...`\n - Database ID: `a8aec43384f447ed84390e8e42c2e089`\n\n### Step 3: Configure This Val\n\n1. **Fork this Val** to your account\n2. **Set Environment Variables:**\n - `NOTION_API_TOKEN` = Your integration token from Step 2\n - `NOTION_DATABASE_ID` = Your database ID from Step 2\n\n### Step 4: Test It!\n\n1. **Add a test book** to your Notion database:\n - Enter just the **Title** and **Author** (like \"The Great Gatsby\" and \"F. Scott Fitzgerald\")\n - OR just enter an **ISBN** (like \"9780743273565\")\n\n2. **Run the enrichment:**\n - Visit your Val URL: `https://your-val-name.web.val.run/`\n - Watch as the missing fields get automatically filled in!\n\n## 📖 How to Use\n\n### Adding Books (Two Methods)\n\n**Method 1: Title + Author**\n- Add the book title and author to a new row\n- The script will find and fill in ISBN, year, page count, publisher, etc.\n\n**Method 2: ISBN Only** \n- Add just the ISBN to a new row\n- The script will find and fill in title, author, year, page count, publisher, etc.\n- Perfect when you have a book in hand but don't want to type details!\n\n### Running the Enrichment\n\n**Process all incomplete books:**\n```\nGET https://your-val-name.web.val.run/\n```\n\n**Check if everything is set up correctly:**\n```\nGET https://your-val-name.web.val.run/status\n```\n\n**Process just one specific book:**\n```\nGET https://your-val-name.web.val.run/process/NOTION_RECORD_ID\n```\n\n**See all available commands:**\n```\nGET https://your-val-name.web.val.run/help\n```\n\n## 🔗 Linking to Your Main Reading Database\n\nWant to connect this lookup database to your main reading tracker? Here's how:\n\n1. **In your main reading database**, add a new property:\n - **Name:** \"Book Info\"\n - **Type:** Relation \n - **Related database:** Your book lookup database\n\n2. **Add rollup properties** to display the 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 reading list, just link it to the enriched record!\n\n## ✨ What Gets Auto-Filled\n\nThis tool pulls comprehensive metadata from Google Books API:\n\n**Always Filled:**\n- ✅ ISBN (prefers ISBN-13, falls back to ISBN-10)\n- ✅ Publication Year\n- ✅ Page Count \n- ✅ Publisher\n\n**Often Available:**\n- 📝 Description/Summary\n- 🏷️ Categories/Genres\n- ⭐ Average Rating\n- 📊 Number of Ratings\n- 🌍 Language\n- 📅 Full Publication Date\n- 🔗 Google Books Preview Link\n\n## 🛠️ Troubleshooting\n\n**\"System not properly configured\" error:**\n- Check that both environment variables are set correctly\n- Verify your Notion integration has access to the database\n\n**No books getting processed:**\n- Make sure you have books with Title+Author OR ISBN but missing other fields\n- Check that your database column names match exactly (case-sensitive)\n\n**Books not found:**\n- Try adding more specific author information\n- Some books may not be in Google Books database\n- Check that Title and Author are spelled correctly\n\n## 🔧 Advanced Usage\n\n**Manual Processing:** The system only processes books when you visit the URL - no automatic background processing\n\n**Smart Matching:** Uses both exact and relaxed search algorithms to find the best matches\n\n**Data Preservation:** Only fills in empty fields - never overwrites your existing data\n\n**Expandable:** Add any of the optional columns to capture even more book metadata\n\n## 📁 Project Structure\n\n- `backend/index.ts` - Main HTTP endpoints and API\n- `backend/notion.ts` - Notion database integration \n- `backend/books.ts` - Google Books API integration\n- `backend/processor.ts` - Core processing logic\n\n---\n\n**Ready to automatically enrich your book collection? Fork this Val and start building your ultimate book database! 📚✨**","createdAt",["D",1748332408384],"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=1789617172&sig=68b72ca5857a64a636b0431e98223920f2ef7989e18d65be0b8eddf77a0338ff","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",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":14,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nucky","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4VHNLcXVkc2Yxc3RjbzRvSloxRW5OQ1FYRCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":222,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":223,"_81":224,"_83":225,"_85":25},"tree",[160,165,167],"files",[160,161,162,163,164,165,166,167],"counts",{"_150":141,"_151":63,"_152":63,"_153":154,"_155":156},"contents",[126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":144,"_32":145,"_30":146,"_130":-5,"_40":41,"_39":147,"_131":59,"_37":148,"_13":141,"_33":142,"_34":-5,"_24":25,"_134":-5,"_27":149},{"_42":136,"_32":137,"_30":138,"_130":-5,"_40":41,"_39":139,"_131":59,"_37":140,"_13":141,"_33":142,"_34":-5,"_24":25,"_134":-5,"_27":143},{"_42":129,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_131":59,"_37":132,"_13":133,"_33":20,"_34":36,"_24":25,"_134":-5,"_27":135},"ad07fb6c-3acf-11f0-9cf6-9e149126039e","parentId","latest",["D",1748332408384],15,"label",[28],"0a0a4222-3a6f-11f0-a9ba-9e149126039e","frontend","5035dc7b-6305-4991-bda1-c1e2c1abd76f",78,["D",1748290903261],0,"directory",[137],"62ee15c8-375c-11f0-8c16-9e149126039e","backend","ba931684-cf88-4b01-bc83-bc2015e23f85",2,["D",1747953038469],[145],"pulls","branches","forks","envVars",{"_157":147,"_159":141},"connections",{"_157":141,"_158":141},"count","unfilledCount","emptyCount",{"_42":144,"_32":145,"_30":146,"_130":-5,"_40":41,"_39":147,"_131":59,"_37":219,"_13":141,"_33":142,"_34":-5,"_24":25,"_134":-5,"_169":220,"_27":221},{"_42":210,"_32":211,"_30":212,"_130":146,"_40":41,"_39":213,"_131":59,"_37":214,"_13":215,"_33":188,"_34":216,"_24":25,"_134":-5,"_169":217,"_27":218},{"_42":201,"_32":202,"_30":57,"_130":146,"_40":41,"_39":203,"_131":59,"_37":204,"_13":205,"_33":206,"_34":207,"_24":25,"_134":-5,"_169":208,"_27":209},{"_42":192,"_32":193,"_30":194,"_130":146,"_40":41,"_39":195,"_131":59,"_37":196,"_13":197,"_33":188,"_34":198,"_24":25,"_134":-5,"_169":199,"_27":200},{"_42":182,"_32":183,"_30":184,"_130":146,"_40":41,"_39":185,"_131":59,"_37":186,"_13":187,"_33":188,"_34":189,"_24":25,"_134":-5,"_169":190,"_27":191},{"_42":136,"_32":137,"_30":138,"_130":-5,"_40":41,"_39":139,"_131":59,"_37":179,"_13":141,"_33":142,"_34":-5,"_24":25,"_134":-5,"_169":180,"_27":181},{"_42":172,"_32":173,"_30":174,"_130":138,"_40":41,"_39":139,"_131":59,"_37":175,"_13":141,"_33":20,"_34":176,"_24":25,"_134":-5,"_169":177,"_27":178},{"_42":129,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_131":59,"_37":168,"_13":133,"_33":20,"_34":36,"_24":25,"_134":-5,"_169":170,"_27":171},["D",1748332408384],"children",[],[28],"0a0a1824-3a6f-11f0-a9ba-9e149126039e","index.html","0a0a18e2-3a6f-11f0-a9ba-9e149126039e",["D",1748290903261],"\n\n\n \n \n Book Metadata Lookup Tool\n \n \n \n\n\n

Book Metadata Lookup Tool

\n Paste your book data into the table below. You can include Author/Title or ISBNs, then click \"Process Records\" to fetch metadata from Google Books API.\n

\n \n \n

How to use:

• Paste from spreadsheet: Copy cells from Excel/Google Sheets and paste directly into the table
• Manual entry: Click any cell to edit directly
• Add rows: Use the \"Add Row\" button to create more entries
• Two lookup methods: Provide either (Author + Title) OR just ISBN for each book

\n \n \n

\n \n \n \n

\n Processing...\n

\n \n \n

Processing Results:

\n \n \n

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

Author	Title	ISBN	Year	Pages	Publisher	Description	Status

\n \n \n

\n\n \n\n",[],[137,173],["D",1748290903261],[166],[137],"0b2d3cc4-3775-11f0-bb35-9e149126039e","processor.ts","7ba8aaa6-375c-11f0-9948-9e149126039e",77,["D",1747963628664],3,"script","/**\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}",[],[145,183],"01cf3a92-3775-11f0-9e89-9e149126039e","notion.ts","62edf002-375c-11f0-8c16-9e149126039e",76,["D",1747963612945],34,"/**\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}",[],[145,193],"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;",[],[145,202],"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}",[],[145,211],["D",1747953038469],[161,162,163,164],[145],["D",1747952823274],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":14,"_32":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_79":-5,"_123":259,"_260":261,"_262":263,"_264":25,"_265":25,"_266":25,"_267":59,"_268":-5,"_269":-7,"_270":-7,"_271":141,"_272":25,"_273":25,"_274":-5,"_275":25,"_276":25,"_277":25,"_278":-5},"ENV",{"_230":231,"_232":233,"_234":86,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258},"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 · v81