Write queueitems to excel

Help
1

Hi Community

I need to write the transactionitems, which are processed today from the queue to excel.

Basicly i need the reference and status of the item. Could you provide me with an example. I tried the solution seen below, but cant figure how to configure the ‘arrayrow’ in the ‘add to queue’ activity. I get the error ‘Add Data Row: The given key was not present in the dictionary’

Alternatively how could i write the status report similar to the one you can export with the export button in orchestrator

my example:
QtoExcel.zip (496.7 KB)

Reference:

2
  1. Build DataTable
  2. Get Queue Items
  3. For Each
    3.1 Add Data Row (use property Array Row like this { QueueItem.Reference, QueueItem.Status }
  4. Write Range
3

hi @bcorrea

Thank you for the answer

Maybe i dont get it, but i still get an error on array row

image
image892×545 17.9 KB

the error is:

image

4

that was an example, in your case will be item.Reference, item.Status and you need to change the type for the loop to QueueItem

1 Like
5

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