Get transaction item count and log it into excel

Hi @Anil_G I have tried what you said, thankyou for your help.

1 Like

Hi @Anil_G

For QueueItem I wanted to get ProcessingOption.Message
But I wasn’t able to.
I wanted to get the message
Before it was working now I’m getting this error.

Can you help me?

@BHUSHAN_NAGAONKAR1

As per error looks like either you are trying to get the exception value for successful item…for auccessful items it wont be available

Cheers

So how should I get the message now if I want to change flow from Succes and Failure

If Failure then get an Exception and log in excel?

@BHUSHAN_NAGAONKAR1

If check the status…if status is failed then get message…and if success dont get

Cheers

What should I pass as a variable? Any Function and What will be the variable type?

@BHUSHAN_NAGAONKAR1

In the if condition you need to use currentitem.status.Equals("Successful")

On else side it will be failed items…no other expression

Cheers

If I want to get Exception message?

@BHUSHAN_NAGAONKAR1

On else side use currentitem.processingexception.reason or message

Cheers

I’m getting same error on Failure side.

What should be my variable type?

GetQueueItem variable type is IEnumerable

NegativeException is “String”

@BHUSHAN_NAGAONKAR1

Your variable type will be string

can you log the status and check if it si failed or not

cheers

Ok, will do and let you know

Do I need to pass the check boxes in get Queueitem Success/Failure?

It is giving me both failed and Successful and I cannot pass .Message

@BHUSHAN_NAGAONKAR1

Can you please show or attach what you have done …and full info will be helpful to give the right solution

cheers






here is the complete flow

@Anil_G

While running it did the get me the status of first one but didn’t get for second one it gave me above error

@BHUSHAN_NAGAONKAR1

In get queu items did you select successful and failed only?

If not new and in progress also will come and they also wont have any completed details

Cheers

1 Like

Yes selected only two “Success” & Failure

@BHUSHAN_NAGAONKAR1

Message might be empty if not given…can you try with reason…this is a mandatory field

Also I beleive you are logging status and only when status is failed it is going to else condition

Cheers

CurrentItem.ProcessingException.Reason?

I have used there still getting an Exception