Unable to get data from Excel to For each row

Help Studio
, ,
1

I have a excel sheet and i added queue and calling the excel data to for each row but i am unable to get it can anyone please help me

1
1622×720 21.9 KB

2
2806×757 27.9 KB

The image displays the debugging interface of an application, showing variables, exceptions, and an error message in the output panel stating "The given key 'valfrom' was not present in the dictionary." (Captioned by AI)
The image displays the debugging interface of an application, showing variables, exceptions, and an error message in the output panel stating "The given key 'valfrom' was not present in the dictionary." (Captioned by AI)437×700 21.1 KB

Forum Engagement Daily Reports
2

@bharadwaj.vuppalapati,

In recent updates Get Queue Items will not give you Specific Content and Output data. These values will be null.

Refer this article for alternative option for this.

1 Like
3

Can you try with “Get Transaction Item” activity.

4

yes I tried It and but i am unable to crack it

5

Can you share the screenshot.

6

@bharadwaj.vuppalapati,

With Get Transaction Item activity you will get Specific Content just check if your key is having additional “”.

Try with this

QueueItem.SpecificContent("""valfrom""").ToString

Also check TransactionItem.SpecificContent values in immediate or local panel while debugging.

7

Hey, try below:

You can use the following code to get the keys name from transaction item and then check if the key name given by you is correct or not

Log Message = String.Join(",",transaction_item.SpecificContent.Keys)

In above, transaction item is output variable of Get Transaction Item

8

The image shows a sequence of activities in a workflow, starting with reading data from a workbook file, followed by adding queue items in an orchestrator, and getting a transaction item from the queue. (Captioned by AI)
The image shows a sequence of activities in a workflow, starting with reading data from a workbook file, followed by adding queue items in an orchestrator, and getting a transaction item from the queue. (Captioned by AI)622×667 22.7 KB

The image shows a debugging interface with a highlighted exception message stating "Write Line: The given key 'val from' was not present in the dictionary." (Captioned by AI)
The image shows a debugging interface with a highlighted exception message stating "Write Line: The given key 'val from' was not present in the dictionary." (Captioned by AI)382×657 18.8 KB

9

@bharadwaj.vuppalapati,

Have you tried this and also show the transaction item in immediate window or locals where your keys will be visible

10

i tried it but unable to fetch the details

11

what is the output of this String.Join(“,”,transaction_item.SpecificContent.Keys) ?
if you are getting any error let us know