Problem with Walkthrough – Calculate Client Security Hash page 10

[luchovelez (Luis Velez)]

Open the Framework\GetTransactionData workflow o Update the annotation for the current process. o Add an input argument for the array of Work Items. o Remember that our Transaction Item is one object in the Work Item array. We can have a new transaction only if the transaction number is less than or equal to the index of the array element. o Add an If activity to check if there is any new transaction to process.
In the Then section, use an Assign activity to set the value of the output Transaction Item argument according to its index.
In the Else section, set the Transaction Item value to Nothing.
o This is what the Get Transaction Data sequence looks like:

[ovi (Viorela Preda)]

@luchovelez

Remember that our Transaction Item is one object in the Work Item array.

Please check this again. The error is correct.

[luchovelez (Luis Velez)]

@ovi

mber that our Transaction Item is one object in the Work Item array.

how can i resolve this

[alejo1410 (Alejandro Grajales Alvarez)]

I have the same error, I do not know how to convert a DataRow into QueueItem, please if you solve it publish the answer

[ovi (Viorela Preda)]

Hi guys,

I know it can get frustrating, but please pay more attention to details. The work item is a DataRow array. So the Transaction Item being an object in the work item array => try changing the variable type of TransactionItem to DataRow.

Let me know if it works. Cheers!

[alejo1410 (Alejandro Grajales Alvarez)]

the data type was changed but now the error is in the activity Get Transaction Item showing the same error

[luchovelez (Luis Velez)]

same error here datarow can´t be converted in queueItem the error its solved in the assign activity, but appear in add queueitem activity

[ovi (Viorela Preda)]

Get transaction item is present in the Framework. The annotation says: Description: Get data from spreadsheets, databases, email, web API or UiPath server queues.
So, in the Walkthrough, it is stated: This is what the Get Transaction Data sequence looks like(and screenshot inserted there, without that activity)
Remove that activity and check.

[carloshoribeiro (Carlos Henrique Ribeiro)]

Hey Guys, did you resolve it ?

[carloshoribeiro (Carlos Henrique Ribeiro)]

could somebody help me ?
@ovi
@luchovelez
@andrzej.kniola
@badita

[andrzej.kniola (Andrzej Knioła)]

@carloshoribeiro

So you’re asking how to convert Datarow to DataTable?
So in essence how to Copy (it) To Data Table?

[ClaytonM]

Hey, if you want to create a new datatable with the filtered rows, just put .CopyToDataTable on the end (like @andrzej.kniola hinted at lol).

However, if you just want to process those rows but keep the original datatable then I would recommend processing the rows as an array of datarows, and you can also change WList to the type Array[DataRow] if that’s the case, which will let you change values in the row which updates the original datatable.

Regards.

[carloshoribeiro (Carlos Henrique Ribeiro)]

@ClaytonM Good idea! Did you do it ? like above, right ?

[carloshoribeiro (Carlos Henrique Ribeiro)]

Guys, am I in the right way ?

[carloshoribeiro (Carlos Henrique Ribeiro)]

I change the “out_TransactionItem” argument with type of var “QueueItem” to “DataRow” type of var.

AND

To exclude the “Get Transaction Item” from the workflow.

ThankU All !!!

[krishna_reddy]

Hi,
I need a help How would i config excel file Claculate_Client_SecurityHash can you send me your config file

Regards

[luchovelez (Luis Velez)]

Config.xlsx (12.9 KB)

[luchovelez (Luis Velez)]

carlos how you do the transaction id ?

[Zara (ZaraKhan)]

@ovi

Remove that activity and check.

Hi,
Even I have stucked here.
i am unable to retrieve this Wlist . How did u do that?

[krishna_reddy]

Thank You
Luchovelez