First-party app
Oracle NetSuite

NetSuite

Oracle NetSuite ERP: create, read, update, upsert and delete any record, transform and act on records, and run SuiteQL queries over the SuiteTalk REST Web Services.

stable Finance & AccountingCustomer Relationship Management

About

NetSuite ships in the w6w first-party pack. It declares 15 actions, 3 health checks, and the host runs its code in a sandbox that never sees the credential.

App id
io.w6w.netsuite
Version
0.1.0
Author
w6w
Licence
MIT
Categories
Finance & Accounting · Customer Relationship Management

Overview

Oracle NetSuite is a cloud ERP: financials, orders, inventory, customers and vendors in one system of record. This app gives a workflow the SuiteTalk REST Web Services of one NetSuite account.

The generic record actions work on any record type your account exposes, standard or custom: get, list with a filter, create, update, upsert by external id, and delete. Records can be transformed into another type (a sales order into an invoice) and record actions such as approve can be triggered, mirroring the buttons in the UI. SuiteQL queries run with bound parameters and can page through every result. Typed shortcuts cover the places the raw REST shape is awkward: creating customers, finding customers by email or name, and creating sales orders with their line sublist.

Connect with OAuth 2.0, which Oracle recommends, or with Token-Based Authentication for accounts that already have a TBA integration record; Oracle ends TBA for new integrations from NetSuite 2027.1. Every NetSuite account has its own hostname, so the connection records your account id and the app only ever calls hosts under suitetalk.api.netsuite.com.

Build with NetSuite

Three routes to the same 15 actions. The Workflow tab is generated from NetSuite's own manifest and carries its real ids, so it is copy-pasteable; the Code and CLI examples are the same call for any action on any app, so every app-specific value in them is a blank you fill in.

Create Customer

customer-create

Create a customer (company or individual).

Find Customers

customer-find

Find customers by email, company name or external id.

Get Concurrency Limits

governance-limits-get

Read the account's and this integration's REST concurrency limits (admin roles).

Get Record Metadata

metadata-get

List the record types your account exposes, or get one type's JSON Schema.

Run Record Action

record-action

Trigger a record action such as approve, reject or confirm on a record.

Create Record

record-create

Create a record of any type from a JSON body.

Delete Record

record-delete

Delete a record by internal id or external id. This cannot be undone.

Get Record

record-get

Fetch one record of any type by internal id or external id.

List Records

record-list

List the ids of records of one type, optionally filtered, one page at a time.

Transform Record

record-transform

Create a record of another type from an existing one (e.g. sales order to invoice).

Update Record

record-update

Update some fields of an existing record (PATCH).

Upsert Record by External ID

record-upsert

Create the record if the external id is new, otherwise update it (PUT).

Create Sales Order

sales-order-create

Create a sales order for a customer from a list of lines.

Get Server Time

server-time-get

Read NetSuite's server time (UTC) — a clock to anchor incremental syncs on.

Run SuiteQL Query

suiteql-query

Run a SuiteQL (SQL) query over NetSuite records, one page or all pages.

A workflow step names the app and the action, and the editor fills in the connection when you pick one. This is the Step shape from the workflow spec, carrying NetSuite's real ids.

{
  "manifestVersion": "2",
  "name": "netsuite-example",
  "steps": [
    {
      "id": "record-action",
      "uses": {
        "app": "io.w6w.netsuite",
        "action": "record-action",
        "connection": "conn_YOUR_CONNECTION_ID"
      },
      "with": {
        "recordType": "<recordType>",
        "id": "<id>",
        "action": "<action>"
      }
    }
  ]
}

Here are some of the things you can do

  • Run Record Action

    perform
    record-action
  • Create Customer

    perform
    customer-create
  • Find Customers

    search
    customer-find
  • Get Concurrency Limits

    read
    governance-limits-get
  • Get Record Metadata

    read
    metadata-get

+10 more actions available

Every app-specific value here is a blank you have to fill in. An app action is reached through the connection that authenticates it, so the address is a connection id, not the app id — and connections belong to your account, so a public page cannot know yours. Create one for NetSuite, then fill in the three blanks: conn_YOUR_CONNECTION_ID, the action key, and the parameters that action declares. The call itself is real — the shape is transcribed from the studio's own snippet builder, which prints the same kind of blanks — but nothing in it is specific to NetSuite. The Workflow tab is where this app's real ids are.

Install
npm install @w6w/sdk
yarn add @w6w/sdk
pnpm add @w6w/sdk
deno add npm:@w6w/sdk
Code
import { W6wClient, isActionRun } from "@w6w/sdk";

// Reads W6W_BASE_URL and W6W_TOKEN from the environment when omitted.
const client = new W6wClient();

const envelope = await client.run({
  urn: "conn_YOUR_CONNECTION_ID",
  action: "record-action",
  payload: {
    recordType: "<value>",
    id: "<value>",
    action: "<value>",
    // parameters: "<value>",
  },
});

if (isActionRun(envelope)) console.log(envelope.value);
Install the CLI
npm install -g @w6w/cli
CLI
w6w run conn_YOUR_CONNECTION_ID --action record-action --payload '{"recordType":"<value>","id":"<value>","action":"<value>"}'

Give an AI agent NetSuite — without giving it NetSuite's credentials. One MCP endpoint exposes every app, function and workflow the caller is entitled to, as tools it can discover and run. Access is granted per team while we onboard.

One tool call
{
  "name": "w6w_invoke",
  "arguments": {
    "ref": "app:io.w6w.netsuite#record-action",
    "input": {
      "recordType": "<recordType>",
      "id": "<id>",
      "action": "<action>"
    }
  }
}

Every tool names its target with a single ref. The app: form above doesn't name a connection at all — the host resolves which of the caller's NetSuite connections to sign with, and refuses rather than guesses when the answer is ambiguous.

What the agent gets

Credentials it can't read

The token is attached host-side, at the moment of the call. It is never a tool argument, never in the model's context, and never in a transcript — so a prompt injection has nothing to exfiltrate.

A tool surface scoped to the caller

Tools are derived per end user from what that person has actually connected and is entitled to — not one shared bot identity carrying the union of everyone's access.

A durable workflow in one call

Multi-step work runs on the workflow engine and returns a run handle the agent can poll — retries, branching and state survive the conversation that started them.

Health-aware discovery

NetSuite's declared health checks are on the surface too, so an agent can tell "the vendor is down" from "your credential expired" before it burns a retry on either.

The MCP surface is part of the hosted platform. NetSuite itself is MIT, and the runtime that executes it is source-available (FSL).

Request MCP access

Health checks

NetSuite declares its own checks, so its health is a property of the app rather than something the host guesses at.

service

NetSuite SuiteTalk status

The SuiteTalk (web services) group on status.netsuite.com, across data centers. Reports degraded — never down — because the account's own data center is not knowable.

dependency

Account host reachable

Unsigned request to this connection's account-specific REST host. A NetSuite error envelope proves it is serving; an unresolvable host means a wrong or retired account id.

quota

API quota headroom