Orchestrator - ItemInformation

orchestrator
queue

#1

Hello everyone, according to this training: UiPath Orchestrator 2016.2 Training, I´m trying to set Iteminformation collection to reflect real value from excel file (Data Table) … let me be more specific

Information from training:

The ItemInformation field is where the values of the transaction item can be added. This process works similarly to passing arguments to an invoked workflow. Press the Ellipsis button. An ItemInformation window enabling you to create an argument is displayed. Fill in the Value field by entering the information on the first column of the Data Table.

After this, I should be able to see data from DataTable in queue, but in fact, I´m only able to see constant values I wrote as arguments (strings or ints).

So my question is, how to set “Key” which will link all information from DataTable with QueueItem …

Thank you very much and if the question is answered already, sorry for that!

Best Regards

Jakub


#2

Hi @jakubvanhara, Bulk Upload Option to load the Queue might help you !

Regards,
Dominic :slight_smile:


#3

Hello and thank you @599712 Dominic, I am pretty sure it can help. But i dont know how to use JSONConvert.SerializeObject(dt), there is no such a stage as Serialize, only Deserialize. A with trying to write it in code … not sure how it should look

Any ideas?

Jakub


#4

To describe it more clearly, situation is, input file:

but when I populate the Queue I will get this:

Argument “Nakupni” a “Prodejni” is set as constant string but according to training it should be used as headers as kind of “key ID”. Or am I wrong?

Thank you

br
Jakub


#5

@jakubvanhara, use Assign activity with left hand side a string variable string str= JSON convert.SerializeObject(your output data table variable) and then in Add Queue item send this string variable

Regards,
DominicArulCollins


#6

@599712, well I think something is missing maybe in packages? Because I can use these activities:

activities

although I can´t use any of JSON command (such as Serialize) …

br
Jakub


#7

@jakubvanhara, To my knowledge I dont think there is a serialize activity. To meet your demands, just Import Newtonsoft.Json Namespace from Imports section. And then you will be able to use the code in assign activity.

Note: There is no activity for SerializeObject

Regards,
Dominic Arul Collins V :slight_smile: