Marketplace - Web scraping supplier pricing data into NetSuite
This recipe is a comprehensive Boomi process designed to automate vendor purchase price updates in NetSuite from supplier pricing data. The process reads a supplier registry JSON (supporting both html_table and json_api parser types), retrieves each supplier's raw response (currently MOCK fixtures, swappable with per-supplier REST GET connectors for live scraping), parses out SKU/price/product name, resolves the SKU to a NetSuite item internal ID via SuiteQL, resolves the vendor name to its internal ID via SuiteQL, validates the vendor-item relationship, and then PATCHes the item record's purchase cost for the matching vendor.
Solution Details
- Difficulty Level
- INTERMEDIATE
- Solution Type
- Recipe
- Author
- Boomi
- Published on
- Jun 24, 2026
- Last updated on
- Jun 24, 2026
Get Started
Get StartedKey Features
- Automate ingestion of supplier pricing data and propagate updates to NetSuite without manual entry.
- Validate SKUs, vendors, and vendor-item relationships before each write, blocking bad data from ERP.
- Apply standardized OAuth 1.0 TBA HMAC-SHA256 signing for NetSuite SuiteQL and REST Record API calls.
Applications Required
- NetSuite