Hi Team,
Can someone tell me how to add complete data table into queue as a single transaction item?
Thanks
Hi Team,
Can someone tell me how to add complete data table into queue as a single transaction item?
Thanks
The ItemInformationCollection attribute of Add Que allows you to add Dictionary Items . It may be possible to add a Dictionary<String,DataTable> using which you may be able to do this.
I haven’t tried it, but it might work.
you can use “Output Datatable” activity to convert your datatable to a string which you can simply add to the queue, the string will be something like this
You can convert it back to a datatable by using “generate datatable activity”, you must tick the “CSV Parsing” property
Thankyou so much for your reply!!
Hi @Hitesh,
Adding to the answer from @jack.chan
There is an alternative way to achieve it using an assign activity and using YourDataTable.
YourQueueString
= Newtonsoft.Json.JsonConvert.SerializeObject(YourDataTable)
This way you can send YourQueueString
along with other data strings or datatable if you wish by building a overall ItemDataTable
and add rows with YourQueueString
and pass it to Add to Queue
or Bulk Add Queue Items
.
Summary
Dispacher: Datatable —> String —> Orchestrator
YourQueueString
= Newtonsoft.Json.JsonConvert.SerializeObject(YourDataTable)
Performer: Orchestrator —> String —> Datatable
QueueItemData = Newtonsoft.Json.JsonConvert.DeserializeObject(Of DataTable)(out_TransactionItem.SpecificContent("YourQueueString").ToString)
´
QueueItemData
will result as a Datatable.
You can do this by serializing and deserializing.
As @jeevith suggested way is the best way to make that happen.
This looks good , i will try this out,. thank you !!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.