Hi All
I want to extract the details/data from Orchestrator queue for one month as a report. can anyone suggest how to do that?
Hi All
I want to extract the details/data from Orchestrator queue for one month as a report. can anyone suggest how to do that?
Hi @divya.17290 ,
You can do this by using the /odata/QueueDefinitions(QUEUE_ID)/UiPathODataSvc.Reports
endpoint.
GET for
https://cloud.uipath.com/your_org_name/your_tenant_name/orchestrator_/odata/QueueDefinitions(YOUR_QUEUE_ID)/UiPathODataSvc.Reports?$top=1000&$expand=Robot,ReviewerUser&$orderby=Id%20desc
check more detail
I can export the CSV file from orchestrator Queue but it has json values , how do i get the proper string format
Hi @divya.17290
If you’ve exported a CSV file from an Orchestrator queue, and the data in the CSV contains JSON values that you want to convert to a proper string format, you can use UiPath to preprocess the data. Here’s how you can do it:
row("ColumnName")
).stringValue
) of type String to store the result.stringValue
.stringValue
variable. For example:row("ColumnName") = stringValue
By following these steps, you can convert JSON values in the CSV file to proper string format within your UiPath workflow before further processing or exporting the data.
Thanks!!
Data will come in the json format only…we need to extract them separately
If you dont want like that…then try using get queue items activity or api end point …that should solve
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.