# Insert ImportSet Records

> `UiPath.ServiceNow.Activities.InsertImportSetRecords`

`UiPath.ServiceNow.Activities.InsertImportSetRecords`

The **Insert ImportSet Records** activity uses the ServiceNow [Import Set - GET](https://docs.servicenow.com/bundle/sandiego-application-development/page/integrate/inbound-rest/concept/c_ImportSetAPI.html#import-GET) API to update existing or insert new records.

After completing the operation, the activity outputs the result of the insert in a `DataTable` object (**Result**) and the operation status (success/failure information) in in a `ResponseStatus` object (**ServiceNowStatus**) that you can use in subsequent activities (e.g., conditional logic).

:::tip
This activities package provides four different methods to update and/or insert a record: [Update ServiceNow Record](https://docs.uipath.com/activities/other/latest/legacy-integrations/servicenow-update-servicenow-record), [Insert ServiceNow Record](https://docs.uipath.com/activities/other/latest/legacy-integrations/servicenow-insert-servicenow-record), [Upsert Records](https://docs.uipath.com/activities/other/latest/legacy-integrations/servicenow-upsert-records), or **Insert ImportSet Records**. The**Update ServiceNow Record**, **Insert 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 writing directly to production tables, it's recommended that you use the **Insert ImportSet Records** activity to update or insert a new record. For detailed information, including troubleshooting import set performance, see the [import sets](https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/import-sets/reference/import-sets-landing-page.html) in the ServiceNow documentation. To learn more about using import sets, see [Web service import set](https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/concept/c_WebServiceImportSets.html) and [Importing data using import sets](https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/concept/c_ImportDataUsingImportSets.html) 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](https://docs.uipath.com/activities/other/latest/legacy-integrations/servicenow-setup) steps.
2. Add the [ServiceNow Scope](https://docs.uipath.com/activities/other/latest/legacy-integrations/servicenow-scope) activity to your project.
3. Add the **Insert ImportSet Records** activity inside the **ServiceNow Scope** activity.
4. Click the **Configure** button inside the **Insert ImportSet Records** activity (this opens the **Object Wizard**).
5. Select the **Object** that you want to use for your import set and enter your **Input** properties.
6. Create and enter a `DataTable` variable and a `ResponseStatus` variable for the [Output](https://docs.uipath.com/activities/other/latest/legacy-integrations/servicenow-insert-importset-records#insert-importset-records) properties.
   * Your input property values are sent to the [Import Set - GET](https://docs.servicenow.com/bundle/sandiego-application-development/page/integrate/inbound-rest/concept/c_ImportSetAPI.html#import-GET) API.
   * The API returns the `DataTable and` ResponseStatus` values to your output property variables.

     ![docs image](https://dev-assets.cms.uipath.com/assets/images/activities/legacy-integrations-docs-image-181216-11d3b4b5-8d9ec23a.webp)

## In the Body of the Activity

To select your import set, you must use the **Object Wizard** by clicking the **Configure** button.

* **Object** - The import set that you want to use. Use the **Object Wizard** to select your Import Set. The **Object Wizard** drop-down list includes the import sets that you have in your ServiceNow application.

## 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](https://docs.uipath.com/activities/other/latest/legacy-integrations/servicenow-troubleshooting) for more details.
:::

### Common

* **DisplayName** - The display name of the activity. Enter a `String` or `String` variable.

### Input

* **DataTable** - The data that you want to insert. Enter a `DataTable` variable.

### Misc

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

### Output

* **Result** - The result data of the insert. Enter a `DataTable` variable.
* **Status** - 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.