How to convert ienumerable<queueItem> to datatable

ziad.adnan.nasif · February 3, 2023, 9:22am

I use Get Queue Item to get info from Orchestrator . I got output type ienumerable How can i convert it to DataTable

Anil_G · February 3, 2023, 9:23am

Build a datatablew ith required columns using build data table activity

Use for loop and loop ieum and change the type argument to queueitem

then inside the loop use add data row and add each data you need

Currentitem.SpecificContent("Name").ToString

cheers

ziad.adnan.nasif · February 3, 2023, 9:35am

It skips the loop without giving an error

ppr · February 3, 2023, 9:59am

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)

ziad.adnan.nasif · February 3, 2023, 10:30am

It worked well. Thank you @ppr

ppr · February 3, 2023, 10:31am

system · February 6, 2023, 10:32am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.