- Getting started
- Licensing
- Setup and configuration
- Using Data Service
- Reference
- Examples & Tutorials
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:
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:
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.
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.
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.
If you cannot download 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
To modify a data entry follow the steps below:
To delete a data record follow the below steps:
- In the Data tab select the checkbox in front of the data row you want to delete.
- Click the Delete icon available on the right-hand side of the screen.
- 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.