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
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| query | Yes | Read-only SuiteQL SELECT statement | |
| offset | No |