NetSuite icon

NetSuite

Interact with NetSuite via REST API, SuiteQL, and Restlets using OAuth 2.0 Client Credentials

Actions11

Record → Get

AI-generated

Summary

Retrieve a single NetSuite record by its internal ID, specifying the record type and optional filters such as fields to return and inclusion of sublists (line items).

Inputs

  • Record Type (required) — Select the type of record to fetch from NetSuite, either from a list of known types or by entering a custom record type ID.
  • Record ID (required) — Enter the internal ID of the specific record to retrieve.
  • Additional Options — Optional settings including 'Expand Sub-Resources' to include sublists (line items) in the returned record, and 'Fields' to specify a comma-separated list of field names to include in the response.

Output shape

a single JSON object representing the retrieved NetSuite record

If 'Expand Sub-Resources' is enabled, the returned record includes nested sublist data. The 'Fields' option filters the returned fields to only those specified. Errors include messages explaining the failure, such as missing record ID or authorization issues.

Examples

Example 1: Fetch specific customer record with ID 123

Record Type: customer, Record ID: 123, Additional Options: none

Example 2: Fetch invoice record with ID 456 including line items

Record Type: invoice, Record ID: 456, Additional Options: Expand Sub-Resources enabled

Example 3: Fetch employee record filtering to name and email fields

Record Type: employee, Record ID: 789, Additional Options: Fields set to 'entityid,email'

Links

Discussion