DT to QueueItem to DT again

[MikkelNielsen]

Hey everyone… As you know one cannot insert a datatable directly into a queue item’s collection.
Thus I found a way to serialize the DT as a (JSON)-string like this: strJsonDT = JsonConvert.SerializeObject(DT)

This string however, when pulled back from the queue item, I cannot figure out how to reverse back in to a DT like our original DT.
If I use the activity DeserializeJsonArrayt, I wind up with a jArray, and I’m not sure this is the right path.

Does anybody have a clever generic solution to this simple problem of basically trying to add a DT to a queue?

[muthuraj.c (Muthuraj)]

Hi,

Use Bulk Add Queue Items activity.

Thanks,
Muthuraj

[MikkelNielsen]

You misunderstand… I dont want to add each element of a DT to a Queue. I want to add many DT objects as queue items.

[kumar.varun2 (Varun Kumar)]

Hi @MikkelNielsen

For this

@MikkelNielsen

This string however, when pulled back from the queue item, I cannot figure out how to reverse back in to a DT like our original DT.

try

JsonConvert.DeserializeObject(Of DataTable)(strJsonDT)

@MikkelNielsen

If I use the activity DeserializeJsonArrayt, I wind up with a jArray, and I’m not sure this is the right path.

Change the TypeArgument to System.Data.DataTable in the Properties