Overview
This node integrates with the NetSuite platform, enabling users to execute SuiteQL queries and perform various record operations via NetSuite's REST API. The "Execute SuiteQL" operation specifically allows running custom SuiteQL queries to retrieve data from NetSuite in a flexible and powerful way.
Common scenarios where this node is beneficial include:
- Extracting complex datasets from NetSuite using SQL-like queries.
- Automating data retrieval for reporting or integration workflows.
- Fetching large volumes of records with pagination support.
- Combining SuiteQL queries with other NetSuite record operations in automation pipelines.
For example, a user might run a SuiteQL query to get all sales orders within a date range, then process that data downstream in n8n for analytics or synchronization with another system.
Properties
| Name | Meaning |
|---|---|
| Query | The SuiteQL query string to execute against NetSuite. |
| Return All | Whether to return all matching results or limit the output to a specified number of records. |
| Limit | Maximum number of records to return when "Return All" is false (range 1-1000). |
| Offset | Number of records to skip before starting to return results (used for pagination). |
| 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 | If true, returns the full HTTP response including headers and status code instead of just the body. |
Output
The node outputs an array of JSON objects representing the rows returned by the SuiteQL query. Each item in the output corresponds to one record retrieved from NetSuite.
- The
jsonfield contains the data for each record as key-value pairs matching the columns selected in the SuiteQL query. - Pagination is handled internally if "Return All" is enabled, so the output includes all matching records up to the configured limits.
- If the "Full Response" option is enabled, the output will include additional metadata such as HTTP status code and headers.
- The node does not output binary data.
Dependencies
- Requires valid NetSuite credentials with appropriate permissions to execute SuiteQL queries and access records.
- Uses the NetSuite REST API v1 endpoint.
- Supports concurrency control to manage rate limits and optimize performance.
- No additional environment variables are required beyond standard credential setup.
Troubleshooting
Common Issues:
- Invalid or malformed SuiteQL query strings will cause errors.
- Insufficient permissions on the NetSuite account may result in authorization failures.
- Exceeding API rate limits can cause request throttling or failures.
- Incorrect pagination parameters (limit/offset) may lead to incomplete or empty results.
Error Messages:
"The operation \"runSuiteQL\" is not supported!"— indicates an unsupported operation was requested; verify the operation name.- API error responses include detailed messages extracted from NetSuite, such as validation errors or permission denials.
- Network or authentication errors will be surfaced as exceptions; ensure credentials are correctly configured.
Resolutions:
- Validate SuiteQL syntax using NetSuite tools before running in the node.
- Check and update API credentials and permissions.
- Adjust concurrency and pagination settings to comply with API limits.
- Use the "Continue On Fail" option to handle errors gracefully in workflows.