How to convert iEnumerable into datatable

Help Studio
, ,
1

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?

2

With loop

  1. Build Data Table (Create an empty DataTable with the desired columns)
  2. For Each item in IEnumerable
    a. Add Data Row (Add each item to the DataTable)

With out loop you can try this way

YourIEnumerableVariable.CopyToDataTable()

@divya.17290

3

Hi @divya.17290 ,

Could you maybe check with the below post :

4

He suggest the querry " JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)" but i got error for JArray not declared

5

I got error

image
image1366×768 59.9 KB

6

Can you try this

Assign Activity:
dtData =

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

@divya.17290

7

How do i declare JArray?

8

I got error

image
image1366×768 62.6 KB

9

@divya.17290 ,

Modifying it a bit to add the namespace, could you check the below expression :

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

Could have also performed a Import from the Import Panels which should able us to use the Expression suggested earlier :
image

1 Like
10

I can extract the queue items and write into the excel.Thanks!

1 Like
11

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