Dynamic SuiteQL Execution in NetSuite via External API - n8n Workflow

• NetSuite Administrators and Developers needing flexible, external query access.


• Users building custom reporting tools outside of NetSuite.


• Teams looking for reusable n8n templates for ERP integration.


• Anyone seeking to extend NetSuite's capabilities using the n8n platform.

This n8n workflow provides a powerful and secure method for running custom SuiteQL queries against a connected NetSuite instance. Instead of hardcoding static queries, this solution leverages an external Webhook n8n trigger to accept dynamic query strings at runtime. This capability is essential for businesses requiring complex, on-demand reporting, real-time data synchronization, or when integrating NetSuite data into specialized applications. By utilizing this n8n template, users can quickly set up a low-latency API endpoint specifically designed for secure, database-level interaction with NetSuite.

The entire automation process is initiated by an external system sending an HTTP request to the designated Webhook n8n trigger. This n8n workflow expects the incoming request body to contain the required SuiteQL query string, typically mapped to the payload path query.suiteql. Once the data is received by the Webhook n8n node, it is passed directly to the core NetSuite n8n node. The NetSuite n8n node is configured specifically for the runSuiteQL operation. Critically, the query parameter within the n8n node configuration is set dynamically using an expression ({{ $json.query.suiteql }}). This ensures the query provided by the external system is executed directly by NetSuite. After execution, the results from the NetSuite n8n node—which include the structured dataset—are returned as the final response to the originating Webhook call, completing the n8n workflow.

1. Import the n8n template: Copy the provided JSON and paste it into your n8n instance via the 'New' menu -> 'Import from JSON'.


2. Set up NetSuite Credentials: You must provide valid NetSuite credentials. Click on the NetSuite n8n node, select 'Create New Credential', and fill in the necessary authentication details (e.g., Token-Based Authentication).


3. Activate the Webhook: After saving the n8n workflow, activate it. Note the webhook URL displayed in the Webhook n8n trigger node. This URL is the endpoint you will use for external systems.


4. Testing: Use the 'When clicking ‘Test workflow’' n8n trigger for manual testing, or send a test HTTP POST request to the Webhook URL, ensuring the payload contains the key suiteql nested under query.

Webhook (n8n trigger): This is the entry point for the n8n workflow. It is set to respond with data from the last node executed (responseMode: 'lastNode') and returns all output entries (responseData: 'allEntries'). It listens for external POST requests carrying the dynamic SuiteQL payload.
NetSuite (n8n node): The core action node. Its function is to interface directly with the NetSuite API. It uses the runSuiteQL operation. The critical configuration is the query parameter, which is set to dynamically pull the query string from the incoming payload: ={{ $json.query.suiteql }}.

• When clicking ‘Test workflow’ (n8n trigger): A standard n8n trigger used purely for development and testing, allowing users to execute the flow manually without an external HTTP call.