Create datatable from queue items

[meghana1929 (Megha1929)]

Hi all,

need a help on below scenario

I want to convert ienumerable of queueitem to datatable. not using for each row as i may have 50000 items in queue.

Thanks in Advance

[supermanPunch (Arpan)]

Hi @meghana1929 ,

Could you check the below post which also talks about the case similar to yours, Let us know if the below post was helpful.

How to convert ienumerable<queueItem> to datatable

We assume that get Queue Item->s is used here we would recommend to specify what is needed. QueueItems Properties e.g. Reference, Status,… SpecificContent infos Example: All SpecificContent Dictionaries to DataTable Assign Activity: dtData = JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)

[meghana1929 (Megha1929)]

Hi @supermanPunch ,

i tried above solution, but it is showing JArray is not declared. could you please help on this.

Thanks

[ppr (Peter)]

add the following namespaces to the imports:

[meghana1929 (Megha1929)]

Hi @ppr ,

Thank you it worked.
By this i am getting the only specific data contents, Can we also get the data under " Output Data" fields?

Thank you in Advance

[ppr (Peter)]

@meghana1929

Can we also get the data under " Output Data" fields?

Yes we can rework / extend it.

But we would recommend to more specify the targeted output needs. Maybe out of the box functionalities can also serve e.g. Export call via API…

[meghana1929 (Megha1929)]

@ppr, Sure will look into API as well, can you please help me to extend this code to get the output data fields data as well.

Thank You