NetSuite TBA icon

NetSuite TBA

Generic NetSuite API using Token-Based Authentication (OAuth 1.0a HMAC-SHA256)

Actions4

Records (CRUD)

AI-generated

Overview

This node provides integration with the NetSuite API using Token-Based Authentication (OAuth 1.0a HMAC-SHA256). It supports multiple operations including generic HTTP requests, CRUD operations on records, listing records, and executing SuiteQL queries. The 'Records (CRUD)' operation allows users to create, retrieve, update, or delete NetSuite records of various types by specifying the record type and action. This node is useful for automating interactions with NetSuite data, such as managing customers, sales orders, or custom record types, directly from n8n workflows.

Use Case Examples

  1. Create a new customer record in NetSuite by specifying the record type as 'customer' and action as 'create' with the required data in JSON format.
  2. Retrieve details of a specific sales order by setting the record type to 'salesOrder', action to 'get', and providing the internal ID of the record.
  3. Update a custom record by specifying its type and internal ID, along with the updated data in JSON format.
  4. Delete a record by specifying its type and internal ID.

Properties

Name Meaning
Record Type Specifies the type of NetSuite record to operate on, e.g., customer, salesOrder, or a custom record type.
Action Defines the CRUD action to perform on the record: Create, Get, Update, or Delete.
Internal ID The unique identifier of the record to get, update, or delete. Required for these actions.
Send Body Determines whether to send a JSON body with the request, useful for create or update actions.
JSON Body The JSON-formatted data to send in the request body when 'Send Body' is true.
Return Full Response If true, returns the full API response instead of just the main data.
Add Prefer: transient Header If true, adds a 'Prefer: transient' header to the request, which may affect how NetSuite processes the request.

Output

JSON

  • id - The internal ID of the record created, retrieved, updated, or deleted.
  • recordType - The type of the record involved in the operation.
  • action - The CRUD action performed on the record.
  • response - The full or partial response data returned from the NetSuite API for the operation.

Dependencies

  • Requires NetSuite Token-Based Authentication credentials (OAuth 1.0a HMAC-SHA256).

Troubleshooting

  • Common issues include authentication failures due to incorrect or expired credentials. Ensure the NetSuite TBA credentials are correctly configured.
  • Errors may occur if the specified record type or internal ID does not exist or is invalid. Verify the record type string and internal ID values.
  • If 'Send Body' is enabled but the JSON body is malformed or missing required fields, the API request may fail. Validate JSON syntax and required data fields.
  • API rate limits or network issues may cause request failures. Implement retry logic or check network connectivity.
  • Error messages from the NetSuite API are propagated; reading the error message helps identify issues such as permission errors or invalid requests.

Links

Discussion