Exporting grids in the background

Overview

Orchestrator objects are displayed on their dedicated page, in a grid with various columns that are helpful to describe the status of that object.

You can export these grids to get a batch of data you can later use to create dashboards or reports. The exporting operation takes place in the background, meaning you can continue to interact with Orchestrator without having to wait for the export to finish, as a notification informs you when the download is ready.

The download format is .csv, which makes it data-analysis compliant, and you can access it from the My Reports page.

Orchestrator objects available for export

You can export the grids of the following Orchestrator objects:

• At tenant level
  • Audit logs
  • Test Automation Audit logs
• At folder level
  • Queue transactions
  • Logs
  • Jobs

The exported report

Clicking the Export button creates a copy of the grid in the My reports page. A pop-up informs you when the export starts and when or if it completes.

Once the export is complete, you receive an alert letting you know that the data has been exported. The report is downloaded automatically in the background, to your browser's default download location, if you have the View on Alerts permission. However, you can also visit the My reports page and download the report at your own convenience.

The My reports page only displays the exports you created in the last 168 hours (7 days x 24 hours). Exports older than 168 hours are permanently deleted. For example, an export created on the 1st at 00:00 is available until the 7th at 23:59.

To see your exports, click the My reports icon on the top navigation bar.

You can see the following properties of an export:

• Export type - refers to the Orchestrator object
• Created on - the relative timestamp of when you created the export
• Created on (absolute) - the exact timestamp of when you created the export. Absolute timestamps are rendered in the tenant time zone. For triggers, the next run time is rendered in the trigger time zone which may differ from the tenant time zone.
• Available until - the date when the export is to be removed from the list. Reports are removed at 00:00 on the specified date.

  This is only displayed once the report has been exported.

• Size - the size of the export. This is only displayed once the report has been exported.

• Status - the status of the export operation:

  • New - the export is in progress.
  • Completed - the export finished.

  • Failed - the export failed. This may be generated by SQL timeout, or low storage. You need to manually retry the export.

    The computing time to resolve the export is maximum 15 minutes. After this time, the export fails. Before retrying the export, apply additional filters to your data.

    Important:

    To prevent the failure of exports with a large amount of data:

    • You must use the API endpoints for the corresponding Orchestrator object. For example, use /odata/AuditLogs/UiPath.Server.Configuration.OData.Export to export Audit logs.

    • The volume of generated exports both in terms of frequency and amount of data retrieved, can affect the performance of your tenant. If performance is affected, we might throttle or block such requests to ensure your automations are not affected by this behaviour.

    • Apply filters to reduce the amount of exported data.

To download the data to your device, click the Download button for the desired report. This operation uses the default download location on your device. The report is downloaded as an archive, which contains the .csv file of the grid filtered data.

The .zip and the .csv files are named using the following the naming conventions:

Exported object type	Download file naming convention
Queue transactions	{queue-name}-items-{export-date}-{export-timestamp}-{export-id} If the queue name contains invalid characters (\ / : * ? " < > |), they are replaced with _.
Audit logs	audit-logs-{export-date}-{export-timestamp}-{export-id}
Logs	robot-logs-{export-date}-{export-timestamp}-{export-id}
Jobs	jobs-{job_folder_key}-{export-date}-{export-timestamp}-{export-id}

Where:

• {queue_name} - the name of the queue containing the exported queue items

• {job_folder_key} - the ID of the folder from which the job grid was exported

• {export_date} - the date when the export was created, in the yyyy-MM-dd format
• {export_timestamp} - the time when the export was created , in the HH-mm-ss-fff format
• {export-id} - the ID of the export

For example, an export download file for an audit logs grid could be named audit-logs-2023-01-27-12-29-40-843-24.zip.

Important:

Time columns in exported reports are expressed in the tenant's timezone.

Important considerations on API exports

• The $select, $top, $skip, $orderBy, and $count keywords in our export API are not supported, and we strongly advise that you avoid using them. Please use appropriate filters instead.
• Report entries are only sorted by Id, i.e. $orderBy=Id. Any other parameters used for the $orderBy keyword are ignored.
• Filtering through a $filter= structure only allows the fields marked as available in the table.

• Using any of the unsupported fields, as described in the following tables, returns a 400 error.

Export alerts

All exports you create are logged on the Alerts page, provided you have the proper permissions. Completed exports are logged with the Info severity, while failed exports are logged with the Error severity.

By default, you receive alert emails about completed or failed exports. You can unsubscribe from these alerts by navigating to the Alert Preferences page and unselecting the Export option.

Read more about Alerts.