Managing the Data for an Entity

You can import the entity in UiPath Studio and use it in your process to create data. However, you can add, manage, and delete basic data to entities in Data Service by following the below steps:

Adding Data

To add new data to an entity follow the below steps:

1. Click on the entity for which you want to add more data.
2. Access the Data tab.
3. Click Add New Data.
   
   

   

   
   
4. In the Add Data panel add a value for each field that you have defined for the entity.
5. Click Save.
   
   

   

   
   

   A new data record is displayed in the Data tab.

Importing data using a CSV file

Note:

You need Read and Create permissions for the entity to which you intend to import data.

Important:

Importing is not supported for relationship fields, choice sets, and auto-number field data. To enable data import, ensure these fields are designed as non-required.

To add new data to an existing entity:

1. Navigate to the entity where to want to import data.
2. In the Fields or Data tab of the selected entity, click Import data. The File explorer window opens.
3. Browse for the CSV file containing the data you want to import.
   Note:

   Columns in the CSV file must have the same display name as the fields of the entity for which you import the data.

4. If you previously selected the same file for import, a pop-up message asks you for confirmation.

Prerequisites for the CSV file

To ensure the successful outcome of the import operation, your CSV file must meet the following prerequisites:

• The CSV file must be saved as one of the following types:

  • CSV (Comma delimited) (*.csv)
  • CSV (MS-DOS) (*.csv)
  • CSV (UTF-8) (*.csv)

• The CSV file must be of maximum 10 MB.

• The CSV file must contain maximum 30,000 entries.

• Columns in the CSV file must match the display name of the entity fields.

• Columns in the CSV file must match the field data type. For example, for a Text type field, the column in the CSV must contain text.

• Columns in the CSV file must have values for entity fields marked as required.

• Columns in the CSV file corresponding to fields marked as unique in Data Service must not contain duplicate data.

Import successful

The "Import successful!" pop-up informs you about the successful outcome of the import.

The new records are displayed in a bold font.

The system built-in Created By field displays the account that performed the first import, whereas the system built-in Created field displays the date of the first import. The Modified By and Modified fields provide details on the subsequent imports for the same entity.

Default values are provided for fields where the data in the CSV file is missing.

Import failed

The "Failed to Import" message box informs about the error causing the import to fail.

In some cases, only several records fail at import, whereas the overall import is successful. You can access an output file containing the failed records for review.

Failures caused by throttling may occur when more than 10 users are importing simultaneously. If this happens, attempt the import again.

The overall import fails when:

• 80 out of the first 100 records fail at import.

• network connectivity issues occur.

Important:

If you cannot dowload the failed records file, request a copy by reaching out to support in maximum seven days. Provide the following data:

• Data and time of the import

• Organization ID

• Entity ID

• User email

Update the Entity Data

To modify a data entry follow the steps below:

Note: You cannot change the value of the system built-in fields.

1. In the Data tab select the checkbox in front of the data row you want to edit.
2. Click the Edit available on the right-hand side of the screen.
3. Apply the updates.
4. Click Save.
   
   

   

   
   

   Note: You can also modify a data entry inline by clicking on the field for a data row you want to edit. Make your changes and then click outside, or hit Enter to persist them.

Deleting Data

To delete a data record follow the below steps:

1. In the Data tab select the checkbox in front of the data row you want to delete.
2. Click the Delete icon available on the right-hand side of the screen.
3. Click Delete in the Delete Data dialog to confirm the action.

The data record is removed from the list of data records in the Data tab.