Overview
This node integrates with the NetSuite REST API to perform various record management operations. Specifically, the "Insert Record" operation allows users to create new records of different types in their NetSuite account. This is useful for automating data entry tasks such as adding new customers, sales orders, invoices, or custom records directly from workflows.
Common scenarios include:
- Automatically creating customer records when a new lead is captured.
- Inserting sales orders based on external e-commerce transactions.
- Adding calendar events or tasks triggered by other systems.
- Creating custom records tailored to specific business needs.
By using this node, users can streamline and automate interactions with NetSuite, reducing manual data entry and improving integration between systems.
Properties
| Name | Meaning |
|---|---|
| Record Type | The type of NetSuite record to insert. Options include many standard record types such as Assembly Item, Billing Account, Calendar Event, Cash Sale, Charge, Contact, Customer, Invoice, Sales Order, Vendor, and more. For custom records, select "Custom Record (*)". |
| Custom Record Script ID | (Required if Record Type is "Custom Record") The internal identifier of the custom record type, usually starting with "customrecord". |
| Replace Sublists | (Optional) Comma-separated names of sublists on the record where all lines will be replaced with those specified in the request. Sublists not listed will have lines added instead of replaced. |
| API Version | The version of the NetSuite REST API to use. Currently only "v1" is supported. |
| Options | Additional options: • Concurrency: Maximum number of simultaneous REST requests sent to NetSuite (default 1). • Full Response: Whether to return the full response data instead of just the body. |
Output
The output contains JSON objects representing the response from NetSuite after inserting the record. The structure typically includes:
id: The unique identifier of the newly created record.success: Boolean indicating if the insertion was successful.- Other fields returned by NetSuite related to the inserted record.
- If the "Full Response" option is enabled, the output includes status code, headers, and full response body.
No binary data output is produced by this operation.
Dependencies
- Requires valid NetSuite API credentials including authentication tokens and account information.
- Uses the NetSuite REST API endpoint corresponding to the selected API version.
- Supports concurrency control via an internal concurrency limiter.
- Requires n8n environment configured with appropriate credentials for NetSuite access.
Troubleshooting
- Authentication errors: Ensure that the API key or token credentials are correctly configured and have sufficient permissions.
- Invalid Record Type or Custom Record Script ID: Verify that the record type exists in your NetSuite account and that the custom record script ID is correct.
- API rate limits: If you encounter rate limiting errors, consider lowering the concurrency setting.
- Malformed input data: Make sure the JSON data provided for the record matches the expected schema for the chosen record type.
- Error messages from NetSuite: The node surfaces error details from NetSuite's response. Review these messages to identify issues such as missing required fields or invalid values.