netsuite_execute_suiteql
Run read-only SuiteQL SELECT queries against NetSuite to fetch specific records. Includes pagination and automatic LIMIT-to-FETCH FIRST conversion.
Instructions
Execute a read-only SuiteQL query against NetSuite. Only SELECT queries are allowed. Required parameter: query (string, SQL SELECT statement). Optional: limit (number, default 100, max 1000), offset (number, default 0). ⚠️ IMPORTANT: Use "FETCH FIRST N ROWS ONLY" instead of "LIMIT N" (auto-converted). Examples: SELECT id, companyName, externalId FROM vendor WHERE externalId = 'spk_supplier_xxx' FETCH FIRST 1 ROWS ONLY SELECT id, acctnumber, fullname FROM account WHERE type = 'Bank' AND subsidiary = 1 SELECT id, tranId, externalId FROM transaction WHERE externalId = 'spk_payable_xxx' AND type = 'VendBill' FETCH FIRST 1 ROWS ONLY
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"query": "<query>"
},
"name": "netsuite_execute_suiteql"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| query | Yes | Read-only SuiteQL SELECT statement | |
| offset | No |