Overview
This node integrates with NetSuite's REST API to perform various operations on NetSuite records and queries. Specifically, the Execute SuiteQL operation allows users to run SuiteQL queries against their NetSuite data, enabling advanced and flexible data retrieval beyond standard record listing.
Common scenarios where this node is beneficial include:
- Extracting complex datasets from NetSuite using SQL-like queries.
- Automating reporting or data synchronization workflows that require custom queries.
- Retrieving large volumes of data with pagination support.
For example, a user might write a SuiteQL query to join multiple record types and filter results based on specific criteria, then use this node to execute the query and process the results in n8n.
Properties
| Name | Meaning |
|---|---|
| Query | The SuiteQL query string to execute. |
| 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 if "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 row of the query result, with key-value pairs matching the selected columns.
If the "Full Response" option is enabled, the output includes the entire HTTP response structure with status code, headers, and body.
No binary data output is produced by this operation.
Dependencies
- Requires valid NetSuite API credentials with appropriate permissions to execute SuiteQL queries.
- Uses the NetSuite REST API v1 endpoint for SuiteQL.
- Supports concurrency control via the "Concurrency" option to manage request load.
- No additional external services are required beyond NetSuite.
Troubleshooting
- Empty or incomplete results: Check the SuiteQL query syntax and ensure it returns data in NetSuite UI or other tools. Also verify pagination parameters (
LimitandOffset) and whether "Return All" is set correctly. - Authentication errors: Ensure the provided API credentials are valid and have permission to run SuiteQL queries.
- Rate limiting or timeout issues: Adjust the "Concurrency" option to reduce simultaneous requests if encountering rate limits.
- Unsupported operation error: If an unsupported operation name is used, the node throws an error unless "Continue On Fail" is enabled.
- Invalid query parameter: If the query string is empty or malformed, the API may return an error. Validate the SuiteQL syntax carefully.