Feishu Book Match

Fill 匹配结果 (match color) and 书籍链接 (Amazon detail link) for books in a Feishu Bitable by querying Amazon UK/US with ISBN.

Step-by-Step Workflow

1. Parse the Bitable URL

Use feishu_bitable_get_meta on the Feishu wiki/base URL to get app_token and table_id.

2. Confirm Field IDs

Use feishu_bitable_list_fields to find the field IDs. Expected field names:

• - ISBN → fieldid (e.g. fldbjxXubv)
• INLINECODE6 → fieldid (e.g. fld8AkZOXn)
• INLINECODE8 → fieldid (e.g. fldEVOXS5u)
• INLINECODE10 → fieldid (e.g. fldrgtxF6l)
• INLINECODE12 → field_id (e.g. fldxZrhJeG)

3. Find Unprocessed Records

Use feishu_bitable_list_records with page_size=100. Filter to records where 匹配结果 is empty. Process in batches.

4. Query Amazon (Browser Relay)

Use Chrome browser relay (profile: "chrome-relay"):

Step A: Amazon UK search
URL: INLINECODE18

Step B: Check results

• - If page shows "No results for your search query in Books" → try Amazon US:

• - If Amazon US also shows no results → mark 匹配结果 = 🔴 未匹配 → update Bitable → stop for this ISBN

Step C: Get first result info
Take the first search result (usually div[data-cy="title-recipe"]). Extract:

• - Title: from the heading inside div[data-cy="title-recipe"] or INLINECODE23
• Author: from the author line (often contains by text or a link)

5. Determine Match Color

Compare Amazon result with Excel Title and Author:

• - 🟢 完全一致 (green): Title AND Author both match exactly
• 🟡 可能一致 (yellow): Title matches, Author similar or slightly different
• 🔴 很可能不同 (red): Title or Author clearly different

Common causes of yellow:

• - Amazon shows audiobook narrator alongside author (e.g., "Ian Rankin and James Macpherson" where Macpherson is the narrator)
• Slight title variations (subtitle differences, punctuation)
• Author name formatting differences

6. Get Detail Link

Execute in the browser tab:
CODEBLOCK0

Strip query parameters — keep only the clean path:
CODEBLOCK1

7. Update Bitable Record

Use feishu_bitable_update_record:
CODEBLOCK2

Known Field IDs (RIVERSIDE_BOOKS Table)

These are stable for the specific table tblskx3DEQkwhc9r. Always verify with feishu_bitable_list_fields if unsure.

Batch Processing

For large tables (2000+ records):

1. 1. Process in batches of 20–50
2. Use feishu_bitable_list_records with page_token for pagination
3. Filter out already-processed records (匹配结果 not empty)
4. Report progress after each batch
5. Use background exec or cron if the task needs to run unattended

Tips

• - ISBN normalization: Some ISBNs have dashes; Amazon search works better with dashes removed (e.g., 978-0857834768 → 9780857834768)
• CD/audiobook: Category 1 = "CD" often indicates audiobook — author on Amazon may differ (narrator vs author)
• No results on .co.uk: Always fall back to .com before marking as unmatched
• Chrome relay tab reuse: If a tab is already on the right URL, navigate to the new ISBN URL directly rather than opening a new tab