NetSuite Upsert Record
You can use the NetSuite Upsert Record to add or update records to the NetSuite system.
If the external ID of the new record exists in the NetSuite system, the new record updates the existing record that has the same external ID. Otherwise, a new record is created in the NetSuite system.
This activity supports batch operations. You can upsert multiple records at a time. If you want to upsert a data collection in the NetSuite system in a batch, you can use the For-Each statement to map the data collection to the elements in the Input fields in the NetSuite Upsert Record activity. It also supports custom fields, custom records, and custom lists, see Customization for more information.
In the General tab, you can specify a NetSuite connection and record category. The General tab contains the following fields:
|Name||No||(Required) Specify a name for the activity in the process definition.|
|NetSuite Connection||Yes||(Required) Select a shared connection resource.
Click the icon to select a space connection. If no matching NetSuite connections are found, click Create Shared Resource in the Select NetSuiteConnectionResource Resource Template dialog to create one. See Creating a NetSuite Connection Shared Resource for more details.
|Record Category||No||(Required) Select the top level category of the record type.|
|Record Subcategory||No||(Required) Select the subcategory of the record type.|
|Record||No||(Required) Select the record type.|
In the Input tab, you can specify the fields that you require. The Input tab contains the following fields:
In the Output tab, you can check the response information. The Output tab contains the following fields:
The Fault tab lists exceptions that are thrown by this activity. For more detailed information, see Error Codes.
|Error Schema Element||Data Type||Description|
|msg||String||The TIBCO ActiveMatrix BusinessWorks Plug-in for NetSuite error message.|
|msgCode||String||The TIBCO ActiveMatrix BusinessWorks Plug-in for NetSuite error code.|
|msg||String||The NetSuite system error message when processing a request from the plug-in.|
|msgCode||String||The NetSuite system error code when processing a request from the plug-in.|
|NetSuiteMSG||String||The NetSuite server error message when processing a request from the plug-in.|