Insert ServiceNow Record

UiPath.ServiceNow.Activities.InsertRecord

The Insert ServiceNow Record activity uses the the ServiceNow Table - POST API to insert a new record object.

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

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

Tip:

This activities package provides three different methods to insert a record: Insert ServiceNow Record,Upsert Records, or Insert ImportSet Records.

TheInsert ServiceNow Record and Upsert Records activities use REST APIs to write directly to a production table. The Insert ImportSet Records activity uses the REST Import Set API to write to an import set table from which the data gets transformed into the target production table.

To avoid inserting records directly into production tables, it's recommended that you use the Upsert ServiceNow Record activity to insert a new record.

For detailed information, including troubleshooting import set performance, see import sets in the ServiceNow documentation.

To learn more about using import sets, see Web service import set and Importing data using import sets in the ServiceNow documentation.

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 ServiceNow Scope activity to your project.
3. Add the Insert ServiceNow Record activity inside the ServiceNow Scope activity.
4. Click the Configure button inside the Insert ServiceNow 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 Table - POST API.
   • The API returns the ResponseStatus value to your output property variable.
     
     

     

     
     

In the Body of the Activity

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

To learn more about the Object Wizard, see the Business Activity Frameworks page.

• sys_id - The id of the ServiceNow record that gets created. Enter a String variable. The sys_id is auto-generated by ServiceNow 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).

Properties

Note: If you do not see a list of properties for the object you choose, even looking at the "Add Multiple Fields" option, you may not have sufficient permissions in ServiceNow to see object meta data and modify data. Please see Troubleshooting Permission Issues for more details.

Advanced

• AdditionalFields - A DataRow that includes the columns and values that you want to insert. The column names must match the names as they appear in the ServiceNow database table for the selected object type.

Common

• DisplayName - The display name of the activity. This field supports only Strings or String variables.

Misc

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

Output

• ServiceNowStatus - The status of the request (success/failure information). Enter a ResponseStatus variable (UiPath.BAF.Models.ResponseStatus). The ResponseStatus object includes three properties that you can use in other activities.
  • Success - Boolean - Specifies whether the API request was successful.
  • ErrorCode - String - The response error if the API request is unsuccessful (Success=False).
  • Message - String - The error message.

Example

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

For step-by-step instructions and examples, see the Quickstart guide.