By Source · NetSuite

NetSuite + Connect AI

Query NetSuite transactions, customers, items, and financial records from any AI agent. Connect AI translates standard SQL to SuiteQL and handles role-based data visibility.

Use with Claude  ·  Use with OpenAI

Common objects
Transaction Customer Item Vendor Employee Account + custom records 
-- Ask Claude Code (or any MCP-aware agent):
--
-- "From NetSuite, show me the top 25 sales orders this year
-- by amount, with the customer name."
--
-- Claude generates and runs this SQL via the queryData MCP tool.
-- Standard SQL -- translated to SuiteQL automatically.

SELECT
  t.TranDate,
  t.TranId,
  c.CompanyName AS Customer,
  t.ForeignTotal AS Amount,
  t.Status
FROM [NetSuite].[NetSuite].[Transaction] t
LEFT JOIN [NetSuite].[NetSuite].[Customer] c
  ON t.Entity = c.Id
WHERE t.Type = 'SalesOrd'
  AND t.TranDate >= '2025-01-01'
ORDER BY t.ForeignTotal DESC
LIMIT 25

Tutorials by AI surface

Working integrations for NetSuite + every supported AI surface.

NetSuite + Claude Agent SDK Financial reporting, order analysis, and vendor reconciliation via a Python agent.
NetSuite + OpenAI SDK OpenAI Python SDK assistant for querying ERP transactions, inventory, and customers.
NetSuite + LangGraph Stateful pipelines for automated financial close reporting and anomaly detection.

Known quirks

SuiteQL vs. SuiteTalk schemas

NetSuite exposes two APIs: SuiteQL (SQL-like, good for reporting) and SuiteTalk (SOAP, full record access). Connect AI uses SuiteQL by default for read queries. If you see missing fields, check whether the field exists in the SuiteQL schema or requires SuiteTalk access.

Role-based visibility

NetSuite enforces row-level access by role. The Connect AI connection identity determines which subsidiaries, locations, and record types are visible. Use a dedicated integration role with the minimum required permissions.

Custom record types

Custom record types appear in the schema as customrecord_{id}. Use getTables to discover them. Names are normalized from the internal ID, not the display label, check the NetSuite UI to match IDs to business names.

Existing tutorials

Long-form recipes from the CData Knowledge Base.

View tutorials
Connect AI documentation

Full API reference, authentication guides, and configuration details.

View docs