NetSuite MCP connector

NetSuite is Oracle's cloud-based ERP solution for managing financial, customer, and operational data across businesses. The NetSuite MCP connector allows AI agents to query and retrieve business records using SuiteQL, manage customer data, and perform operations on records through the REST Record API. It also supports listing, updating, and deleting records across your NetSuite instance.

Authentication type

• OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.

Uses

Use the NetSuite MCP connector to perform the following actions:

• Retrieve customer records and account details from NetSuite by internal ID
• Query customers, transactions, and inventory using SuiteQL for advanced filtering
• List all records of a specific type to find and review business data
• Update customer information, sales orders, and financial records in NetSuite
• Delete outdated or duplicate records to maintain data accuracy
• Execute complex SuiteQL queries to generate custom business reports and insights
• Automate multi-step workflows that read, modify, and remove NetSuite records

Example prompts

Use the following example prompts to invoke NetSuite MCP connector tools from your AI assistant or Boomi Connect workflow:

• Show me the customer details for ID 12847 in NetSuite.
• Find all invoices with a status of open that were created in the last 30 days.
• List every vendor in our NetSuite instance.
• Query all sales orders from customer ABC Corp that are pending fulfillment.
• Update the billing address for customer John Smith in NetSuite.
• Delete the duplicate employee record with ID 5634.
• Run a SuiteQL query to get all transactions over 50000 from the last quarter.
• Retrieve all purchase orders that have not been approved.
• Show me customers in the technology industry with annual revenue over 1 million.
• Find and list all items in our inventory with zero stock.

NetSuite MCP connector tools

The NetSuite MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
netsuite_netsuitegetcustomer_invoke	Retrieves detailed information for a specific customer record.
netsuite_netsuitequeryrecords_invoke	Searches and retrieves records using structured query language.
listRecords	Displays a list of records of a specified type.
getRecord	Retrieves complete details for a single record by identifier.
updateRecord	Modifies and saves changes to an existing record.
deleteRecord	Removes a record from the system permanently.
runSuiteQL	Executes a custom query to retrieve filtered record data.