Upload a dataRow as a queue item

Help Orchestrator
,
1

I have a process that has an excel input as input.

I need to upload each of the excel rows separately as a queue item to the orchestrator.

How can I do it? Thank you

2

@Marisa_Ontiveros1

You can try with bulk add queue item activity

3

Yes, but in addition to the table rows, I need to add other data to the queue item, which is not from the input Excel

4

hi @Marisa_Ontiveros1 ,

Read your excel to a data table. Then use a for each row in datatable. Inside that use add queue item activity.

image

Let me know if you face any issues

edit: Replace testrow with currentrow

5

You will try Add queue item or Bulk queue item activity

6

give this error:
Add Queue Item: Could not determine JSON object type for type System.Data.DataRow.

7

hello @Marisa_Ontiveros1
you can read excel data by read range workbook activity and then Bulk Add Queue Items activity as shown below

Queue_forum

Hope This will help you,

Regards,
Dheerendra Vishwakarma

8

@Marisa_Ontiveros1

  1. Read Excel File:
  • Use the Read Range activity to read the Excel file and store its contents in a DataTable variable.
  1. Iterate Through Rows:
  • Use a For Each Row activity to iterate through each row of the DataTable variable.
  1. Create Queue Item:
  • Within the For Each Row activity, use the Add Queue Item activity to create a queue item for each row.
  • Set the Content property of the queue item to the current row’s data. You may need to convert the DataRow to a string or JSON format depending on your queue item content requirements.
  1. Upload Queue Item:
  • Use the Add Queue Item activity to upload the queue item to UiPath Orchestrator.
  • Configure the required properties of the Add Queue Item activity, such as the queue name and priority.
  1. Repeat:
  • Continue iterating through each row of the DataTable until all rows have been processed.