Bluesheets · NetSuite ⇄ FileAI
For Bluesheets, a Singapore document-automation fintech, I built the integration layer wiring their AI document-extraction product (FileAI) into customers' NetSuite ERP — turning messy, AI-extracted invoice/PO data into validated, correctly-routed ERP records, plus the platform backend that onboards and secures clients.
Callback Generator Integration Engine · Import Rules · SuiteQL · RESTlet
A callback-driven pipeline that fires whenever FileAI finishes extracting a document, then maps, validates, and syncs that data into NetSuite — and pushes source PDFs back the other way.
- Designed a config-driven Import Rules engine (Prisma-backed) that maps AI-extracted fields to ERP fields as editable database rows and hooks into the callback pipeline — onboarding a new document type needs no code change.
- Built a NetSuite SuiteQL client with configurable column mappings, plus fuzzy field-name matching (purchase-order / delivery-order alias patterns, array-format handling) so unreliable extracted data still lands in the right strict ERP fields.
- Round-tripped documents both ways: download PO PDFs and upload them to FileAI Drive, and wrote SuiteScript to import NetSuite file attachments into FileAI.
- Routed file downloads through a NetSuite RESTlet to bypass standard API permission limits, reaching attachments on custom records the public API couldn't fetch.
- Automated metadata-driven folder / subfolder creation and routing, so each processed document files itself into the right place.
- Hardened the pipeline for reliability: an in-memory dedup cache and multi-
fileIdhandling to stop duplicate processing, plus comprehensive error handling that writes rejection reasons back into NetSuite (custrecord_..._reason_for_rej) so failures are visible inside the customer's ERP.
Platform Backend & Onboarding Auth · Provisioning · Uploads
Core multi-tenant platform services behind the product — automating client provisioning and securing the ingestion surface.
- Automated onboarding: user-onboarding provisioning and API-key creation on login, so new clients spin up without manual steps.
- Built a public API for directory creation with AI-based routing, and fixed workspace-role handling for correct multi-tenant access.
- Hardened file-upload endpoints with mime-type validation to keep the ingestion surface safe.
- Shipped onboarding-frontend features — a PDF workflow and direct Google Drive export without export rules.