Tool

NetSuite Schema Publisher

Publishes NetSuite table, column and join schema to the File Cabinet, powering schema browsing in our SuiteQL tools.

NetSuite Schema Publisher interface showing File Cabinet settings and a table selection list
Select the NetSuite tables whose schema should be published to the File Cabinet.

The schema browser, autocompletion and semantic highlighting in SuiteQL for VS Code and the SuiteQL Query Editor all need real table and column data to work from. NetSuite’s REST Record Metadata Catalog has no entry at all for SuiteQL-only generic tables like transaction, transactionline or transactionaccountingline — they aren’t REST-addressable record resources, so schema for them can only come from NetSuite’s own internal Records Catalog. This project bridges that gap.

How it works

A maintainer opens a Suitelet page in their own logged-in NetSuite browser tab. It gathers table, column, type and join data directly from NetSuite’s internal Records Catalog and saves it to the File Cabinet as one JSON file per table.

SuiteQL Schema Publisher’s table picker, showing the File Cabinet folder info and the checkbox list of tables to publish

A companion RESTlet then serves that saved schema to any token-authenticated consumer — the mechanism both SuiteQL for VS Code and the SuiteQL Query Editor use to build their schema browser, autocomplete and semantic highlighting.

Status

This project is in beta, deployed as a companion piece alongside our SuiteQL tools rather than used on its own. It’s provided under licence as part of that setup, not a free download. Get in touch if you’d like schema-aware tooling set up in your NetSuite account.

Ask about this tool

Let’s talk

Need something similar built for your systems?

Share the systems involved, where the data needs to land and what is getting in the way. We’ll help you work out the next step.

Talk to Source Connectors