Storing queue items in a DataTable... Armazenar os itens de uma fila em um DataTable

[joao.g]

I’m trying to store the items from a queue into a DataTable. The activity I’ve attempted so far is the Orchestrator HTTP Request. I’m open to any ideas, but so far, I’ve had no success. The goal is to preferably retrieve items marked as “success.”

pt-br
Estou tentando armazenar os itens de uma fila em uma Datatable. A atividade que tentei até agora foi o Orchestrator HTTP Request. Estou aberto a qualquer ideia, mas até o momento sigo sem sucesso. A ideia é trazer preferencialmente os itens com “sucesso”

[ppr (Peter Preuss)]

@joao.g

to store the items from a queue into a DataTable.

here we would recommend to be more specific at which all data / properties are to store within the datatable

• Only SpecificContent Data
• with / without specific properties from the queue items

@joao.g

The goal is to preferably retrieve items marked as “success.”

we would use a filter to the status

[postwick (Paul)]

Use the Get Queue Items activity and filter on status.

Built Data Table to prepare for the data.

Loop through the IEnumerable it gives you, and use Add Data Row to add each item to the datatable.

[joao.g]

@ppr

here we would recommend to be more specific at which all data / properties are to store within the datatable

• Only SpecificContent Data
• with / without specific properties from the queue items

From each sucess item i need the keys like:

cod_emp: colun 1
Filial: colun 2
.
etc

[joao.g]

I tried i dont know how to convert the IEnumerable as the image bellow

[ppr (Peter Preuss)]

@joao.g

From each sucess item i need the keys like:

cod_emp: colun 1
Filial: colun 2
.
etc

when working with

@joao.g

Orchestrator HTTP Request

• Deserialize JSON Activity - out: myJObject
• Assign activity:
  dtData | DataTable =

Newtonsoft.Json.Linq.JArray.FromObject(myJObject("value").Select(Function (x) x("SpecificContent").ToObject(Of DataTable)

OR
we loop and populate defensive a datatable

OR
as mentioned by Paul using Get Queue Items activity and populate defensive a datatable

[ppr (Peter Preuss)]

Also have a look here:

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)

[postwick (Paul)]

You use the Array Row property and reference the IEnumerable.

{currentItem.SpecificContent(“Customer Name”).ToString,currentItem.SpecificContent(“Customer ID”).ToString}

[joao.g]

Could you please show me your actvityes propertie?

And for the Add data row :

That’s my error:
Argumento “DataRow”: BC30456: ‘SpecificContent’ is not a member of ‘DataTable()’.
Argumento “DataRow”: BC30456: ‘SpecificContent’ is not a member of ‘DataTable()’.
Argumento “DataRow”: BC36914: Cannot infer an element type, and Option Strict On does not allow ‘Object’ to be assumed. Specifying the type of the array might correct this error.

[postwick (Paul)]

You don’t loop through the datatable. You loop through the variable in your Get Queue Items output. That variable is IEnumerable(of QueueItem) so the properties of currentItem are the same as they would be for a queue item (ie you can use .SpecificContent)

[joao.g]

My output in Get Queu Items is “qItem”, as you can see in the screenshot i’m using it in “List of Items” on the loop.

In Add Data Row i’m using:
ArrayRow: currentItem.SpecificContent(“Cnpj”).ToString

the error is: Argumento “DataRow”: BC30311: Value of type ‘String’ cannot be converted to ‘DataRow’. O valor selecionado é incompatível com o tipo de propriedade.

in For each Argument Type i use UiPath.Core.QueuItem

[postwick (Paul)]

LinhaDados (Array Row) requires an array, not a single value. You are giving it a single value. An Array is a list of values with { and } around it, separated by commas:

{“Value1”,“Value2”,“Value3”} or of course you can use variables {Var1,Var2,Var3}. As you can see from my original reply:

{currentItem.SpecificContent(“Customer Name”).ToString,currentItem.SpecificContent(“Customer ID”).ToString}

And the number of items in that array has to match the number of columns in your datatable dt_Emp as defined by the Build Data Table activity (which I didn’t show).

[joao.g]

@postwick i was not using the activity build data Table

but now i have two colluns , but still have the problem.

Now i have a array and the error is:

Argumento “DataRow”: BC30311: Value of type ‘String()’ cannot be converted to ‘DataRow’. O valor selecionado é incompatível com o tipo de propriedade.

[ppr (Peter Preuss)]

@joao.g

Argumento “DataRow”: BC30311: Value of type ‘String()’ cannot be converted to ‘DataRow’.

keep in mind that in the different localizations the settings can have different positions.

Instead of LinhaDados use LinhaMatrix like
new Object(){colVal1, colVal2…}

[joao.g]

Hello @ppr, thank you! It was just a linguistic problem. Now the @postwick tip worked!! Thank you so much, guys!