Transaction Item to DataTable Row

[elliot.barling]

Good Afternoon,

I am extracting a transaction from a queue. It contains 6 ‘column’ within the item containing various pieces of information.
When I have finished processing the transaction and gathered more information relating to the item I would like to either:
a) Update the queue item with the new data (will be a new column) so once the queue items are all updated it can be put into an excel sheet.
b) add the transaction item to a datatable and update the extra column and add each transaction item in turn to this datatable so it can be put into excel

I appreciate there are some restrictions around updating queue item data for orchestrator so I am looking into option b as potentially the best option?

[Nitesh (Nitesh Kumar)]

Hi @elliot.barling ,

I will try doing the following way:

→ You can try adding reference (With Unique value) to that particular queue item.

→ Once my all queue items are processed → Get Queue Items → Build our own custom data table(by adding extra columns) → Add Data Row → Write to excel.

Hope this helps.

BR,
NK

[acyap314]

As of now, I think there’s no feature to do Option A. Option B is your best bet.
You could convert the items in the TransactionItem to a List(Of String) variable using the following method:

TransactionItem.SpecificContent.Select(Function(item) item.Value.ToString).ToList

You could then add additional data to the TransactionItemList using Append Items Collection activity:

You could add as many data to the list as needed. Once completed, you could add the TransactionItemList as a row to a DataTable that you have built with the matching columns that you need.

I hope this helps your case.

Cheers!

[Anil_G (Anil Gorthi)]

@elliot.barling

Option A is possible using postpone and then orchetsrator api

But if the ultimate goal is to write to excel then there is mo point in doing option A all together

Cheers

[furkan.cosan]

Hi @elliot.barling,

For Option A, you can update the queue item’s content with new data using the Orchestrator API. After processing, you could create a table based on the SpecificContent keys in each queue item, adding these values as rows. This way, the data is updated in the queue item and can also be easily transferred to Excel.

In Option B, you would create a DataTable using the SpecificContent keys and any additional columns needed. Then, add values for each key as a new row in the DataTable, allowing you to write the data directly to Excel.

If the main goal is to export to Excel, Option B might be more practical.

Hope this helps.

Regards,
Furkan