Actions11
Record → Upsert
AI-generatedSummary
Create or update a NetSuite record by matching on a specified external ID field. If a record with the given external ID value exists, it updates that record; otherwise, it creates a new record with the provided field values.
Inputs
- Record Type (required) — Select the type of NetSuite record to upsert, either from the provided list or by entering a custom ID.
- External ID Field (required) — Specify the field name used to identify the record for the upsert operation (e.g., "externalid" or a custom field).
- External ID Value (required) — Provide the value of the external ID field to match the record.
- Fields (required) — Enter a JSON object representing the fields and values to create or update on the record.
Output shape
a single record's data object representing the created or updated NetSuite record
The operation makes a PUT request to the NetSuite REST API, returning the full details of the created or updated record. If the external ID value is missing, the operation errors. The 'Fields' input must be valid JSON or the operation will fail.
Examples
Example 1: Upsert a customer record by external ID
Record Type='customer', External ID Field='externalid', External ID Value='cust123', Fields='{"companyname": "Acme Corp", "email": "contact@acme.com"}'
