Ben Richards

Orca API JS/Node

CSV-driven partner workflows for availability, appointments, and order placement with deterministic audit outputs.

  • OwnerRole
  • 2025 – PresentYear

Context

Bulk telecom order handling across partners. The goal: replace manual Postman flows with a reliable, auditable tool that reduces handling time and errors.

My Contribution

Design

  • Flow templates for Availability → Get/Reserve Appointment → Place Order.
  • Automatic Token refreshing.

Build

  • Node modules for v2/v3 endpoints with retries and error capture.
  • CSV ingestion + output columns for orders refs and status.

Operate

  • Interactive CSV Table, progress UI, and logs for audit.

Highlights

Impact

Cut per-order handling minutes by consolidating steps and auto-filling partner data.

Reliability

Deterministic outputs and consistent column writes for downstream reporting.

Speed

Batch processing with stop/resume and error rows isolated for re-run.

Tech Stack

  • Frontend: HTML/CSS, vanilla JS
  • Backend: Node.js, fetch, CSV parsing
  • Infra: Local hosted
  • Data/BI: Exports → Excel/Power BI

Gallery

CSV Builder Admin Status Page Processing Dashboard