Subscribe

The UiPath Marketplace Guide

Insert Record

The Insert Record activity uses the the SOAP add operation to insert a new record object.

After inserting the record, the activity outputs the status of the request (success/failure information) in a Status object (NetSuiteStatus) that you can use in subsequent activities (e.g., conditional logic).

This activity also returns the internalid value of the new record object. For example, if you want to insert a NetSuite Employee object, you can output the internalId value by adding a String variable in the object wizard (see example below).

How it works

The following steps and message sequence diagram is an example of how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

  1. Complete the Setup steps.
  2. Add the NetSuite Application Scope activity to your project.
  3. Add the Insert Record activity inside the netsuite Scope activity.
  4. Click the Configure button inside the Insert Record activity (this opens the Object Wizard).
  5. Select the Object you want to insert and add the fields (with values) you want to populate.
  6. Create and enter a ResponseStatus variable for the Output property.
    • Your input property values are sent to the add operation.
    • The operation returns the ResponseStatus value to your output property variable.

Properties

The values for the following properties are specified when adding this activity to your project in UiPath Studio.

Configure

To enter your Insert NetSuite Record property values, you must use the Object Wizard by clicking the Configure button.

To learn more, see the Wizards section in the About page.

Common

DisplayName

The display name of the activity.

Attributes

Details

Type

String

Required

Yes

Default value

Insert Record

Allowed values

Enter a String or String variable.

Notes

N/A


Object wizard

Select Object

The type of object that you want to insert.

Attributes

Details

Type

Drop-down list

Required

No

Default value

Empty

Allowed values

Select an item from the drop-down list.

Notes

N/A


internalid

The id of the NetSuite record that gets created.

Attributes

Details

Type

String

Required

No

Default value

Empty

Allowed values

Enter a String variable.

Notes

The internalid is auto-generated by NetSuite when you insert your new record. To retrieve this value for use in other activities, create and enter a String variable in the object wizard (example shown below).
For more information, see Enable Show Internal IDs in the Setup guide.


Input

AdditionalFields

A DataRow that includes the columns and values that you want to insert.

Attributes

Details

Type

String

Required

No

Default value

Empty

Allowed values

Enter a String variable.

Notes

The column names must match the names as they appear in the NetSuite database table for the record type.


Misc

Private

If selected, the values of variables and arguments are no longer logged at Verbose level.

Attributes

Details

Type

Checkbox

Required

No

Default value

Not Selected

Allowed values

Selected or Not Selected

Notes

N/A


Output

NetSuiteStatus

The status of the request (success/failure information).

Attributes

Details

Type

ResponseStatus

Required

No (required if you want to use the output data in subsequent activities)

Default value

Empty

Allowed values

Enter a ResponseStatus variable.

UiPath.BAF.Models.ResponseStatus

Notes

The ResponseStatus object includes three properties that you can use in other activities.
Success - Boolean - Specifies whether the request was successful.
ErrorCode - String - The response error if the request is unsuccessful (Success=False).
Message - String - The error message.
The example image below shows some of the properties that you can return.


Example

The following image shows an example of the activity dependency relationship and input/output property values.

Updated 6 months ago


Insert Record


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.