**YouTube** is an American [online video-sharing](https://en.wikipedia.org/wiki/Video_hosting_service "Video hosting service") [platform](https://en.wikipedia.org/wiki/Web_platform "Web platform") headquartered in [San Bruno, California](https://en.wikipedia.org/wiki/San_Bruno,_California "San Bruno, California")

cf3f59da-c081-4fab-99d2-f02e60e183b0.PNG

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](https://platform.uipath.com/swagger/ui/index#!/QueueItems/QueueItems_GetById)) to see which properties will be available for extraction.

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

61cce71c-d269-483f-8020-f6c4e0cf3dd2.JPG

c08498c1-d1c1-46eb-83f2-102b246dd7b8.jpg

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Symphony - Queue Reporting