NetSuite Extension

Connect an Oracle NetSuite account by saving its account id plus TBA credentials (consumer key/secret from an Integration record, token key/secret from an Access Token), after verifying them live against the SuiteTalk REST metadata catalog.

List the connected NetSuite accounts - label, account id, masked consumer key. Secret values are never shown.

Disconnect a NetSuite account: deletes the saved TBA credentials from Imperal. Nothing in NetSuite itself is changed; the Access Token can be revoked in NetSuite at any time.

List NetSuite records of any record type (customer, salesorder, invoice, item, vendor, ...) with limit/offset pagination, via SuiteTalk record/v1.

Read one NetSuite record of any type in full by its internal id (e.g. customer 1042).

Read a NetSuite record type's field schema from the REST metadata catalog -- which fields exist, their types, and which are required. Use before create_record/update_record.

Create a new NetSuite record of any type from a JSON object of its fields (use get_record_schema first to see valid fields), e.g. a new customer or sales order.

Update selected fields of an existing NetSuite record (PATCH). Only the fields in fields_json change.

Permanently delete a NetSuite record of any type by internal id. Cannot be undone through the API.

Run a SuiteQL SELECT query against NetSuite (query/v1/suiteql) -- the most powerful read path: joins, filters, aggregates. Read-only; writes go through create_record/update_record. Limit 1-1000 rows.

Value-add report: one-glance NetSuite account snapshot -- record counts for customers, vendors, sales orders, invoices and items, plus credential liveness, in a single call.

Value-add report: sales orders not yet fully billed or closed -- id, date, entity, amount, status -- so fulfillment/billing follow-up is one call away.