Hi All I have below QueueItems in Queue Reference : GUID Specific Data: First Name: UserFirstName1 Last Name: UserLastName1 Location: Location1 … I want to convert this queueitems (there are many) to datatable, However, I need below fields Reference, First Name and Last Name There are solu…

@vijayakumarkj please try this first use build datatable and create a datatable with 3 columns and name it dt dt = queueitems.Select(function(x) refdt.Rows.Add(New Object(){x.Reference,x.SpecificContent("FirstName").ToString,x.SpecificContent("LastName").ToString})).CopyToDataTable Hope this hel…

based on the following idea [image] How to convert ienumerable<queueItem> to datatable Studio 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 Sp…

Hi @vijayakumarkj use build the data table and create a new data table with the columns required Then for each row of queue items USe 3 assign activities for reference,Firstname,Last name then use item.SpecificContent(“Reference”).ToString() similarly for first name and last name… to get the val…

@Gayathri_Mk It should work by adding individual line item to queue using a loop. I was looking for a LINQ query to get the results in data table and add to Queue via bulk upload. Thank you VJ!

Hi @ppr , I tried to extend your previous response to include Queue Item reference, however it wasn’t successful. Thank you VJ!

Select few fields in QueueItems and convert to Datatable

Help Studio

ppr (Peter Preuss) November 17, 2023, 9:19am 2

based on the following idea

we can extend to handle also QI Properties e.g. Reference

But lets keep in mind: The JSON DataTable gerneration will derive the DataColumn DataTypes by checking first row values. This can lead to unwanted datatype calculations.

But combining different approaches, done in projects came out to reliable results

Topic		Replies	Views
How to convert ienumerable<queueItem> to datatable Studio	5	3582	February 3, 2023
Create datatable from queue items Studio orchestrator , activities , studio	7	1580	May 29, 2024
Queue Items Requests Related Something Else feedback	4	578	January 25, 2024
Storing queue items in a DataTable... Armazenar os itens de uma fila em um DataTable Activities datatable , orchestrator , activities , studio , question , data_service	14	537	January 9, 2024
How to write IEnumerable<QueueItem> to DataTable Activities datatable , uiautomation , activities , studio , question	9	566	July 19, 2024

Select few fields in QueueItems and convert to Datatable

Related topics