NetSuite icon

NetSuite

NetSuite REST API

Actions7

Insert Record

AI-generated

Overview

This node operation inserts a new record into the NetSuite system. It supports various record types such as sales orders, customers, invoices, and custom records. The node is useful for automating the creation of records in NetSuite from workflows, for example, creating a new sales order or customer record based on input data from other systems or user input.

Use Case Examples

  1. Automatically create a sales order record in NetSuite when a new order is received in an e-commerce platform.
  2. Insert a new customer record into NetSuite when a new lead is captured from a CRM system.
  3. Add a custom record in NetSuite to track specific business data collected from an external source.

Properties

Name Meaning
Record Type Specifies the type of NetSuite record to insert, such as sales order, customer, invoice, or custom record type.
Custom Record Script ID The internal identifier of the Custom Record type, required if the record type is a custom record. Usually starts with 'customrecord'.
Replace Sublists Comma-delimited names of sublists on the record to replace entirely with the lines specified in the request. Sublists not specified will have lines added.
API Version The version of the NetSuite API to use for the request, default is v1.
Options Additional options for the request such as concurrency (max number of simultaneous REST requests) and whether to return the full response data.

Output

JSON

  • json
    • id - The internal ID of the newly inserted record, if available.
    • success - Indicates if the insert operation was successful.
    • propertyValidation - List of property validations returned by NetSuite, if any.
    • operationId - Operation ID returned by NetSuite for tracking.
    • jobId - Job ID returned by NetSuite for tracking.
    • links - Links related to the inserted record, including self-reference URL.
    • error - Error message if the insert operation failed.

Dependencies

  • NetSuite REST API
  • An API key credential for NetSuite authentication

Troubleshooting

  • Ensure the record type is correctly specified, especially for custom records where the script ID must be provided.
  • Check API credentials and permissions to allow record insertion.
  • If the node throws an error about unsupported operations, verify the operation parameter is set to 'insertRecord'.
  • If the response contains validation errors, review the propertyValidation field for details and adjust the input data accordingly.

Links

Discussion