Item collection in add queue item

[Sira]

Hi all, I’m using add queue items and i need to enter the data it will contain. Item collection how do I write the information there? Ex the date, status, etc. any example?

[Anil_G (Anil Gorthi)]

@Sira

You can either pass a dictionary to item collection…key would be the key you need and value would be the actual value you want to assign

Or use item information and directly add arguments as each field

Cheers

[Sira]

Could u please show me an example i am new on this. I am confused i want to store status,

[Sira]

[postwick (Paul)]

You create a Dictionary(Of String, Object) variable and populate it, then pass that variable as the Item Collection.

[Sira]

Create an assign for each item?

[Anil_G (Anil Gorthi)]

@Sira

Instead of item collection, use item jnformation property…there it is easy to create the firlds instead of creating a dictionary

Cheers

[Sira]

Can i do a item information without a for each loop?

[Anil_G (Anil Gorthi)]

@Sira

If you need to add multiple queue items then you need to use for loop

Cheers

[ashokkarale]

@Sira,

Prepare Dictionary and pass it to Add Queue Item’s Item Collection Property.

Sample dictionary initialized:
new Dictionary(Of String, Object) From {{"Date",now},{"Status","New"},{"Id",12345}}

Output:

Thanks,
Ashok

[Sira]

Im getting error from the assign

[Sira]

Im reading the information from a excel sheet could that be a reason. Or the variable type what should that be?

[Sira]

What would the variable type be new dictionary using assign activity

[ashokkarale]

@Sira,

It should be Dictionary(Of String, Object)

[Sira]

What about the variable type ? I am using a data table to read the information from
The row

[ashokkarale]

@Sira,

dictionary variable should be of datatype:

@Sira

I am using a data table to read the information from
The row

You can follow below thread to convert Datatable to dictionary.

Convert Datatable to Dictionary

@ZARA_Clark_Vincent_M Welcome to the forum: find starter help here: DataTable_2Col_ToDictionary.xaml (6.5 KB) In general it is about: use assign left side your dict right side: YourDataTableVar.AsEnumerable.ToDictionary(Of String, String)(Function (r) r(YourKeyCol).toString, Function (r) r(YourValueCol).toString)

Thanks,
Ashok

[Sira]

I need it to read the whole datatable

[ashokkarale]

@Sira,

Do you mean you want to add whole datatable as SpecificContent of a single TransactionItem?

[Sira]

Yes , so i have the excel with information and each row has item status, name, etc. i need the add queue item to just read each excel row add to the queue.

[ashokkarale]

@Sira,

Here is sample end to end workflow.

Sample Code:
Add Queue Items.zip (9.5 KB)

Input:

Output:

Thanks,
Ashok