MarketplaceListingsTemplateSymphony - Queue Reporting

Symphony - Queue Reporting

Bronze Certified

Template

0 reviews

202

Symphony - Queue Reporting

Bronze Certified

Template

0 reviews

202


Summary

An UiPath project aiming to simplifly reporting based on a specific Orchestrator queue based on the REST API.

carouselImage0

Overview

The solution proposes to export configurable data contained by the queue items in the Orchestrator and save them as an Excel file.
It is possible to use the current Orchestrator context of the Robot (No Auth) or connect to a different Orchestrator/Tenant, providing an Orchestrator.

Arguments
  • Required StrQueueName The Orchestrator Queue Name.
  • Required StrReportDestionationPath The location where the xlsx report will be saved Required (with Auth) StrOrchestratorServerURL The Orchestrator from where the queue report will be permformed (ex:http://platform.uipath.com/).
  • Required StrColumnMapping The expected report columns - See Column mapping Details bellow.
  • Required (with Auth) StrTenancyName The Orchestrator Tenant consider - Let Blank for 'Default' - The tenancy name is only considered if Auth is used.
  • Required (with Auth) StrCredentialName Criterion to determine if Auth is used - The Credentialname which will be used to pull Credential From either Orchestrator. or the Windows Crendential manager - The Solution is using GetAppCrendentials Workflow from ReFramework.
  • Optional DtmReportFrom The Date from when the Queue Items will be considered.
  • Optional DtmReportTo The Date until when the Queue Items will be considered.
Columns Mapping Details:
The column mapping will have to be specific as a CSV string to determine the data exported.
It is possible to export different type of data based on prefix
Prefixes / Description
data. Refer to the Specific content
exc. Refer to the exception property
output. Refer to the output data stored
No prefix Refer to a property of the Queue Item (ex: Status, Priority etc…)
Example of Column mapping strings:
Priority, Key, Status, exc.Details, exc.Type, exc.Reason
CreationTime, StartProcessing, EndProcessing, data.TransactionID, RetryNumber, output.ConfirmationNumber, exc.Details, exc.type, exc.reason
It is recommended to have a read on the API documention (example here) to see which properties will be available for extraction.

Benefits


Published: 04 Dec 2018 | Updated: 26 Oct 2020


License

MIT


Code Language

Visual Basic


Runtime

.NET Framework


Tags

data
excel
processing

Compatibility

Studio: 21.4+


Dependencies

None


Similar Listings