How to add each DataRow of a Datatable to Queue as separate Transaction Items?

[Ayush_Raj]

Hi All,

I have a datatable and I want to upload each of its row as a single transaction item on to Queue. How can I do that ?
Is there any functions available or do I need to create a each key value pair for current row columns?
And also will I be able to fetch each column using Specific Content method on transaction item?

[vrdabberu (Varunraj Dabberu)]

Hi @Ayush_Raj

use the for each row in data table and within that use the add queue item activity and you can pass each row into the queue as a single transaction item.

->Pass the queue name that you created in the orchestrator into the queue name field.
->by clicking the item information you get the popup as shown in the left side so in the key field give the key names(String) so that it helps in the process state for getting a specific value and in the value field pass the CurrentRow(“ColumnName”).ToString.

Regards

[rlgandu (Rajyalakshmi Gandu)]

@Ayush_Raj

Need solution for Add Queue items multiple set of data into one queue items

@Vicky_K This is my input sample: [image] Main.zip (4.8 KB) [image] Hope this will help you

[pravallikapaluri]

@Ayush_Raj

Check the below thread

How to add a System.Data.DataRow variable into a work queue?

I am trying to add rows of information extracted from an excel sheet and stored in a datatable into a work queue. I am using a For Each Row Activity to loop through the data table and I have the Add Queue Item Activity within the body. I have setup a System.Data.DataRow argument within the Item Information section of the Add Queue Item Activity but I keep getting the following error message: “Could not determine JSON object type for type System.Data.DataRow”. What is the correct method for add…