Mention Queue Name For Reporting And Transform The Output Received From HTTP Request To Excel Sheet

News Knowledge Base
1

How to specify the queue name for which the reporting feature needs to be performed and also transform the output received from the HTTP request to Excel sheet?

Use the following link to access QueueDefinitions in Swagger: Queue Definitions

We are interested in the following POST API call:

image.png
The above API call takes Queue Definition ID as input and returns an Excel file with the items in the queue.

Follow the below steps to get the Queue Definition ID from the browser,

  1. Open Orchestrator and navigate to the Queue a report will be generated for:image.png
  2. Open the Network tab (CTRL+SHIFT+I) in the browser and click on the following API call record:image.png
  3. Navigate to the Preview tab and locate the ID of the Queue that will be targeted:image.png
  4. As well as the fid/Org unit ID:
image.png
  1. Return to Swagger, click "Try it out", enter the id into the "key" field and the "x-uipath-organizationunitid" into its respective field and click "Execute": image.png
  2. The result should look like the following and an Excel file will be downloaded to your machine:image.png

The URL should be in the following formats:

On-premise example: https://.com/swagger/ui/index.html#/

Cloud Platform example: https://cloud.uipath.com///swagger/index.html#/

More details on Orchestrator API usage can be found at Orchestrator Reference.