@digitalnodecom/node-red-contrib-netsuiteauth

Node-RED NetSuite Integration

A collection of Node-RED nodes to interact with NetSuite using OAuth 1.0 authentication and the REST API.

Features

• OAuth 1.0 authentication configuration for NetSuite
• REST API requests to NetSuite records
• SuiteQL API requests for advanced querying

Prerequisites

• Node-RED installed and running
• NetSuite account with REST Web Services enabled
• NetSuite Integration Record with OAuth 1.0 credentials

Nodes

NetSuite OAuth Config

This configuration node stores NetSuite OAuth 1.0 credentials required for authenticating with the NetSuite REST API.

Configuration

Parameter	Description
Name	A name for this configuration
Consumer Key	OAuth Consumer Key from NetSuite Integration Record
Consumer Secret	OAuth Consumer Secret from NetSuite Integration Record
Token	OAuth Token from NetSuite Integration Record
Token Secret	OAuth Token Secret from NetSuite Integration Record
OAuth Realm	NetSuite Account ID (e.g., 888063_SB1)

Setup

1. In Node-RED, add a new "NetSuite OAuth Config" node
2. Enter your NetSuite OAuth credentials
3. Click "Add" to save the configuration

This shared configuration can be used by other NetSuite nodes in your flows.

NetSuite REST API Request

This node allows you to perform CRUD operations against NetSuite records using the REST API.

Configuration

Parameter	Description
Name	A name for this node
OAuth Config	Select your NetSuite OAuth configuration
HTTP Method	Select GET, POST, PUT, PATCH, or DELETE
URL	Base URL for the NetSuite REST API (https://[accountid].suitetalk.api.netsuite.com/services/rest/record/v1)
NetSuite Object	Select the NetSuite record type to interact with (e.g., customer, invoice, etc.)
Limit	Maximum number of records to return (for GET requests)
Offset	Starting offset for pagination (for GET requests)
ID of the object	Internal ID of the record (for GET, PATCH, DELETE operations)
External ID of the object	External ID of the record (for PUT operations)
Body	JSON body for POST, PUT, and PATCH operations

Input

The node can be configured either through the node configuration or dynamically via msg properties:

• msg.payload.url - Overrides the configured URL
• msg.payload.method - Overrides the configured HTTP method
• msg.payload.netsuiteobject - Overrides the configured NetSuite object
• msg.payload.limit - Overrides the configured limit
• msg.payload.offset - Overrides the configured offset
• msg.payload.objectid - Overrides the configured internal ID
• msg.payload.objectexternalid - Overrides the configured external ID
• msg.payload.bodyNetsuite - Overrides the configured body

Output

• msg.payload.data - Contains the response data from NetSuite
• msg.payload.headers - Contains the response headers
• msg.payload.statusCode - Contains the HTTP status code
• msg.error - Contains error details if the request fails

HTTP Method Usage

• GET: Retrieve records. Use with limit/offset for lists or objectid for single records
• POST: Create new records. Requires a valid JSON body
• PUT: Update records with external ID. Requires both objectexternalid and a valid JSON body
• PATCH: Update specific fields of a record. Requires objectid and a valid JSON body
• DELETE: Delete a record. Requires objectid

NetSuite SuiteQL API Request

This node allows you to run SuiteQL queries against the NetSuite API.

Configuration

Parameter	Description
OAuth Config	Select your NetSuite OAuth configuration
URL	The SuiteQL endpoint URL (https://[accountid].suitetalk.api.netsuite.com/services/rest/query/v1/suiteql)
Body	The SuiteQL query body in JSON format

Input

The node can be configured either through the node configuration or dynamically via msg properties:

• msg.url - Overrides the configured URL (optional)
• msg.payload.body - Overrides the configured body (optional)

Output

• msg.payload - Contains the response data from NetSuite
• msg.error - Contains error details if the request fails

SuiteQL Query Format

SuiteQL queries should be formatted in the body as:

{ "q": "SELECT id, entityid FROM customer WHERE companyname LIKE 'A%'" }

URL Structure

• REST API Base URL: https://[accountid].suitetalk.api.netsuite.com/services/rest/record/v1
• SuiteQL API URL: https://[accountid].suitetalk.api.netsuite.com/services/rest/query/v1/suiteql

Replace [accountid] with your NetSuite account ID.

Error Handling

Both nodes include error handling that captures and reports NetSuite API errors:

• NetSuite error details are included in the msg.error property
• Error status is displayed in the node status indicator in the Node-RED editor
• Detailed error information is logged to the Node-RED debug console

Dependencies

• axios: For HTTP requests
• crypto: For OAuth signature generation