How to convert IEnuberable into Datatable

[Salman_Faries]

Hi,

I have uploaded Datatable in queue by converting it into JSON.

Now, i want to retrieve it as datatable. I have used “get Queue Item” Activity and got it as IEnumerble variable. Then, What i need to do?

[Parvathy (PS Parvathy)]

Hi @Salman_Faries

Check out this thread. It might help you.

How to convert iEnumerable into datatable

Hi All I have used get Queue item activity in UiPath and i got the output ienumerable values, how do i convert into datatable without loop? Can anyone suggest me how do i do that?

Regards,

[pravallikapaluri]

@Salman_Faries

I have uploaded Datatable in queue by converting it into JSON.

Now, i want to retrieve it as datatable. I have used “get Queue Item” Activity and got it as IEnumerble variable. Then, What i need to do?

Hi @Salman_Faries
Check the below thread,it might help you

Converting Queue into datatable

Hi, I would like to build datatable for the following scenario. Using Get transaction i will be fetched the queue item. My Queue Item will have a single row of data. Now i want to convert my queue item into datatable. How can i do that? @Palaniyappan

[efelantti]

Assuming your queueitem variable is named “queueItem”, you can deserialize it like this:

dt = Newtonsoft.Json.JsonConvert.DeserializeObject(Of DataTable)(queueItem.SpecificContent("yourKey").ToString)

[Salman_Faries]

Hey,

Newtonsoft.Json.Linq.JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)

1. i understand this, Where i need to put my queue item here?
2. Also i need to add any namespace?

please tell.

[Parvathy (PS Parvathy)]

@Salman_Faries

Check out this thread. This will help you

Converting Queue into datatable

Here you go with an xaml GetAllQueueItems.xaml (7.9 KB) Cheers @monish06

Regards

[Salman_Faries]

Hi,

By doing for each the only way to do this?