Cadran

Data Tools

GO
Cadran internal suite

Work faster with data. One sleek toolkit.

High-performance utilities for querying, transforming, and exporting data—built for teams that live in NetSuite and spreadsheets.

Secure by default Fast on large sets
What’s inside
  • SuiteQL Console
  • CSV/XLSX Splitter
  • Lookups (A ← B ← C)
  • Query Builder
  • REST Client
  • Keyset Exporter

SuiteQL Console

Auth

Environment switching, secure server-side credentials, syntax highlighting, formatter, and fast rendering for large results.

  • Learns NetSuite database per Env.
  • One-click format (Shift+Alt+F)
  • Syntax highlighting

CSV/XLSX Splitter

Files

Split huge files into clean chunks by size or rows. Auto-detects delimiters and encodings; preserves headers.

  • Row or MB targets
  • Consistent schema
  • ZIP outputs

Lookups

Join

Enrich File A with columns from File B (and optional File C). Case/space normalization, dedupe, and unmatched exports.

  • Case-insensitive
  • Ignore spaces & dashes
  • Semi-join mode

Query Builder

Assist

Compose queries visually, preview column lineage, and send SQL straight to the Console.

  • Tables & joins
  • Editor insertion
  • Learned schema hints

REST Client

API

Call SuiteTalk/RESTlet endpoints with OAuth—headers, query params, and JSON payloads included. Minimal, practical introspection.

  • GET REST - Meta Data
  • JSON bodies
  • GET, PUT, PATCH, amd CustomRecords

Deep Export

Export

Robust paged exports using {LAST_ID} + {LIMIT} templates. Automatically grows the CSV header as new columns appear.

  • Data which saved searches can't' reach
  • Retry on transient errors
  • Timeout & pacing controls

How it works

  1. Configure

    Add your env once. Credentials are stored server-side with restricted permissions.

  2. Compose

    Query with Console or assemble visually in the Builder. Hints improve as you work.

  3. Export

    Export to CSV/XLSX or enrich spreadsheets with safe joins. Zip when needed.

Overview only • No links or endpoints exposed on this page.