PartsTable

Normalize an IT hardware part number into its canonical form. Handles HPE (B21/001/spare), Dell (400-XXXX, DP/N), and IBM/Lenovo (FRU/CCIN) formats. Critical for deduplication and accurate lookups in the TPM market.

Validate a part number against known manufacturer format rules. Returns structural validity, matched format rule, and warnings. IMPORTANT: Format validation only - does not confirm the part exists.

Search for IT hardware parts on eBay using the Browse API. Automatically normalizes the part number before searching. Requires EBAY_CLIENT_ID and EBAY_CLIENT_SECRET environment variables. Returns prices, conditions, sellers, and item URLs.

Find substitute, equivalent, or cross-referenced part numbers. Queries PartsIQ database (34K+ cross-references from IQreseller) with static fallback. Covers HPE option/spare mappings, generation cross-refs, and Dell SKU/DP/N equivalents.

Look up vendor/seller trust information from IQreseller purchase history. Returns trust tier (preferred/neutral/avoid), transaction count, total spend, and satisfaction score. Use '*' as vendor name to get summary statistics. Essential for evaluating eBay sellers before purchasing.

Score and rank eBay listings using PartsTable's 5-factor composite scoring engine. Factors: Price (30%), Vendor Trust (25%), Distance (20%), Condition (15%), Quantity (10%). Vendor trust scores are looked up from IQreseller purchase history (435 vendors). Distance is calculated from warehouse ZIP to

Fetch a web page and return its content as text, Markdown, or HTML. Includes rate limiting (2s per domain, max 10 req/min) for legal compliance. Automatically handles HTML-to-text conversion. Max response size: 1MB. Use for OEM verification and manufacturer website scraping.

Verify a part number against OEM manufacturer websites for maximum confidence (1.0). Checks HPE PartSurfer, Dell Support, and Lenovo Parts Lookup. Returns verification status, OEM data, and confidence boost (+0.2 from DB level). Critical for achieving 100% PN confidence before quoting. Rate-limited

Get purchase price history for a part number. Returns individual transactions with dates, prices, conditions, quantities, and vendor IDs, plus summary statistics (average, min, max, median, trend direction). Trend analysis compares recent vs older purchases (rising/falling/stable). Essential for fai