Execute a saved search and retrieve results via NetSuite REST and SuiteScript

domain: NetSuite REST/SuiteScript · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. For REST-based access, authenticate using OAuth 1.0a (TBA - Token Based Authentication): create an integration record in NetSuite, generate an access token for a specific role, and sign each request with the consumer key, consumer secret, token, and token secret using HMAC-SHA256.
  2. To run a saved search via SuiteScript 2.x, use the N/search module: call search.load with the saved search internal ID, then call savedSearch.run().getRange to retrieve result rows in batches of up to 1000.
  3. To execute a saved search via the REST Record API, use the SuiteQL endpoint: POST to /services/rest/query/v1/suiteql with a SQL-like query body; this is the recommended REST approach for record queries.
  4. Paginate SuiteQL results using the 'offset' and 'limit' query parameters on the SuiteQL endpoint, or using the 'hasMore' and pagination links in the response.
  5. Map SuiteQL column names to internal field IDs (e.g., 'tranid' for transaction number, 'entity' for customer); use the NetSuite Records Browser or field inspector to confirm internal IDs before querying.

Known gotchas

Related routes

Replicate NetSuite Saved Search behavior using SuiteQL for reporting and data export
docs.oracle.com · 6 steps · unrated
Run a saved search via SuiteTalk SOAP and page through all results using searchMoreWithId
netsuite · 5 steps · unrated
Run a SuiteQL query against NetSuite via the REST API
docs.oracle.com/en/cloud/saas/netsuite · 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