Overview
This node provides integration with the NetSuite REST API, enabling users to perform various operations on NetSuite records and data. It supports common actions such as retrieving a single record, listing multiple records, inserting new records, updating existing ones, removing records, running SuiteQL queries, and making raw API requests.
Typical use cases include:
- Automating data synchronization between NetSuite and other systems.
- Querying NetSuite data for reporting or analytics.
- Managing NetSuite records programmatically without manual intervention.
- Executing custom SuiteQL queries to retrieve complex datasets.
- Performing batch operations with controlled concurrency to optimize API usage.
For example, a user might list all customer records, update specific fields in bulk, or run a SuiteQL query to extract sales data for a given period.
Properties
| Name | Meaning |
|---|---|
| Options | Collection of optional settings: |
| - Concurrency: Number controlling the maximum number of simultaneous REST requests sent to NetSuite. Default is 1. | |
| - Full Response: Boolean flag indicating whether to return the full HTTP response data (status code, headers, body) instead of only the response body. |
Output
The node outputs JSON data representing the results of the executed operation(s). The structure depends on the operation performed:
- For record retrieval operations (
getRecord,listRecords), the output contains the requested record data or an array of records under thejsonfield. - For insert, update, and delete operations, the output includes success indicators and any returned metadata such as IDs or validation info.
- For SuiteQL queries, the output is an array of result rows matching the query.
- For raw requests, if the "Full Response" option is enabled, the output includes the HTTP status code, headers, and body; otherwise, only the response body is returned.
If errors occur and the node is configured not to continue on failure, it throws an error with a descriptive message. Otherwise, error details are included in the output JSON.
The node does not output binary data.
Dependencies
- Requires valid NetSuite API credentials including account ID, consumer key/secret, and token key/secret.
- Uses the
@fye/netsuite-rest-apipackage internally to make REST API calls. - Supports concurrency control via the
p-limitpackage to limit parallel requests. - Requires n8n credentials setup for authenticating with NetSuite's REST API.
Troubleshooting
- Invalid Credentials or Authentication Errors: Ensure that the provided API keys and tokens are correct and have sufficient permissions in NetSuite.
- Unsupported Operation Error: If an unsupported operation name is specified, the node will throw an error unless "Continue On Fail" is enabled.
- Rate Limiting or Concurrency Issues: Adjust the "Concurrency" option to avoid hitting NetSuite API rate limits.
- Malformed Queries or Paths: When using raw requests or SuiteQL, verify that the query syntax and API paths are correct.
- Partial Data or Pagination: For list and query operations, ensure "Return All" and pagination parameters are set appropriately to retrieve complete datasets.