How to create a queue-item with several item information

[stefi]

Hi,
I want to book invoices in SAP.
The input data for the invoices are given via an Excel file, in the following example all needed invoice data is given in the yellow columns:

The column headers in line 10 are always the same, only the starting cell, where the invoice data/the columns begin, is variable and will be recognized by the first column named “invoice no.”, here in the example the starting cell is B10.
So in the example the invoice data range is B10:K20.

Each line represents an invoice item.
Here in the example:

• Line 11 is the first invoice (recognized by column “invoices no.”) and has only one invoice item (because in line 12 there is another entry in column “invoices no.”).
• Line 12+13 is the second invoice and contains two invoice items, recognized again by column “invoices no.”.
• The third invoice contains three invoices items (lines 14-16).
• etc…

Because the number of lines with invoice data is very variable and can therefore contain a lot of items, I would like to add each invoice group as single queue-item to Orchestrator which will be processed by another process.
This has the advantage that the queue-items can be processed in parallel.

For the queue-item the storage path of the file is necessary because after invoice booking the booking number must be written back to the file in column “booking number”.
In case of invoice groups with more than one invoice item, the same booking number must be written back in all lines of the invoice group.

In my solution I did the following steps so far:

1. Read Range Workbook: Read Excel file and store invoice data to datatable-variable “dt”
2. Invoke code: Group invoice data to invoice groups based on the ID in column “invoices no.” and store groups to list-variable “list_invGroups”
3. For each: In the Body I added “Add Queue Item” but here is my problem:
   What should be given as Item Information so that the other process which edits the queue-items knows which lines should be used for invoice booking?

As one key-value pair I already added the storage path of the file:

How can I add the invoice data (all yellow columns) and the line number / index to the queue-item?

Thank you for your help!

[ashokkarale]

@stefi,

If you are reading the file in dispatcher already, reading again in the performer will be rework. What you can do is

1. read the data in dispatcher into a datatable
2. Serialize it using this code: JsonConvert.SerializeObject(DataTableVariable)
3. Add to queue item as text. This will give you JSON string
4. In performer, deserialize the the json with this code:
   JsonConvert.DeserializeObject(Of DataTable)(transactionItem.SpecificContent("InvoiceData").ToString())

[stefi]

How is it possible to serialize it? The function “JsonConvert” does not exist, but I already installed the UiPath.WebAPI.Activities package…

[ashokkarale]

@stefi,

Import the namespace: Newtonsoft.Json or use like this Newtonsoft.Json.JsonConvert.SerializeObject(DataTableVariable)

[Anil_G (Anil Gorthi)]

@stefi

its better you simply add the file apth and the invoice number…and based on the number you can get all the rows matching the invoice number

cheers

[stefi]

How can I retrieve in the second process (invoice booking) the rows matching the invoice number and the column headers? I need the column headers in order to know in which field to type in the data in SAP.

[Anil_G (Anil Gorthi)]

@stefi

read the data into datatable and filter with invoice number

cheers