Insert ServiceNow ImportSet

UiPath.ServiceNow.Activities.InsertImportSet

The Insert ServiceNow Importset activity uses the the ServiceNow Import Set- POST API to import a new ImportSet object.

After inserting the ImportSet 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 four different methods to insert a record: Insert ServiceNow Record,Upsert Records, Insert ImportSet Records, and Insert ServiceNow ImportSet.

TheInsert ServiceNow Record and Upsert Records activities use REST APIs to write directly to a production table. The Insert ImportSet Records and Insert ServiceNow ImportSet 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 are 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 ImportSet activity inside the ServiceNow Scope activity.
4. Click the Configure button inside the Insert ServiceNow ImportSet 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 ImportSet - POST API.
   • The API returns the ResponseStatus value to your output property variable.

In the Body of the Activity

To enter your Insert ServiceNow ImportSet 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.

Common

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

Misc

• 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.
• 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.