NetSuite icon

NetSuite

NetSuite REST API

Actions7

Update Record

AI-generated

Overview

This node operation updates an existing record in NetSuite. It is useful for scenarios where you need to modify data in various NetSuite record types such as sales orders, customers, invoices, or custom records. For example, you can update the status of a sales order, change customer details, or modify inventory item information programmatically within an automation workflow.

Use Case Examples

  1. Updating the status or details of a sales order after receiving payment confirmation.
  2. Modifying customer contact information based on updated CRM data.
  3. Adjusting inventory item details such as quantity or price after a stock audit.

Properties

Name Meaning
Record Type Specifies the type of NetSuite record to update, such as sales order, customer, invoice, or custom record.
Custom Record Script ID The internal identifier of the custom record type, required if the record type is 'custom'.
ID The internal identifier of the record to update. Prefix with 'eid:' to use the external identifier.
Replace Sublists Comma-separated names of sublists on the record to replace entirely with the provided lines. Sublists not specified will have lines added.
Replace Selected Fields If true, all fields to be deleted in the update must be included in the replace query parameter.
API Version The version of the NetSuite API to use for the update operation.
Options Additional options for the update operation such as concurrency and full response.

Output

JSON

  • json - The JSON response from NetSuite after updating the record, including success status, any validation errors, operation ID, job ID, and links to the updated record.

Dependencies

  • Requires NetSuite API credentials including account ID, consumer key, consumer secret, token key, and token secret.
  • Uses the '@drowl87/netsuite-rest-api-client' package for making REST API requests to NetSuite.

Troubleshooting

  • Error due to invalid or missing internal ID: Ensure the 'ID' field is correctly set with the internal identifier of the record to update.
  • Authentication errors: Verify that the NetSuite API credentials are correctly configured and have the necessary permissions.
  • API version mismatch: Confirm that the selected API version is supported by your NetSuite instance.
  • Concurrency issues: If updating multiple records, adjust the concurrency option to avoid rate limiting or request failures.
  • Field validation errors: Check the response for property validation errors and ensure all required fields are correctly formatted.

Links

Discussion