Overview
This node integrates with the NetSuite REST API to perform various record-related operations. Specifically, the Get Record operation retrieves a single record from NetSuite based on its type and internal identifier. It supports options to restrict returned fields, expand sub-resources (such as sublists or subrecords), and control the format of enumeration values.
Common scenarios where this node is beneficial include:
- Fetching detailed information about a specific sales order, invoice, customer, or any other NetSuite record.
- Retrieving custom records by specifying their script ID.
- Extracting only relevant fields to optimize data transfer.
- Expanding related sublists automatically for comprehensive data retrieval.
Practical example:
- A user wants to get details of a particular sales order by its internal ID, including all line items and sublists, to process it further in an automation workflow.
Properties
| Name | Meaning |
|---|---|
| Record Type | The type of NetSuite record to retrieve. Options include many standard types such as Assembly Item, Billing Account, Calendar Event, Cash Sale, Contact, Customer, Invoice, Sales Order, Vendor, and also Custom Records. |
| Custom Record Script ID | Required if "Custom Record (*)" 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 specific fields and sublists to return, limiting the response to only those specified. |
| Expand Sub-resources | Boolean flag indicating whether to automatically expand all sublists, sublist lines, and subrecords within the record. |
| Simple Enum Format | Boolean flag that, if true, returns enumeration values in a simplified format showing only the internal ID value. |
| API Version | The version of the NetSuite REST API to use. Currently only "v1" is supported. |
| Options | Additional options: - Concurrency: Maximum number of simultaneous REST requests (default 1). - Full Response: If true, returns the full HTTP response instead of just the body. |
Output
The output contains a JSON object representing the retrieved NetSuite record. The structure corresponds directly to the record's fields and sublists as returned by the NetSuite REST API.
- If Expand Sub-resources is enabled, the output will include expanded sublists, sublist lines, and subrecords nested within the main record.
- If Restrict Returned Fields is used, only those specified fields and sublists appear in the output.
- Enumeration fields can be returned either in full detail or simplified to just internal IDs depending on the Simple Enum Format setting.
- If Full Response option is enabled, the output includes HTTP status code, headers, and full response body.
No binary data output is produced by this operation.
Dependencies
- Requires valid NetSuite API credentials with appropriate permissions to access the requested record types.
- Uses the NetSuite REST API endpoint configured via these credentials.
- Supports concurrency control to limit simultaneous API calls.
- No additional external services are required beyond NetSuite itself.
Troubleshooting
- Invalid Record Type or ID: Errors occur if the record type or internal ID does not exist or is misspelled. Verify the exact record type and ID in NetSuite.
- Insufficient Permissions: API credentials must have read access to the specified record type; otherwise, authorization errors will occur.
- API Rate Limits: Excessive concurrency may trigger rate limiting. Reduce the concurrency option if encountering throttling errors.
- Malformed Field List: When restricting returned fields, ensure the field names are correct and properly formatted.
- Unsupported Operation: If an unsupported operation name is provided, the node throws an error unless "Continue On Fail" is enabled.
- Network Issues: Connectivity problems with NetSuite API endpoints will cause request failures.