Subscribe

UiPath Activities

The UiPath Activities Guide

Insert ServiceNow Importset

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

👍

Best Practice

This activities package provides four different methods to insert a record: Insert ServiceNow Record, Upsert Records), Insert ImportSet Records, and Insert ServiceNow ImportSet**

The Insert ServiceNow Record and Upsert Records activities use REST APIs to write directly to a production table. The Insert ImportSet Records and Insert ServiceNow ImportSetactivity 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 into ServiceNow 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.

Configure

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.

Properties

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

📘

Troubleshooting the property grid

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.

Attributes

Details

Type

String

Required

Yes

Default value

Insert ServiceNow ImportSet

Allowed values

Enter a String or String variable.

Notes

N/A


Advanced

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 ServiceNow database table for the selected object type.


Object wizard

sys_id

The id of the ServiceNow record that gets created.

Attributes

Details

Type

String

Required

No

Default value

Empty

Allowed values

Enter a String variable.

Notes

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


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

ServiceNowStatus

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 API request was successful.
ErrorCode - String - The response error if the API 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.

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

Updated 3 months ago


Insert ServiceNow Importset


Suggested Edits are limited on API Reference Pages

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