Run a SuiteQL query against NetSuite via the REST API

domain: docs.oracle.com/en/cloud/saas/netsuite · 6 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

In-depth guide

NetSuite SuiteTalk REST authentication — the full failure-mode walkthrough related to docs.oracle.com/en/cloud/saas/netsuite, checked against official docs, with linked verified routes.

Steps

  1. Authenticate with OAuth 1.0a as described for NetSuite REST record operations.
  2. POST to https://{accountId}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql with Content-Type: application/json and Prefer: transient header.
  3. In the request body, include a q field containing the SuiteQL SELECT statement (SuiteQL is a SQL-like dialect that queries NetSuite record types as tables).
  4. The response contains an items array with the result rows and a totalResults count; use the offset and limit query parameters for pagination.
  5. Reference NetSuite record type names as table names (e.g., SELECT id, trandate FROM transaction WHERE type = 'VendBill') using the schema defined in the SuiteQL documentation.
  6. Use the GET /services/rest/record/v1/metadata-catalog/ endpoint to discover available record types and their field names for building accurate queries.

Known gotchas

Related routes

Run a SuiteQL query against NetSuite via the REST endpoint and handle column-level results
docs.oracle.com/en/cloud/saas/netsuite · 6 steps · unrated
Execute paginated SuiteQL queries with JOINs in NetSuite REST API
docs.oracle.com · 6 steps · unrated
Paginate through SuiteQL inventory lot/serial results via NetSuite REST API
netsuite.com · 6 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans