Overview
This node integrates with the NetSuite REST API to perform various record operations. Specifically, the Get Record operation retrieves a single record from NetSuite based on its internal or external ID. It supports expanding sub-resources (such as sublists and subrecords) and customizing the format of enumeration values.
Common scenarios for this node include:
- Fetching detailed information about a specific sales order, customer, invoice, or any other NetSuite record.
- Retrieving custom records by specifying their script ID.
- Extracting only certain fields or expanding related sublists for comprehensive data retrieval.
Practical example:
- A user wants to get all details of a Sales Order with internal ID
12345, including all line items and sublists expanded, to process it further in an automation workflow.
Properties
| Name | Meaning |
|---|---|
| Record Type | The type of NetSuite record to retrieve. Options include standard records like "Sales Order", "Customer", "Invoice", and many others. For custom records, select "Custom" and specify the Custom Record Script ID. |
| Custom Record Script ID | Required if "Custom" is selected as Record Type. This is the internal identifier of the custom record type, usually starting with customrecord. |
| ID | The internal identifier of the record to fetch. Can be prefixed with eid: to use an external identifier instead. |
| Restrict Returned Fields | Optional comma-separated list of fields and sublists to return, limiting the response to only those specified. |
| Expand Sub-resources | If true, automatically expands all sublists, sublist lines, and subrecords on the record, providing more detailed nested data. |
| Simple Enum Format | If true, returns enumeration values in a simplified format showing only the internal ID value rather than full objects. |
| API Version | The version of the NetSuite REST API to use. Currently only "v1" is supported. |
| Options | Additional options: - Concurrency: Maximum number of concurrent REST requests sent to NetSuite (default 1). - Full Response: Return the full HTTP response instead of just the body. |
Output
The output contains a JSON object representing the requested NetSuite record. The structure depends on the record type and the options used:
- The main
jsonfield includes the record's fields and values. - If
Expand Sub-resourcesis enabled, nested sublists and subrecords are included in expanded form. - If
Simple Enum Formatis enabled, enumeration fields show only their internal ID values. - If
Restrict Returned Fieldsis set, only those fields and sublists appear in the output. - When the "Full Response" option is enabled, the output includes HTTP status code, headers, and the full response body.
No binary data output is produced by this operation.
Dependencies
- Requires valid NetSuite API credentials with appropriate permissions to access the specified record types.
- Uses the NetSuite REST API endpoint configured via these credentials.
- Supports concurrency control to manage request throughput.
- No additional environment variables are required beyond standard credential setup.
Troubleshooting
Error: The operation "getRecord" is not supported!
This indicates an invalid or unsupported operation was selected. Ensure the operation parameter is correctly set to "getRecord".Authentication errors or permission denied
Verify that the API key or token credentials have sufficient rights to read the specified record type.Record not found or invalid ID
Confirm the internal ID or external ID prefix (eid:) is correct and the record exists in NetSuite.Rate limiting or concurrency issues
If you encounter rate limit errors, reduce the concurrency option to send fewer simultaneous requests.Malformed field restriction string
When using "Restrict Returned Fields," ensure the field names are correctly formatted and exist on the record type.